EBS_OM_Customer: Find Customer information base on SO

SQL查询案例解析

最新推荐文章于 2024-01-30 10:39:53 发布

原创最新推荐文章于 2024-01-30 10:39:53 发布 · 221 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#EBS OM Customer ship

EBS OM 专栏收录该内容

1 篇文章

订阅专栏

本文介绍了一个具体的SQL查询案例，展示了如何从多个表中联接数据并筛选特定订单的信息。通过这个例子，读者可以了解到如何使用WHERE子句进行条件匹配以及如何连接不同表来获取所需的数据。

select ooh.order_number,
       raa_su.org_id,raa_su.site_use_id,
       raa_loc.address1 address, 
       raa_ps.party_site_number site_number
FROM apps.oe_order_headers_all ooh,
     apps.hz_cust_site_uses_all raa_su,
     apps.hz_cust_acct_sites_all raa_as,
     apps.hz_party_sites raa_ps,
     apps.hz_locations raa_loc
WHERE raa_su.org_id = ooh.org_id
  AND raa_su.site_use_id = ooh.deliver_to_org_id
  AND raa_su.site_use_code = ‘SHIP_TO'
  AND raa_as.cust_acct_site_id = raa_su.cust_acct_site_id
  AND raa_as.status = 'A'   
  AND raa_ps.party_site_id = raa_as.party_site_id
  AND raa_loc.location_id = raa_ps.location_id
  AND ooh.order_number = '1013473'
  AND ooh.org_id = 2202