232: SELECT
233: MEANING
234: INTO ITEM_SELECT
235: FROM
236: MFG_LOOKUPS
237: WHERE LOOKUP_CODE = P_ITEM_SELECT
238: AND LOOKUP_TYPE = 'MTL_PLANNING_MAKE_BUY';
239: RETURN (ITEM_SELECT);
240: ELSE
252: SELECT
253: MEANING
254: INTO INCLUDE_COST
255: FROM
256: MFG_LOOKUPS
257: WHERE LOOKUP_CODE = P_INCLUDE_COST
258: AND LOOKUP_TYPE = 'SYS_YES_NO';
259: RETURN (INCLUDE_COST);
260: END;
269: SELECT
270: MEANING
271: INTO SORT
272: FROM
273: MFG_LOOKUPS
274: WHERE LOOKUP_CODE = P_SORT
275: AND LOOKUP_TYPE = 'MRP_PLANNED_ORDER_SORT';
276: RETURN (SORT);
277: END;
341: SELECT
342: MEANING
343: INTO CUTOFF_TYPE
344: FROM
345: MFG_LOOKUPS
346: WHERE LOOKUP_CODE = P_CUTOFF_TYPE
347: AND LOOKUP_TYPE = 'MRP_PL_ORDER_CUTOFF_TYPE';
348: RETURN (CUTOFF_TYPE);
349: END;
394: SELECT
395: MEANING
396: INTO ORG_TYPE
397: FROM
398: MFG_LOOKUPS
399: WHERE LOOKUP_CODE = P_ORG_TYPE
400: AND LOOKUP_TYPE = 'MRP_REPORT_MULTIORG';
401: END IF;
402: RETURN (ORG_TYPE);