DBA Data[Home] [Help]

APPS.MRP_MRPRPPLO_XMLP_PKG dependencies on MFG_LOOKUPS

Line 236: MFG_LOOKUPS

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

Line 256: MFG_LOOKUPS

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;

Line 273: MFG_LOOKUPS

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;

Line 345: MFG_LOOKUPS

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;

Line 398: MFG_LOOKUPS

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);