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 735: Select p_header_rec.sold_to_org_id from dual

731: From oe_ship_to_orgs_v
732: WHERE site_use_id = p_header_rec.ship_to_org_id
733: AND
734: customer_id in (
735: Select p_header_rec.sold_to_org_id from dual
736: union
737: select cust_account_id from
738: HZ_CUST_ACCT_RELATE
739: Where related_cust_account_id = p_header_rec.sold_to_org_id

Line 834: SELECT p_header_rec.sold_to_org_id FROM DUAL

830: WHERE SITE.SITE_USE_ID = p_header_rec.deliver_to_org_id
831: AND SITE.SITE_USE_CODE ='DELIVER_TO'
832: AND SITE.CUST_ACCT_SITE_ID = ACCT_SITE.CUST_ACCT_SITE_ID
833: AND ACCT_SITE.CUST_ACCOUNT_ID in (
834: SELECT p_header_rec.sold_to_org_id FROM DUAL
835: UNION
836: SELECT CUST_ACCOUNT_ID FROM
837: HZ_CUST_ACCT_RELATE_ALL R WHERE
838: R.ORG_ID = ACCT_SITE.ORG_ID

Line 910: Select p_header_rec.sold_to_org_id from dual

906: From oe_invoice_to_orgs_v
907: WHERE site_use_id = p_header_rec.invoice_to_org_id
908: AND
909: customer_id in (
910: Select p_header_rec.sold_to_org_id from dual
911: union
912: select cust_account_id from
913: HZ_CUST_ACCT_RELATE where
914: related_cust_account_id = p_header_rec.sold_to_org_id