APPS.MRP_MRPRPSST_XMLP_PKG dependencies on MFG_LOOKUPS

Line 55: MFG_LOOKUPS

51: SELECT
52: MEANING
53: INTO SCHED_VERSION
54: FROM
55: MFG_LOOKUPS
56: WHERE LOOKUP_TYPE = 'MRP_SCHEDULE_LEVEL'
57: AND LOOKUP_CODE = P_SCHED_VERSION;
58: RETURN (SCHED_VERSION);
59: END;

Line 72: MFG_LOOKUPS

68: SELECT
69: MEANING
70: INTO SORT
71: FROM
72: MFG_LOOKUPS
73: WHERE LOOKUP_TYPE = 'MRP_DATA_SELECT'
74: AND LOOKUP_CODE = P_SORT;
75: RETURN (SORT);
76: END;

Line 173: MFG_LOOKUPS

169: MRP_FORM_QUERY_S.NEXTVAL,
170: P_START_DATE
171: INTO PERIODS,QUERY_ID,START_DATE
172: FROM
173: MFG_LOOKUPS
174: WHERE LOOKUP_TYPE = 'MRP_DISPLAY_PERIODS'
175: AND LOOKUP_CODE = P_PERIODS;
176: P_PERIODS_ACTUAL := PERIODS;
177: P_QUERY_ID := QUERY_ID;

Line 218: MFG_LOOKUPS

214: SELECT
215: MEANING
216: INTO SCHEDULE_TYPE
217: FROM
218: MFG_LOOKUPS
219: WHERE LOOKUP_TYPE = 'MRP_SCHEDULE_TYPE'
220: AND LOOKUP_CODE = P_SCHED_TYPE;
221: P_SCHED_TYPE_DESC := SCHEDULE_TYPE;
222: SELECT

Line 226: MFG_LOOKUPS

222: SELECT
223: MEANING
224: INTO SCHEDULE_VERSION
225: FROM
226: MFG_LOOKUPS
227: WHERE LOOKUP_TYPE = 'MRP_SCHEDULE_LEVEL'
228: AND LOOKUP_CODE = P_SCHED_VERSION;
229: P_SCHED_VERSION_DESC := SCHEDULE_VERSION;
230: END;

Line 286: MFG_LOOKUPS

282: SELECT
283: MEANING
284: INTO REPORT_MULTIORG_TEXT
285: FROM
286: MFG_LOOKUPS
287: WHERE LOOKUP_CODE = P_REPORT_MULTIORG
288: AND LOOKUP_TYPE = 'MRP_REPORT_MULTIORG';
289: END IF;
290: RETURN (REPORT_MULTIORG_TEXT);