APPS.GME_GMEMUSBV_XMLP_PKG dependencies on GME_MATERIAL_DETAILS

Line 220: GME_MATERIAL_DETAILS

216: SELECT
217: PLAN_QTY
218: INTO PLANQTY
219: FROM
220: GME_MATERIAL_DETAILS
221: WHERE BATCH_ID = CF_BATCH_SIZEFORMULA.BATCH_ID
222: AND INVENTORY_ITEM_ID = (
223: SELECT
224: INVENTORY_ITEM_ID

Line 233: GME_MATERIAL_DETAILS

229: SELECT
230: PLAN_QTY
231: INTO PLANQTY
232: FROM
233: GME_MATERIAL_DETAILS
234: WHERE BATCH_ID = CF_BATCH_SIZEFORMULA.BATCH_ID
235: AND LINE_TYPE = 1
236: AND LINE_NO = 1;
237: END IF;

Line 254: GME_MATERIAL_DETAILS

250: SELECT
251: DTL_UM
252: INTO ITEMUM
253: FROM
254: GME_MATERIAL_DETAILS
255: WHERE BATCH_ID = cf_itemumformula.BATCH_ID
256: AND INVENTORY_ITEM_ID = (
257: SELECT
258: INVENTORY_ITEM_ID

Line 267: GME_MATERIAL_DETAILS

263: SELECT
264: DTL_UM
265: INTO ITEMUM
266: FROM
267: GME_MATERIAL_DETAILS
268: WHERE BATCH_ID = cf_itemumformula.BATCH_ID
269: AND LINE_TYPE = 1
270: AND LINE_NO = 1;
271: END IF;

Line 336: GME_MATERIAL_DETAILS

332: SELECT
333: PLAN_QTY,
334: DTL_UM
335: FROM
336: GME_MATERIAL_DETAILS
337: WHERE BATCH_ID = trans_qtyformula_005.BATCH_ID
338: AND INVENTORY_ITEM_ID = X_ITEM_ID
339: AND LINE_TYPE = 1;
340: CURSOR CUR_PLAN_QTY IS