DBA Data[Home] [Help]

APPS.OKS_CUSTOMER_ACCEPTANCE_PVT dependencies on HZ_CUST_SITE_USES_ALL

Line 1824: hz_cust_site_uses_all su,

1820:
1821: CURSOR csr_billing_address_id IS
1822: SELECT st.party_site_id
1823: FROM okc_k_headers_all_b okc,
1824: hz_cust_site_uses_all su,
1825: hz_cust_acct_sites_all sa,
1826: hz_party_sites st
1827: WHERE okc.bill_to_site_use_id = su.site_use_id
1828: AND su.cust_acct_site_id = sa.cust_acct_site_id

Line 3859: hz_cust_site_uses_all su,

3855: ca.cust_account_id,
3856: ca.party_id
3857: FROM okc_k_headers_all_b okc,
3858: oks_k_headers_b oks,
3859: hz_cust_site_uses_all su,
3860: hz_cust_acct_sites_all sa,
3861: hz_cust_accounts_all ca
3862: WHERE oks.chr_id = okc.ID
3863: AND okc.bill_to_site_use_id = su.site_use_id