DBA Data[Home] [Help]

APPS.OE_CREDIT_CHECK_ORDER_PVT dependencies on HZ_CUST_ACCT_SITES_ALL

Line 2943: , HZ_CUST_ACCT_SITES_all cas

2939: INTO l_own_customer_id
2940: , l_order_site_use_id
2941: , l_party_id -------------------new (FPI)
2942: FROM HZ_CUST_SITE_USES_ALL su
2943: , HZ_CUST_ACCT_SITES_all cas
2944: , hz_cust_accounts_all ca --------------new (FPI)
2945: WHERE su.site_use_id = p_header_rec.invoice_to_org_id
2946: AND cas.CUST_ACCT_SITE_ID = su.CUST_ACCT_SITE_ID
2947: AND cas.cust_account_id=ca.cust_account_id; ---------new (FPI)