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_BULK_VALUE_TO_ID dependencies on HZ_CUST_ACCOUNTS

Line 622: FROM HZ_CUST_ACCOUNTS b, OE_HEADERS_IFACE_ALL d

618: (SELECT b.CUST_ACCOUNT_ID,
619: DECODE(b.CUST_ACCOUNT_ID,NULL,'Y',NULL),
620: DECODE(b.CUST_ACCOUNT_ID,NULL,
621: c.ATTRIBUTE_STATUS||'013',c.ATTRIBUTE_STATUS)
622: FROM HZ_CUST_ACCOUNTS b, OE_HEADERS_IFACE_ALL d
623: WHERE d.CUSTOMER_NUMBER IS NOT NULL
624: AND d.CUSTOMER_NUMBER = b.ACCOUNT_NUMBER(+)
625: AND b.STATUS(+) = 'A'
626: AND d.rowid = c.rowid

Line 632: FROM HZ_CUST_ACCOUNTS b, HZ_PARTIES e, OE_HEADERS_IFACE_ALL d

628: SELECT b.CUST_ACCOUNT_ID,
629: DECODE(b.CUST_ACCOUNT_ID,NULL,'Y',NULL),
630: DECODE(b.CUST_ACCOUNT_ID,NULL,
631: c.ATTRIBUTE_STATUS||'013',c.ATTRIBUTE_STATUS)
632: FROM HZ_CUST_ACCOUNTS b, HZ_PARTIES e, OE_HEADERS_IFACE_ALL d
633: WHERE d.CUSTOMER_NUMBER IS NULL
634: AND d.SOLD_TO_ORG = e.PARTY_NAME(+)
635: AND b.STATUS(+) = 'A'
636: AND b.PARTY_ID(+) = e.PARTY_ID

Line 682: FROM HZ_CUST_ACCOUNTS b, OE_HEADERS_IFACE_ALL d

678: (SELECT b.CUST_ACCOUNT_ID,
679: DECODE(b.CUST_ACCOUNT_ID,NULL,'Y',NULL),
680: DECODE(b.CUST_ACCOUNT_ID,NULL,
681: d.ATTRIBUTE_STATUS||'014',d.ATTRIBUTE_STATUS)
682: FROM HZ_CUST_ACCOUNTS b, OE_HEADERS_IFACE_ALL d
683: WHERE d.SHIP_TO_CUSTOMER_NUMBER IS NOT NULL
684: AND d.SHIP_TO_CUSTOMER_NUMBER = b.ACCOUNT_NUMBER(+)
685: AND b.STATUS(+) = 'A'
686: AND d.rowid = c.rowid

Line 692: FROM HZ_CUST_ACCOUNTS b, HZ_PARTIES e, OE_HEADERS_IFACE_ALL d

688: SELECT b.CUST_ACCOUNT_ID,
689: DECODE(b.CUST_ACCOUNT_ID,NULL,'Y',NULL),
690: DECODE(b.CUST_ACCOUNT_ID,NULL,
691: d.ATTRIBUTE_STATUS||'014',d.ATTRIBUTE_STATUS)
692: FROM HZ_CUST_ACCOUNTS b, HZ_PARTIES e, OE_HEADERS_IFACE_ALL d
693: WHERE d.SHIP_TO_CUSTOMER_NUMBER IS NULL
694: AND d.SHIP_TO_CUSTOMER = e.PARTY_NAME(+)
695: AND b.STATUS(+) = 'A'
696: AND b.PARTY_ID(+) = e.PARTY_ID

Line 723: FROM HZ_CUST_ACCOUNTS b, OE_HEADERS_IFACE_ALL d

719: (SELECT b.CUST_ACCOUNT_ID,
720: DECODE(b.CUST_ACCOUNT_ID,NULL,'Y',NULL),
721: DECODE(b.CUST_ACCOUNT_ID,NULL,
722: d.ATTRIBUTE_STATUS||'015',d.ATTRIBUTE_STATUS)
723: FROM HZ_CUST_ACCOUNTS b, OE_HEADERS_IFACE_ALL d
724: WHERE d.INVOICE_CUSTOMER_NUMBER IS NOT NULL
725: AND d.INVOICE_CUSTOMER_NUMBER = b.ACCOUNT_NUMBER(+)
726: AND b.STATUS(+) = 'A'
727: AND d.rowid = c.rowid

Line 733: FROM HZ_CUST_ACCOUNTS b, HZ_PARTIES e, OE_HEADERS_IFACE_ALL d

729: SELECT b.CUST_ACCOUNT_ID,
730: DECODE(b.CUST_ACCOUNT_ID,NULL,'Y',NULL),
731: DECODE(b.CUST_ACCOUNT_ID,NULL,
732: d.ATTRIBUTE_STATUS||'015',d.ATTRIBUTE_STATUS)
733: FROM HZ_CUST_ACCOUNTS b, HZ_PARTIES e, OE_HEADERS_IFACE_ALL d
734: WHERE d.INVOICE_CUSTOMER_NUMBER IS NULL
735: AND d.INVOICE_CUSTOMER = e.PARTY_NAME(+)
736: AND b.STATUS(+) = 'A'
737: AND b.PARTY_ID(+) = e.PARTY_ID

Line 993: FROM HZ_CUST_ACCOUNTS b, OE_HEADERS_IFACE_ALL d

989: (SELECT b.CUST_ACCOUNT_ID,
990: DECODE(b.CUST_ACCOUNT_ID,NULL,'Y',NULL),
991: DECODE(b.CUST_ACCOUNT_ID,NULL,
992: d.ATTRIBUTE_STATUS||'025',d.ATTRIBUTE_STATUS)
993: FROM HZ_CUST_ACCOUNTS b, OE_HEADERS_IFACE_ALL d
994: WHERE d.END_CUSTOMER_NUMBER IS NOT NULL AND d.END_CUSTOMER_NUMBER = b.ACCOUNT_NUMBER(+)
995: AND b.STATUS(+) = 'A' AND d.rowid = c.rowid
996: UNION ALL
997: SELECT b.CUST_ACCOUNT_ID,

Line 1000: d.ATTRIBUTE_STATUS||'025',d.ATTRIBUTE_STATUS) FROM HZ_CUST_ACCOUNTS b, HZ_PARTIES e, OE_HEADERS_IFACE_ALL d

996: UNION ALL
997: SELECT b.CUST_ACCOUNT_ID,
998: DECODE(b.CUST_ACCOUNT_ID,NULL,'Y',NULL),
999: DECODE(b.CUST_ACCOUNT_ID,NULL,
1000: d.ATTRIBUTE_STATUS||'025',d.ATTRIBUTE_STATUS) FROM HZ_CUST_ACCOUNTS b, HZ_PARTIES e, OE_HEADERS_IFACE_ALL d
1001: WHERE d.END_CUSTOMER_NUMBER IS NULL AND d.END_CUSTOMER_NAME = e.PARTY_NAME(+)
1002: AND b.STATUS(+) = 'A' AND b.PARTY_ID(+) = e.PARTY_ID
1003: AND d.rowid = c.rowid)
1004: WHERE c.batch_id = p_batch_id and c.END_CUSTOMER_ID IS NULL AND

Line 1472: FROM HZ_CUST_ACCOUNTS b, OE_LINES_IFACE_ALL d

1468: (SELECT b.CUST_ACCOUNT_ID,
1469: DECODE(b.CUST_ACCOUNT_ID,NULL,'Y',NULL),
1470: DECODE(b.CUST_ACCOUNT_ID,NULL,
1471: d.ATTRIBUTE_STATUS||'014',d.ATTRIBUTE_STATUS)
1472: FROM HZ_CUST_ACCOUNTS b, OE_LINES_IFACE_ALL d
1473: WHERE d.SHIP_TO_CUSTOMER_NUMBER IS NOT NULL
1474: AND d.SHIP_TO_CUSTOMER_NUMBER = b.ACCOUNT_NUMBER(+)
1475: AND b.STATUS(+) = 'A'
1476: AND d.rowid = c.rowid

Line 1482: FROM HZ_CUST_ACCOUNTS b, HZ_PARTIES e, OE_LINES_IFACE_ALL d

1478: SELECT b.CUST_ACCOUNT_ID,
1479: DECODE(b.CUST_ACCOUNT_ID,NULL,'Y',NULL),
1480: DECODE(b.CUST_ACCOUNT_ID,NULL,
1481: d.ATTRIBUTE_STATUS||'014',d.ATTRIBUTE_STATUS)
1482: FROM HZ_CUST_ACCOUNTS b, HZ_PARTIES e, OE_LINES_IFACE_ALL d
1483: WHERE d.SHIP_TO_CUSTOMER_NUMBER IS NULL
1484: AND d.SHIP_TO_CUSTOMER_NAME = e.PARTY_NAME(+)
1485: AND b.STATUS(+) = 'A'
1486: AND b.PARTY_ID(+) = e.PARTY_ID

Line 1519: FROM HZ_CUST_ACCOUNTS b, OE_LINES_IFACE_ALL d

1515: (SELECT b.CUST_ACCOUNT_ID,
1516: DECODE(b.CUST_ACCOUNT_ID,NULL,'Y',NULL),
1517: DECODE(b.CUST_ACCOUNT_ID,NULL,
1518: d.ATTRIBUTE_STATUS||'015',d.ATTRIBUTE_STATUS)
1519: FROM HZ_CUST_ACCOUNTS b, OE_LINES_IFACE_ALL d
1520: WHERE d.INVOICE_TO_CUSTOMER_NUMBER IS NOT NULL
1521: AND d.INVOICE_TO_CUSTOMER_NUMBER = b.ACCOUNT_NUMBER(+)
1522: AND b.STATUS(+) = 'A'
1523: AND d.rowid = c.rowid

Line 1529: FROM HZ_CUST_ACCOUNTS b, HZ_PARTIES e, OE_LINES_IFACE_ALL d

1525: SELECT b.CUST_ACCOUNT_ID,
1526: DECODE(b.CUST_ACCOUNT_ID,NULL,'Y',NULL),
1527: DECODE(b.CUST_ACCOUNT_ID,NULL,
1528: d.ATTRIBUTE_STATUS||'015',d.ATTRIBUTE_STATUS)
1529: FROM HZ_CUST_ACCOUNTS b, HZ_PARTIES e, OE_LINES_IFACE_ALL d
1530: WHERE d.INVOICE_TO_CUSTOMER_NUMBER IS NULL
1531: AND d.INVOICE_TO_CUSTOMER_NAME = e.PARTY_NAME(+)
1532: AND b.STATUS(+) = 'A'
1533: AND b.PARTY_ID(+) = e.PARTY_ID

Line 1767: FROM HZ_CUST_ACCOUNTS b, OE_LINES_IFACE_ALL d

1763: (SELECT b.CUST_ACCOUNT_ID,
1764: DECODE(b.CUST_ACCOUNT_ID,NULL,'Y',NULL),
1765: DECODE(b.CUST_ACCOUNT_ID,NULL,
1766: d.ATTRIBUTE_STATUS||'025',d.ATTRIBUTE_STATUS)
1767: FROM HZ_CUST_ACCOUNTS b, OE_LINES_IFACE_ALL d
1768: WHERE d.END_CUSTOMER_NUMBER IS NOT NULL
1769: AND d.END_CUSTOMER_NUMBER = b.ACCOUNT_NUMBER(+)
1770: AND b.STATUS(+) = 'A' AND d.rowid = c.rowid
1771: UNION ALL

Line 1776: FROM HZ_CUST_ACCOUNTS b, HZ_PARTIES e, OE_LINES_IFACE_ALL d

1772: SELECT b.CUST_ACCOUNT_ID,
1773: DECODE(b.CUST_ACCOUNT_ID,NULL,'Y',NULL),
1774: DECODE(b.CUST_ACCOUNT_ID,NULL,
1775: d.ATTRIBUTE_STATUS||'025',d.ATTRIBUTE_STATUS)
1776: FROM HZ_CUST_ACCOUNTS b, HZ_PARTIES e, OE_LINES_IFACE_ALL d
1777: WHERE d.END_CUSTOMER_NUMBER IS NULL
1778: AND d.END_CUSTOMER_NAME = e.PARTY_NAME(+)
1779: AND b.STATUS(+) = 'A' AND b.PARTY_ID(+) = e.PARTY_ID
1780: AND d.rowid = c.rowid)