DBA Data[Home] [Help]

APPS.OE_CREDIT_CHECK_ORDER_PVT dependencies on HZ_CUST_ACCT_SITES_ALL

Line 3190: , HZ_CUST_ACCT_SITES_all cas

3186: INTO l_own_customer_id
3187: , l_order_site_use_id
3188: , l_party_id -------------------new (FPI)
3189: FROM HZ_CUST_SITE_USES_ALL su
3190: , HZ_CUST_ACCT_SITES_all cas
3191: , hz_cust_accounts_all ca --------------new (FPI)
3192: WHERE su.site_use_id = p_header_rec.invoice_to_org_id
3193: AND cas.CUST_ACCT_SITE_ID = su.CUST_ACCT_SITE_ID
3194: AND cas.cust_account_id=ca.cust_account_id; ---------new (FPI)