APPS.OE_BULK_VALUE_TO_ID dependencies on OE_AR_LOOKUPS_V

Line 465: FROM OE_AR_LOOKUPS_V b, OE_HEADERS_IFACE_ALL d

461: (SELECT b.LOOKUP_CODE,
462: DECODE(b.LOOKUP_CODE,NULL,'Y',NULL),
463: DECODE(b.LOOKUP_CODE,NULL,
464: c.ATTRIBUTE_STATUS||'006',c.ATTRIBUTE_STATUS)
465: FROM OE_AR_LOOKUPS_V b, OE_HEADERS_IFACE_ALL d
466: WHERE d.TAX_EXEMPT_REASON = b.MEANING(+)
467: AND b.LOOKUP_TYPE(+) = 'TAX_REASON'
468: AND d.rowid = c.rowid
469: )

Line 594: FROM OE_AR_LOOKUPS_V b, OE_HEADERS_IFACE_ALL d

590: (SELECT b.LOOKUP_CODE,
591: DECODE(b.LOOKUP_CODE,NULL,'Y',NULL),
592: DECODE(b.LOOKUP_CODE,NULL,
593: c.ATTRIBUTE_STATUS||'012',c.ATTRIBUTE_STATUS)
594: FROM OE_AR_LOOKUPS_V b, OE_HEADERS_IFACE_ALL d
595: WHERE d.FOB_POINT = b.MEANING(+)
596: AND b.LOOKUP_TYPE(+) = 'FOB'
597: AND b.enabled_flag(+) = 'Y'
598: AND SYSDATE BETWEEN NVL(START_DATE_ACTIVE, SYSDATE)

Line 1261: FROM OE_AR_LOOKUPS_V b, OE_LINES_IFACE_ALL d

1257: (SELECT b.LOOKUP_CODE,
1258: DECODE(b.LOOKUP_CODE,NULL,'Y',NULL),
1259: DECODE(b.LOOKUP_CODE,NULL,
1260: c.ATTRIBUTE_STATUS||'006',c.ATTRIBUTE_STATUS)
1261: FROM OE_AR_LOOKUPS_V b, OE_LINES_IFACE_ALL d
1262: WHERE d.TAX_EXEMPT_REASON = b.MEANING(+)
1263: AND b.LOOKUP_TYPE(+) = 'TAX_REASON'
1264: AND b.enabled_flag(+) = 'Y'
1265: AND SYSDATE BETWEEN NVL(START_DATE_ACTIVE, SYSDATE)

Line 1418: FROM OE_AR_LOOKUPS_V b, OE_LINES_IFACE_ALL d

1414: (SELECT b.LOOKUP_CODE,
1415: DECODE(b.LOOKUP_CODE,NULL,'Y',NULL),
1416: DECODE(b.LOOKUP_CODE,NULL,
1417: c.ATTRIBUTE_STATUS||'012',c.ATTRIBUTE_STATUS)
1418: FROM OE_AR_LOOKUPS_V b, OE_LINES_IFACE_ALL d
1419: WHERE d.FOB_POINT = b.MEANING(+)
1420: AND b.LOOKUP_TYPE(+) = 'FOB'
1421: AND b.enabled_flag(+) = 'Y'
1422: AND SYSDATE BETWEEN NVL(START_DATE_ACTIVE, SYSDATE)