APPS.INV_INVIRILC_XMLP_PKG dependencies on MFG_LOOKUPS

Line 162: MFG_LOOKUPS

158: SELECT
159: MEANING
160: INTO CONV_RATE_DSPLY
161: FROM
162: MFG_LOOKUPS
163: WHERE LOOKUP_TYPE = 'INV_LOC_QTY_RPT_MSGS'
164: AND LOOKUP_CODE = 1;
165: END IF;
166: IF CONV_RATE = -2 THEN

Line 171: MFG_LOOKUPS

167: SELECT
168: MEANING
169: INTO CONV_RATE_DSPLY
170: FROM
171: MFG_LOOKUPS
172: WHERE LOOKUP_TYPE = 'INV_LOC_QTY_RPT_MSGS'
173: AND LOOKUP_CODE = 2;
174: END IF;
175: IF CONV_RATE < -2 THEN

Line 180: MFG_LOOKUPS

176: SELECT
177: MEANING
178: INTO CONV_RATE_DSPLY
179: FROM
180: MFG_LOOKUPS
181: WHERE LOOKUP_TYPE = 'INV_LOC_QTY_RPT_MSGS'
182: AND LOOKUP_CODE = 3;
183: END IF;
184: EXCEPTION

Line 187: ,'ERROR in fetching data from MFG_LOOKUPS table')*/NULL;

183: END IF;
184: EXCEPTION
185: WHEN OTHERS THEN
186: /*SRW.MESSAGE(90
187: ,'ERROR in fetching data from MFG_LOOKUPS table')*/NULL;
188: /*RAISE SRW.PROGRAM_ABORT*/RAISE_APPLICATION_ERROR(-20101,null);
189: END;
190: IF CONV_RATE > -1 THEN
191: CONV_RATE_DSPLY := TO_CHAR(ROUND(CONV_RATE

Line 343: MFG_LOOKUPS

339: SELECT
340: MEANING
341: INTO CONV_RATE_DSPLY
342: FROM
343: MFG_LOOKUPS
344: WHERE LOOKUP_TYPE = 'INV_LOC_QTY_RPT_MSGS'
345: AND LOOKUP_CODE = 1;
346: END IF;
347: IF CONV_RATE = -2 THEN

Line 352: MFG_LOOKUPS

348: SELECT
349: MEANING
350: INTO CONV_RATE_DSPLY
351: FROM
352: MFG_LOOKUPS
353: WHERE LOOKUP_TYPE = 'INV_LOC_QTY_RPT_MSGS'
354: AND LOOKUP_CODE = 2;
355: END IF;
356: IF CONV_RATE < -2 THEN

Line 361: MFG_LOOKUPS

357: SELECT
358: MEANING
359: INTO CONV_RATE_DSPLY
360: FROM
361: MFG_LOOKUPS
362: WHERE LOOKUP_TYPE = 'INV_LOC_QTY_RPT_MSGS'
363: AND LOOKUP_CODE = 3;
364: END IF;
365: EXCEPTION

Line 368: ,'ERROR in fetching data from MFG_LOOKUPS table')*/NULL;

364: END IF;
365: EXCEPTION
366: WHEN OTHERS THEN
367: /*SRW.MESSAGE(90
368: ,'ERROR in fetching data from MFG_LOOKUPS table')*/NULL;
369: /*RAISE SRW.PROGRAM_ABORT*/RAISE_APPLICATION_ERROR(-20101,null);
370: END;
371: IF CONV_RATE > -1 THEN
372: CONV_RATE_DSPLY := TO_CHAR(ROUND(CONV_RATE