APPS.OE_BULK_VALUE_TO_ID dependencies on OE_INVOICE_TO_ORGS_V

Line 794: FROM OE_INVOICE_TO_ORGS_V b, OE_HEADERS_IFACE_ALL d

790: (SELECT /*+ PUSH_PRED(b) */ b.ORGANIZATION_ID,
791: DECODE(b.ORGANIZATION_ID,NULL,'Y',NULL),
792: DECODE(b.ORGANIZATION_ID,NULL,
793: d.ATTRIBUTE_STATUS||'015',d.ATTRIBUTE_STATUS)
794: FROM OE_INVOICE_TO_ORGS_V b, OE_HEADERS_IFACE_ALL d
795: WHERE d.invoice_address1 = ADDRESS_LINE_1(+)
796: AND nvl(d.invoice_address2,'NIL') = NVL(ADDRESS_LINE_2(+),'NIL')
797: AND nvl(d.invoice_address3,'NIL') = nvl(ADDRESS_LINE_3(+),'NIL')
798: --AND nvl(d.invoice_address4,'NIL') = ADDRESS_LINE_4

Line 1599: FROM OE_INVOICE_TO_ORGS_V b, OE_LINES_IFACE_ALL d

1595: (SELECT /*+ PUSH_PRED(b) */ b.ORGANIZATION_ID,
1596: DECODE(b.ORGANIZATION_ID,NULL,'Y',NULL),
1597: DECODE(b.ORGANIZATION_ID,NULL,
1598: d.ATTRIBUTE_STATUS||'015',d.ATTRIBUTE_STATUS)
1599: FROM OE_INVOICE_TO_ORGS_V b, OE_LINES_IFACE_ALL d
1600: WHERE d.invoice_to_address1 = ADDRESS_LINE_1(+)
1601: AND nvl(d.invoice_to_address2,'NIL') = NVL(ADDRESS_LINE_2(+),'NIL')
1602: AND nvl(d.invoice_to_address3,'NIL') = nvl(ADDRESS_LINE_3(+),'NIL')
1603: --AND nvl(d.invoice_to_address4,'NIL') = ADDRESS_LINE_4