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

Line 587: FROM sys.dual

583: INTO l_exists
584: FROM ra_customer_trx ratrx
585: WHERE ratrx.bill_to_customer_id
586: IN (SELECT p_sold_to_org_id
587: FROM sys.dual
588: UNION
589: SELECT cust_account_id customer_id
590: FROM hz_cust_acct_relate_all h
591: WHERE related_cust_account_id = p_sold_to_org_id

Line 662: FROM DUAL

658:
659: -- commented for bug#9852199
660: -- SELECT /* MOAC_SQL_NO_CHANGE */ 'Y'
661: /* INTO l_duplicate_exists
662: FROM DUAL
663: WHERE EXISTS (SELECT 'Y'
664: FROM OE_ORDER_HEADERS
665: WHERE HEADER_ID <> p_header_id
666: AND SOLD_TO_ORG_ID = p_sold_to_org_id

Line 680: FROM DUAL

676: -- Added for Bug 9852199
677: BEGIN
678: SELECT 'Y'
679: INTO l_duplicate_exists
680: FROM DUAL
681: WHERE EXISTS (SELECT 'Y'
682: FROM OE_ORDER_HEADERS
683: WHERE HEADER_ID <> p_header_id
684: AND SOLD_TO_ORG_ID = p_sold_to_org_id

Line 694: FROM DUAL

690:
691: IF l_duplicate_exists <> 'Y' THEN
692: SELECT 'Y'
693: INTO l_duplicate_exists
694: FROM DUAL
695: WHERE EXISTS (SELECT 'Y'
696: FROM OE_ORDER_LINES
697: WHERE HEADER_ID <> p_header_id
698: AND SOLD_TO_ORG_ID = p_sold_to_org_id

Line 1579: FROM dual

1575:
1576: BEGIN
1577: SELECT 'VALID'
1578: INTO l_dummy
1579: FROM dual
1580: WHERE exists(
1581: select 'x' from
1582: hz_cust_acct_relate where
1583: related_cust_account_id = p_header_rec.sold_to_org_id

Line 1688: SELECT p_header_rec.sold_to_org_id FROM DUAL

1684: AND SITE.CUST_ACCT_SITE_ID = ACCT_SITE.CUST_ACCT_SITE_ID
1685: AND SITE.STATUS = 'A'
1686: AND ACCT_SITE.STATUS ='A' AND --bug 2752321
1687: ACCT_SITE.CUST_ACCOUNT_ID in (
1688: SELECT p_header_rec.sold_to_org_id FROM DUAL
1689: UNION
1690: SELECT CUST_ACCOUNT_ID FROM
1691: HZ_CUST_ACCT_RELATE_ALL h WHERE
1692: RELATED_CUST_ACCOUNT_ID = p_header_rec.sold_to_org_id

Line 1784: SELECT p_header_rec.sold_to_org_id FROM DUAL

1780: AND SITE.CUST_ACCT_SITE_ID = ACCT_SITE.CUST_ACCT_SITE_ID
1781: AND SITE.STATUS = 'A'
1782: AND ACCT_SITE.STATUS = 'A' AND --bug 2752321
1783: ACCT_SITE.CUST_ACCOUNT_ID in (
1784: SELECT p_header_rec.sold_to_org_id FROM DUAL
1785: UNION
1786: SELECT CUST_ACCOUNT_ID FROM
1787: HZ_CUST_ACCT_RELATE_ALL h WHERE
1788: RELATED_CUST_ACCOUNT_ID = p_header_rec.sold_to_org_id

Line 1882: SELECT p_header_rec.sold_to_org_id FROM DUAL

1878: AND SITE.STATUS = 'A'
1879: AND ACCT_SITE.ORG_ID=SITE.ORG_ID
1880: AND ACCT_SITE.STATUS = 'A' AND
1881: ACCT_SITE.CUST_ACCOUNT_ID in (
1882: SELECT p_header_rec.sold_to_org_id FROM DUAL
1883: UNION
1884: SELECT CUST_ACCOUNT_ID FROM
1885: HZ_CUST_ACCT_RELATE_ALL h WHERE
1886: RELATED_CUST_ACCOUNT_ID = p_header_rec.sold_to_org_id