DBA Data[Home] [Help]

APPS.OE_CREDIT_CHECK_LINES_PVT dependencies on HZ_CUST_ACCT_SITES_ALL

Line 4506: FROM HZ_cust_acct_sites_all cas

4502: SELECT /* MOAC_SQL_CHANGE */ cas.cust_account_id
4503: , ca.party_id --------------new (FPI)
4504: INTO l_own_customer_id
4505: , l_party_id --------------new (FPI)
4506: FROM HZ_cust_acct_sites_all cas
4507: , HZ_cust_site_uses su
4508: , hz_cust_accounts_all ca --------------new (FPI)
4509: WHERE su.site_use_id = c_site.site_use_id
4510: AND cas.cust_acct_site_id = su.cust_acct_site_id