DBA Data[Home] [Help]

APPS.OE_CREDIT_CHECK_LINES_PVT dependencies on HZ_CUST_ACCT_SITES_ALL

Line 3965: FROM HZ_cust_acct_sites_all cas

3961: SELECT /* MOAC_SQL_CHANGE */ cas.cust_account_id
3962: , ca.party_id --------------new (FPI)
3963: INTO l_own_customer_id
3964: , l_party_id --------------new (FPI)
3965: FROM HZ_cust_acct_sites_all cas
3966: , HZ_cust_site_uses su
3967: , hz_cust_accounts_all ca --------------new (FPI)
3968: WHERE su.site_use_id = c_site.site_use_id
3969: AND cas.cust_acct_site_id = su.cust_acct_site_id