APPS.MRP_MRPRPRSC_XMLP_PKG dependencies on MFG_LOOKUPS

Line 24: MFG_LOOKUPS

20: SELECT
21: MEANING
22: INTO CANCEL_TEXT
23: FROM
24: MFG_LOOKUPS
25: WHERE LOOKUP_TYPE = 'MRP_CANCEL'
26: AND LOOKUP_CODE = 1;
27: P_CANCEL_TEXT := CANCEL_TEXT;
28: P_CUTOFF_DATE_YY := TO_CHAR(P_CUTOFF_DATE

Line 321: MFG_LOOKUPS

317: SELECT
318: MEANING
319: INTO SORT
320: FROM
321: MFG_LOOKUPS
322: WHERE LOOKUP_CODE = P_SORT
323: AND LOOKUP_TYPE = 'MRP_RESCHEDULE_SORT';
324: RETURN (SORT);
325: END;

Line 338: MFG_LOOKUPS

334: SELECT
335: MEANING
336: INTO ORDER_TYPE
337: FROM
338: MFG_LOOKUPS
339: WHERE LOOKUP_CODE = P_ORDER_TYPE
340: AND LOOKUP_TYPE = 'MRP_RESCHEDULE_SELECT';
341: RETURN (ORDER_TYPE);
342: END;

Line 410: MFG_LOOKUPS

406: SELECT
407: MEANING
408: INTO CUTOFF_TYPE
409: FROM
410: MFG_LOOKUPS
411: WHERE LOOKUP_CODE = P_CUTOFF_TYPE
412: AND LOOKUP_TYPE = 'MRP_PL_ORDER_CUTOFF_TYPE';
413: RETURN (CUTOFF_TYPE);
414: END;

Line 557: MFG_LOOKUPS

553: SELECT
554: MEANING
555: INTO REPORT_MULTIORG_TEXT
556: FROM
557: MFG_LOOKUPS
558: WHERE LOOKUP_CODE = P_REPORT_MULTIORG
559: AND LOOKUP_TYPE = 'MRP_REPORT_MULTIORG';
560: END IF;
561: RETURN (REPORT_MULTIORG_TEXT);