eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OE_CREDIT_CHECK_ORDER_PVT dependencies on HZ_CUST_ACCT_SITES

Line 2494: HZ_CUST_ACCT_SITES ACCT_SITE

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'
2497: AND SITE.CUST_ACCT_SITE_ID = ACCT_SITE.CUST_ACCT_SITE_ID
2498: AND ACCT_SITE.PARTY_SITE_ID = PARTY_SITE.PARTY_SITE_ID

Line 2505: HZ_CUST_ACCT_SITES ACCT_SITE

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'
2508: AND SITE.CUST_ACCT_SITE_ID = ACCT_SITE.CUST_ACCT_SITE_ID
2509: AND ACCT_SITE.PARTY_SITE_ID = PARTY_SITE.PARTY_SITE_ID

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)