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
EBS_OM_Customer: Find Customer information base on SO
最新推荐文章于 2020-08-06 17:15:45 发布