APPS.MRP_MRPRPROP_XMLP_PKG dependencies on MFG_LOOKUPS

Line 234: MFG_LOOKUPS

230: SELECT
231: MEANING
232: INTO SORT
233: FROM
234: MFG_LOOKUPS
235: WHERE LOOKUP_TYPE = 'MRP_DATA_SELECT'
236: AND LOOKUP_CODE = P_FIRST_SORT;
237: RETURN (SORT);
238: END;

Line 251: MFG_LOOKUPS

247: SELECT
248: MEANING
249: INTO SORT
250: FROM
251: MFG_LOOKUPS
252: WHERE LOOKUP_TYPE = 'MRP_DATA_SELECT'
253: AND LOOKUP_CODE = P_SECOND_SORT;
254: RETURN (SORT);
255: END;

Line 268: MFG_LOOKUPS

264: SELECT
265: MEANING
266: INTO SORT
267: FROM
268: MFG_LOOKUPS
269: WHERE LOOKUP_TYPE = 'MRP_DATA_SELECT'
270: AND LOOKUP_CODE = P_THIRD_SORT;
271: RETURN (SORT);
272: END;

Line 301: MFG_LOOKUPS

297: SELECT
298: MEANING
299: INTO TEXT
300: FROM
301: MFG_LOOKUPS
302: WHERE LOOKUP_TYPE = 'SYS_YES_NO'
303: AND LOOKUP_CODE = P_DISPLAY_DESCRIPTION;
304: RETURN (TEXT);
305: END;

Line 318: MFG_LOOKUPS

314: SELECT
315: MEANING
316: INTO TEXT
317: FROM
318: MFG_LOOKUPS
319: WHERE LOOKUP_TYPE = 'SYS_YES_NO'
320: AND LOOKUP_CODE = P_RESTOCK;
321: RETURN (TEXT);
322: END;

Line 577: MFG_LOOKUPS

573: SELECT
574: MEANING
575: INTO ITEM_SEL
576: FROM
577: MFG_LOOKUPS
578: WHERE LOOKUP_TYPE = 'MTL_REORDER_RPT'
579: AND LOOKUP_CODE = P_ITEM_SELECTION;
580: RETURN (ITEM_SEL);
581: END;

Line 612: MFG_LOOKUPS

608: SELECT
609: MEANING
610: INTO TEXT
611: FROM
612: MFG_LOOKUPS
613: WHERE LOOKUP_TYPE = 'SYS_YES_NO'
614: AND LOOKUP_CODE = P_INCLUDE_PO;
615: RETURN (TEXT);
616: END;

Line 629: MFG_LOOKUPS

625: SELECT
626: MEANING
627: INTO TEXT
628: FROM
629: MFG_LOOKUPS
630: WHERE LOOKUP_TYPE = 'SYS_YES_NO'
631: AND LOOKUP_CODE = P_INCLUDE_WIP;
632: RETURN (TEXT);
633: END;

Line 646: MFG_LOOKUPS

642: SELECT
643: MEANING
644: INTO TEXT
645: FROM
646: MFG_LOOKUPS
647: WHERE LOOKUP_TYPE = 'SYS_YES_NO'
648: AND LOOKUP_CODE = P_INCLUDE_IF;
649: RETURN (TEXT);
650: END;

Line 663: MFG_LOOKUPS

659: SELECT
660: MEANING
661: INTO TEXT
662: FROM
663: MFG_LOOKUPS
664: WHERE LOOKUP_TYPE = 'SYS_YES_NO'
665: AND LOOKUP_CODE = P_INCLUDE_NONNET;
666: RETURN (TEXT);
667: END;

Line 680: MFG_LOOKUPS

676: SELECT
677: MEANING
678: INTO TEXT
679: FROM
680: MFG_LOOKUPS
681: WHERE LOOKUP_TYPE = 'SYS_YES_NO'
682: AND LOOKUP_CODE = P_DISPLAY_ADD_INFO;
683: RETURN (TEXT);
684: END;