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

Line 251: FROM DUAL

247: BEGIN
248:
249: SELECT /* MOAC_SQL_NO_CHANGE */ 'Y'
250: INTO l_duplicate_exists
251: FROM DUAL
252: WHERE EXISTS (SELECT 'Y'
253: FROM OE_ORDER_HEADERS
254: WHERE HEADER_ID <> p_header_id
255: AND SOLD_TO_ORG_ID = p_sold_to_org_id

Line 704: Select p_header_rec.sold_to_org_id from dual

700: From oe_ship_to_orgs_v
701: WHERE site_use_id = p_header_rec.ship_to_org_id
702: AND
703: customer_id in (
704: Select p_header_rec.sold_to_org_id from dual
705: union
706: select cust_account_id from
707: HZ_CUST_ACCT_RELATE
708: Where related_cust_account_id = p_header_rec.sold_to_org_id

Line 803: SELECT p_header_rec.sold_to_org_id FROM DUAL

799: WHERE SITE.SITE_USE_ID = p_header_rec.deliver_to_org_id
800: AND SITE.SITE_USE_CODE ='DELIVER_TO'
801: AND SITE.CUST_ACCT_SITE_ID = ACCT_SITE.CUST_ACCT_SITE_ID
802: AND ACCT_SITE.CUST_ACCOUNT_ID in (
803: SELECT p_header_rec.sold_to_org_id FROM DUAL
804: UNION
805: SELECT CUST_ACCOUNT_ID FROM
806: HZ_CUST_ACCT_RELATE_ALL R WHERE
807: R.ORG_ID = ACCT_SITE.ORG_ID

Line 879: Select p_header_rec.sold_to_org_id from dual

875: From oe_invoice_to_orgs_v
876: WHERE site_use_id = p_header_rec.invoice_to_org_id
877: AND
878: customer_id in (
879: Select p_header_rec.sold_to_org_id from dual
880: union
881: select cust_account_id from
882: HZ_CUST_ACCT_RELATE where
883: related_cust_account_id = p_header_rec.sold_to_org_id