APPS.OE_BULK_VALUE_TO_ID dependencies on OE_SHIP_TO_ORGS_V

Line 764: FROM OE_SHIP_TO_ORGS_V b, OE_HEADERS_IFACE_ALL d

760: (SELECT /*+ PUSH_PRED(b) */ b.ORGANIZATION_ID,
761: DECODE(b.ORGANIZATION_ID,NULL,'Y',NULL),
762: DECODE(b.ORGANIZATION_ID,NULL,
763: d.ATTRIBUTE_STATUS||'014',d.ATTRIBUTE_STATUS)
764: FROM OE_SHIP_TO_ORGS_V b, OE_HEADERS_IFACE_ALL d
765: WHERE d.ship_to_address1 = ADDRESS_LINE_1(+)
766: AND nvl(d.ship_to_address2,'NIL') = NVL(ADDRESS_LINE_2(+),'NIL')
767: AND nvl(d.ship_to_address3,'NIL') = nvl(ADDRESS_LINE_3(+),'NIL')
768: --AND nvl(d.ship_to_address4,'NIL') = ADDRESS_LINE_4

Line 1566: FROM OE_SHIP_TO_ORGS_V b, OE_LINES_IFACE_ALL d

1562: (SELECT /*+ PUSH_PRED(b) */ b.ORGANIZATION_ID,
1563: DECODE(b.ORGANIZATION_ID,NULL,'Y',NULL),
1564: DECODE(b.ORGANIZATION_ID,NULL,
1565: d.ATTRIBUTE_STATUS||'014',d.ATTRIBUTE_STATUS)
1566: FROM OE_SHIP_TO_ORGS_V b, OE_LINES_IFACE_ALL d
1567: WHERE d.ship_to_address1 = ADDRESS_LINE_1(+)
1568: AND nvl(d.ship_to_address2,'NIL') = NVL(ADDRESS_LINE_2(+),'NIL')
1569: AND nvl(d.ship_to_address3,'NIL') = nvl(ADDRESS_LINE_3(+),'NIL')
1570: --AND nvl(d.ship_to_address4,'NIL') = ADDRESS_LINE_4