APPS.OE_BULK_VALUE_TO_ID dependencies on HZ_PARTIES

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 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 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 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 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 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 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)