DBA Data[Home] [Help]

APPS.OKS_CUSTOMER_ACCEPTANCE_PVT dependencies on HZ_CUST_ACCT_SITES_ALL

Line 1825: hz_cust_acct_sites_all sa,

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
1829: AND sa.party_site_id = st.party_site_id

Line 3860: hz_cust_acct_sites_all sa,

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
3864: AND su.cust_acct_site_id = sa.cust_acct_site_id