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_EXTERNAL_CREDIT_PVT dependencies on DUAL

Line 353: FROM DUAL

349: and address_status='A' --2752321
350: AND CUSTOMER_ID IN
351: (
352: SELECT p_customer_id
353: FROM DUAL
354: UNION
355: SELECT CUST_ACCOUNT_ID
356: FROM HZ_CUST_ACCT_RELATE
357: WHERE RELATED_CUST_ACCOUNT_ID = p_customer_id

Line 458: -- select userenv('CLIENT_INFO') into l_org from dual;

454: RETURN l_bill_to_site_use_id;
455: ELSE
456: oe_debug_pub.add('not found');
457: -- comment out the following call for MOAC
458: -- select userenv('CLIENT_INFO') into l_org from dual;
459: -- oe_debug_pub.add('org='||l_org);
460:
461: SELECT /* MOAC_SQL_NO_CHANGE */ ORGANIZATION_ID
462: INTO l_bill_to_site_use_id

Line 478: FROM DUAL

474: AND STATUS = 'A'
475: and address_status='A' --2752321
476: AND CUSTOMER_ID IN
477: (SELECT p_customer_id
478: FROM DUAL
479: UNION
480: SELECT CUST_ACCOUNT_ID
481: FROM HZ_CUST_ACCT_RELATE
482: WHERE RELATED_CUST_ACCOUNT_ID = p_customer_id