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

Line 199: FROM DUAL

195: and address_status='A' --2752321
196: AND CUSTOMER_ID IN
197: (
198: SELECT p_exposure_rec.bill_to_customer_id
199: FROM DUAL
200: UNION
201: SELECT CUST_ACCOUNT_ID
202: FROM HZ_CUST_ACCT_RELATE
203: WHERE RELATED_CUST_ACCOUNT_ID = p_exposure_rec.bill_to_customer_id

Line 313: /*select userenv('CLIENT_INFO') into l_org from dual;

309: RETURN l_bill_to_site_use_id;
310: ELSE
311: oe_debug_pub.add('not found', 5);
312: --MOAC Changes
313: /*select userenv('CLIENT_INFO') into l_org from dual;
314: oe_debug_pub.add('org='||l_org, 5);*/
315: --MOAC Changes
316: SELECT /* MOAC_SQL_NO_CHANGE */ ORGANIZATION_ID
317: INTO l_bill_to_site_use_id

Line 333: FROM DUAL

329: AND STATUS = 'A'
330: and address_status='A' --2752321
331: AND CUSTOMER_ID IN
332: (SELECT p_exposure_rec.bill_to_customer_id
333: FROM DUAL
334: UNION
335: SELECT CUST_ACCOUNT_ID
336: FROM HZ_CUST_ACCT_RELATE
337: WHERE RELATED_CUST_ACCOUNT_ID = p_exposure_rec.bill_to_customer_id