APPS.OE_BULK_VALIDATE dependencies on OE_LOOKUPS

Line 667: FROM OE_LOOKUPS

663: FROM OE_HEADERS_IFACE_ALL b
664: WHERE batch_id = p_batch_id and
665: b.freight_terms_code IS NOT NULL and
666: NOT EXISTS (SELECT LOOKUP_CODE
667: FROM OE_LOOKUPS
668: WHERE LOOKUP_CODE = b.freight_terms_code
669: AND LOOKUP_TYPE = 'FREIGHT_TERMS'
670: AND ENABLED_FLAG = 'Y'
671: AND SYSDATE BETWEEN NVL(START_DATE_ACTIVE, SYSDATE)

Line 708: FROM OE_LOOKUPS

704: FROM OE_HEADERS_IFACE_ALL
705: WHERE batch_id = p_batch_id)
706: AND b.freight_terms_code IS NOT NULL and
707: NOT EXISTS (SELECT LOOKUP_CODE
708: FROM OE_LOOKUPS
709: WHERE LOOKUP_CODE = b.freight_terms_code
710: AND LOOKUP_TYPE = 'FREIGHT_TERMS'
711: AND ENABLED_FLAG = 'Y'
712: AND SYSDATE BETWEEN NVL(START_DATE_ACTIVE, SYSDATE)

Line 824: FROM OE_LOOKUPS a

820: FROM OE_HEADERS_IFACE_ALL b
821: WHERE batch_id = p_batch_id
822: AND b.order_date_type_code IS NOT NULL
823: AND NOT EXISTS (SELECT LOOKUP_CODE
824: FROM OE_LOOKUPS a
825: WHERE LOOKUP_TYPE = 'REQUEST_DATE_TYPE'
826: AND LOOKUP_CODE = b.order_date_type_code
827: AND ENABLED_FLAG = 'Y'
828: AND SYSDATE BETWEEN NVL(START_DATE_ACTIVE, SYSDATE)

Line 1017: FROM OE_LOOKUPS

1013: FROM OE_HEADERS_IFACE_ALL b
1014: WHERE batch_id = p_batch_id and
1015: b.shipment_priority_code IS NOT NULL and
1016: NOT EXISTS (select LOOKUP_CODE
1017: FROM OE_LOOKUPS
1018: WHERE LOOKUP_CODE = b.shipment_priority_code
1019: AND LOOKUP_TYPE = 'SHIPMENT_PRIORITY'
1020: AND ENABLED_FLAG = 'Y'
1021: AND SYSDATE BETWEEN NVL(START_DATE_ACTIVE, SYSDATE)

Line 1058: FROM OE_LOOKUPS

1054: FROM OE_HEADERS_IFACE_ALL
1055: WHERE batch_id = p_batch_id)
1056: AND b.shipment_priority_code IS NOT NULL and
1057: NOT EXISTS (select LOOKUP_CODE
1058: FROM OE_LOOKUPS
1059: WHERE LOOKUP_CODE = b.shipment_priority_code
1060: AND LOOKUP_TYPE = 'SHIPMENT_PRIORITY'
1061: AND ENABLED_FLAG = 'Y'
1062: AND SYSDATE BETWEEN NVL(START_DATE_ACTIVE, SYSDATE)

Line 1373: FROM OE_LOOKUPS

1369: FROM OE_HEADERS_IFACE_ALL b
1370: WHERE batch_id = p_batch_id and
1371: b.payment_type_code IS NOT NULL and
1372: NOT EXISTS (SELECT LOOKUP_CODE
1373: FROM OE_LOOKUPS
1374: WHERE LOOKUP_CODE = b.payment_type_code
1375: AND LOOKUP_TYPE = 'PAYMENT TYPE'
1376: AND ENABLED_FLAG = 'Y'
1377: AND SYSDATE BETWEEN NVL(START_DATE_ACTIVE, SYSDATE)

Line 1517: FROM OE_LOOKUPS

1513: FROM OE_HEADERS_IFACE_ALL b
1514: WHERE batch_id = p_batch_id and
1515: b.sales_channel_code IS NOT NULL and
1516: NOT EXISTS (SELECT LOOKUP_CODE
1517: FROM OE_LOOKUPS
1518: WHERE LOOKUP_CODE = b.sales_channel_code
1519: AND LOOKUP_TYPE = 'SALES_CHANNEL'
1520: AND ENABLED_FLAG = 'Y'
1521: AND SYSDATE BETWEEN NVL(START_DATE_ACTIVE, SYSDATE)

Line 2046: FROM OE_LOOKUPS l

2042: AND a.order_source_id = h.order_source_id
2043: AND a.orig_sys_document_ref = h.orig_sys_document_ref
2044: AND a.CREDIT_OR_CHARGE_FLAG IS NOT NULL
2045: AND NOT EXISTS (SELECT 'Y'
2046: FROM OE_LOOKUPS l
2047: WHERE LOOKUP_TYPE = 'CREDIT_OR_CHARGE_FLAG'
2048: AND LOOKUP_CODE = a.credit_or_charge_flag);
2049:
2050: IF g_error_count = 0 THEN