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 18252: FROM OE_LOOKUPS

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

Line 18436: FROM OE_LOOKUPS

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

Line 19897: FROM OE_LOOKUPS

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

Line 19964: FROM OE_LOOKUPS

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

Line 20368: FROM OE_LOOKUPS

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

Line 20505: FROM OE_LOOKUPS

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