APPS.INV_INVISMMX_XMLP_PKG dependencies on MFG_LOOKUPS

Line 29: MFG_LOOKUPS

25: SELECT
26: MEANING
27: INTO ERROR_MESSAGE
28: FROM
29: MFG_LOOKUPS
30: WHERE LOOKUP_TYPE = 'INV_MMX_RPT_MSGS'
31: AND LOOKUP_CODE = 3;
32: EXCEPTION
33: WHEN OTHERS THEN

Line 123: MFG_LOOKUPS

119: SELECT
120: MEANING
121: INTO P_SORTER
122: FROM
123: MFG_LOOKUPS
124: WHERE LOOKUP_TYPE = 'MTL_MINMAX_RPT_SORT_BY'
125: AND LOOKUP_CODE = DECODE(P_SORT
126: ,1
127: ,2

Line 186: MFG_LOOKUPS

182: SELECT
183: MEANING
184: INTO P_SB_TEXT
185: FROM
186: MFG_LOOKUPS
187: WHERE LOOKUP_TYPE = 'MTL_MINMAX_RPT_SORT_BY'
188: AND LOOKUP_CODE = P_SORT;
189: SELECT
190: MEANING

Line 193: MFG_LOOKUPS

189: SELECT
190: MEANING
191: INTO P_SELECTION_TEXT
192: FROM
193: MFG_LOOKUPS
194: WHERE LOOKUP_TYPE = 'MTL_MINMAX_RPT_SEL'
195: AND LOOKUP_CODE = P_SELECTION;
196: SELECT
197: MEANING

Line 200: MFG_LOOKUPS

196: SELECT
197: MEANING
198: INTO P_LVL_TEXT
199: FROM
200: MFG_LOOKUPS
201: WHERE LOOKUP_TYPE = 'MTL_MINMAX_LEVEL'
202: AND LOOKUP_CODE = P_LEVEL;
203: SELECT
204: MEANING

Line 207: MFG_LOOKUPS

203: SELECT
204: MEANING
205: INTO P_DISPLAY_MODE_TEXT
206: FROM
207: MFG_LOOKUPS
208: WHERE LOOKUP_TYPE = 'INV_SRS_MMX_REPORT_FORMAT'
209: AND LOOKUP_CODE = P_DISPLAY_MODE;
210: LINE_NUM := 230;
211: IF P_HANDLE_REP_ITEM IS NULL THEN

Line 218: MFG_LOOKUPS

214: SELECT
215: MEANING
216: INTO P_REPITM_TEXT
217: FROM
218: MFG_LOOKUPS
219: WHERE LOOKUP_TYPE = 'MTL_MINMAX_HANDLE_REP_ITEM'
220: AND LOOKUP_CODE = P_HANDLE_REP_ITEM;
221: IF P_DD_LOC_ID IS NOT NULL THEN
222: SELECT

Line 240: MFG_LOOKUPS

236: SELECT
237: MEANING
238: INTO P_YES_TEXT
239: FROM
240: MFG_LOOKUPS
241: WHERE LOOKUP_TYPE = 'SYS_YES_NO'
242: AND LOOKUP_CODE = 1;
243: SELECT
244: MEANING

Line 247: MFG_LOOKUPS

243: SELECT
244: MEANING
245: INTO P_NO_TEXT
246: FROM
247: MFG_LOOKUPS
248: WHERE LOOKUP_TYPE = 'SYS_YES_NO'
249: AND LOOKUP_CODE = 2;
250: LINE_NUM := 250;
251: SELECT

Line 255: MFG_LOOKUPS

251: SELECT
252: MEANING
253: INTO P_LOTCTL_TEXT
254: FROM
255: MFG_LOOKUPS
256: WHERE LOOKUP_TYPE = 'MIN_MAX_REPORT_LOT_CONTROL'
257: AND LOOKUP_CODE = NVL(P_LOT_CTL
258: ,3);
259: IF P_INCLUDE_NONNET = 1 THEN