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_PARTY_SITES

Line 2493: HZ_PARTY_SITES PARTY_SITE,

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

Line 2504: HZ_PARTY_SITES PARTY_SITE,

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