SQL for Customer Accounts with PO and Bill To Location
SELECT hcsa.LOCATION, hca.account_number
,oeh.order_number,oeh.cust_po_number
FROM apps.hz_cust_site_uses_all hcsa,
apps.hz_cust_acct_sites_all hcas,
apps.hz_party_sites hps,
apps.hz_parties hp,
apps.hz_cust_accounts hca,
apps.oe_order_headers_all oeh
WHERE 1 = 1
AND hcas.cust_acct_site_id = hcsa.cust_acct_site_id
AND hps.party_site_id = hcas.party_site_id
AND hp.party_id = hps.party_id
AND hca.cust_account_id = hcas.cust_account_id
AND hcas.org_id = 82
AND hca.account_number in (‘44241.102751’)
AND site_use_code = ‘BILL_TO’
and site_use_id=invoice_to_org_id
AND oeh.sold_to_org_id = hca.cust_account_id;
Recent Posts