DBA Data[Home] [Help]

APPS.GME_GMEBCHYV_XMLP_PKG dependencies on GME_MATERIAL_DETAILS

Line 83: GME_MATERIAL_DETAILS PMD

79: PLAN_QTY,
80: DTL_UM
81: INTO PLANQTY,ITEMUM
82: FROM
83: GME_MATERIAL_DETAILS PMD
84: WHERE PMD.LINE_TYPE = 1
85: AND PMD.BATCH_ID = cf_formula_qty.BATCH_ID
86: AND INVENTORY_ITEM_ID = (
87: SELECT

Line 99: GME_MATERIAL_DETAILS PMD

95: PLAN_QTY,
96: DTL_UM
97: INTO PLANQTY,ITEMUM
98: FROM
99: GME_MATERIAL_DETAILS PMD
100: WHERE PMD.LINE_TYPE = 1
101: AND PMD.LINE_NO = 1
102: AND PMD.BATCH_ID = cf_formula_qty.BATCH_ID
103: AND ORGANIZATION_ID = P_ORG_ID;

Line 223: GME_MATERIAL_DETAILS

219: SELECT
220: PLAN_QTY,
221: DTL_UM
222: FROM
223: GME_MATERIAL_DETAILS
224: WHERE BATCH_ID = cf_plan_qty_itemumformula.BATCH_ID
225: AND INVENTORY_ITEM_ID = X_ITEM_ID
226: AND LINE_TYPE = 1;
227: CURSOR CUR_PLAN_QTY IS