APPS.OE_CNCL_VALIDATE dependencies on OE_LOOKUPS

Line 261: FROM OE_LOOKUPS

257: END IF;
258:
259: SELECT 'VALID'
260: INTO l_dummy
261: FROM OE_LOOKUPS
262: WHERE lookup_code = p_ib_owner AND
263: lookup_type = l_lookup_type1;
264:
265:

Line 322: FROM OE_LOOKUPS

318: END IF;
319:
320: SELECT 'VALID'
321: INTO l_dummy
322: FROM OE_LOOKUPS
323: WHERE lookup_code = p_ib_installed_at_location AND
324: lookup_type = l_lookup_type1;
325:
326:

Line 383: FROM OE_LOOKUPS

379: END IF;
380:
381: SELECT 'VALID'
382: INTO l_dummy
383: FROM OE_LOOKUPS
384: WHERE lookup_code = p_ib_current_location AND
385: lookup_type = l_lookup_type1;
386:
387:

Line 912: FROM OE_LOOKUPS

908: END IF;
909:
910: SELECT 'VALID'
911: INTO l_dummy
912: FROM OE_LOOKUPS
913: WHERE LOOKUP_CODE = p_source_type_code
914: AND LOOKUP_TYPE = l_lookup_type
915: AND ROWNUM = 1;
916: --

Line 1199: FROM OE_LOOKUPS

1195: END IF;
1196:
1197: SELECT 'VALID'
1198: INTO l_dummy
1199: FROM OE_LOOKUPS
1200: WHERE LOOKUP_CODE = p_shipment_priority_code
1201: AND LOOKUP_TYPE = l_lookup_type
1202: AND ROWNUM = 1;
1203:

Line 2556: FROM OE_LOOKUPS

2552: END IF;
2553:
2554: SELECT 'VALID'
2555: INTO l_dummy
2556: FROM OE_LOOKUPS
2557: WHERE LOOKUP_CODE = p_tax_point_code
2558: AND LOOKUP_TYPE = l_lookup_type
2559: AND ROWNUM = 1;
2560: --

Line 3053: FROM OE_LOOKUPS

3049: END IF;
3050:
3051: SELECT 'VALID'
3052: INTO l_dummy
3053: FROM OE_LOOKUPS
3054: WHERE LOOKUP_CODE = p_freight_terms_code
3055: AND LOOKUP_TYPE = l_lookup_type
3056: AND ROWNUM = 1;
3057: --

Line 10159: FROM OE_LOOKUPS

10155: END IF;
10156:
10157: SELECT 'VALID'
10158: INTO l_dummy
10159: FROM OE_LOOKUPS
10160: WHERE LOOKUP_CODE = p_order_date_type_code
10161: AND LOOKUP_TYPE = l_lookup_type
10162: AND ROWNUM = 1;
10163: --

Line 18251: FROM OE_LOOKUPS

18247: END IF;
18248:
18249: SELECT 'VALID'
18250: INTO l_dummy
18251: FROM OE_LOOKUPS
18252: WHERE LOOKUP_CODE = p_payment_type_code
18253: AND LOOKUP_TYPE = l_lookup_type
18254: AND ROWNUM = 1;
18255: --

Line 18435: FROM OE_LOOKUPS

18431: END IF;
18432:
18433: SELECT 'VALID'
18434: INTO l_dummy
18435: FROM OE_LOOKUPS
18436: WHERE LOOKUP_CODE = p_credit_card_code
18437: AND LOOKUP_TYPE = l_lookup_type
18438: AND ROWNUM = 1;
18439: --

Line 19896: FROM OE_LOOKUPS

19892: END IF;
19893:
19894: SELECT 'VALID'
19895: INTO l_dummy
19896: FROM OE_LOOKUPS
19897: WHERE LOOKUP_CODE = p_flow_status_code
19898: AND LOOKUP_TYPE = l_lookup_type
19899: AND ROWNUM = 1;
19900: --

Line 19963: FROM OE_LOOKUPS

19959: END IF;
19960:
19961: SELECT 'VALID'
19962: INTO l_dummy
19963: FROM OE_LOOKUPS
19964: WHERE LOOKUP_CODE = p_flow_status_code
19965: AND LOOKUP_TYPE = l_lookup_type
19966: AND ROWNUM = 1;
19967: -- AND ENABLED_FLAG = 'Y'

Line 20367: FROM OE_LOOKUPS

20363: END IF;
20364:
20365: SELECT 'VALID'
20366: INTO l_dummy
20367: FROM OE_LOOKUPS
20368: WHERE LOOKUP_CODE = p_credit_or_charge_flag
20369: AND LOOKUP_TYPE = l_lookup_type
20370: AND ROWNUM = 1;
20371: --

Line 20504: FROM OE_LOOKUPS

20500: END IF;
20501:
20502: SELECT 'VALID'
20503: INTO l_dummy
20504: FROM OE_LOOKUPS
20505: WHERE LOOKUP_CODE = p_sales_channel_code
20506: AND LOOKUP_TYPE = l_lookup_type
20507: AND ROWNUM = 1;
20508: --