DBA Data[Home] [Help]

APPS.OKS_CUSTOMER_ACCEPTANCE_PVT dependencies on HZ_CUST_SITE_USES_ALL

Line 1823: hz_cust_site_uses_all su,

1819:
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

Line 3811: hz_cust_site_uses_all su,

3807: ca.cust_account_id,
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