DBA Data[Home] [Help]

APPS.OE_CREDIT_CHECK_ORDER_PVT dependencies on HZ_CUST_SITE_USES_ALL

Line 2492: FROM HZ_CUST_SITE_USES_ALL SITE,

2488: OE_DEBUG_PUB.Add('slagiset: l_credit_profile_level ' || l_credit_profile_level);
2489: IF x_credit_level = 'CUSTOMER' AND l_credit_profile_level ='CUSTOMER' THEN
2490: SELECT acct_site.cust_account_id
2491: INTO l_new_cust_account_id
2492: FROM HZ_CUST_SITE_USES_ALL SITE,
2493: HZ_PARTY_SITES PARTY_SITE,
2494: HZ_CUST_ACCT_SITES ACCT_SITE
2495: WHERE SITE.SITE_USE_ID = OE_CREDIT_CHECK_UTIL.G_CC_Invoice_tab(i).new_invoice_to_org_id
2496: AND SITE.SITE_USE_CODE = 'BILL_TO'

Line 2503: FROM HZ_CUST_SITE_USES_ALL SITE,

2499: AND SITE.ORG_ID = ACCT_SITE.ORG_ID;
2500:
2501: SELECT acct_site.cust_account_id
2502: INTO l_old_cust_account_id
2503: FROM HZ_CUST_SITE_USES_ALL SITE,
2504: HZ_PARTY_SITES PARTY_SITE,
2505: HZ_CUST_ACCT_SITES ACCT_SITE
2506: WHERE SITE.SITE_USE_ID = OE_CREDIT_CHECK_UTIL.G_CC_Invoice_tab(i).old_invoice_to_org_id
2507: AND SITE.SITE_USE_CODE = 'BILL_TO'

Line 3189: FROM HZ_CUST_SITE_USES_ALL su

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