DBA Data[Home] [Help]

APPS.OE_CREDIT_CHECK_ORDER_PVT dependencies on HZ_CUST_SITE_USES_ALL

Line 2942: FROM HZ_CUST_SITE_USES_ALL su

2938: , ca.party_id --------------------new (FPI)
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