DBA Data[Home] [Help]

APPS.OKS_CUSTOMER_ACCEPTANCE_PVT dependencies on HZ_CUST_ACCT_SITES_ALL

Line 1824: hz_cust_acct_sites_all sa,

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

Line 3812: hz_cust_acct_sites_all sa,

3808: ca.party_id
3809: FROM okc_k_headers_all_b okc,
3810: oks_k_headers_b oks,
3811: hz_cust_site_uses_all su,
3812: hz_cust_acct_sites_all sa,
3813: hz_cust_accounts_all ca
3814: WHERE oks.chr_id = okc.ID
3815: AND okc.bill_to_site_use_id = su.site_use_id
3816: AND su.cust_acct_site_id = sa.cust_acct_site_id