DBA Data[Home] [Help]

APPS.GME_GMEBCHYV_XMLP_PKG dependencies on FM_MATL_DTL

Line 213: FM_MATL_DTL

209: SELECT
210: QTY,
211: DETAIL_UOM
212: FROM
213: FM_MATL_DTL
214: WHERE FORMULA_ID = cf_plan_qty_itemumformula.FORMULA_ID
215: AND ORGANIZATION_ID = P_ORG_ID
216: AND INVENTORY_ITEM_ID = X_ITEM_ID
217: AND LINE_TYPE = 1;

Line 237: FM_MATL_DTL

233: CURSOR CUR_SCRAP_FACTOR IS
234: SELECT
235: SCRAP_FACTOR
236: FROM
237: FM_MATL_DTL
238: WHERE FORMULALINE_ID = cf_plan_qty_itemumformula.FORMULALINE_ID
239: AND FORMULA_ID = cf_plan_qty_itemumformula.FORMULA_ID
240: AND LINE_TYPE = - 1;
241: CURSOR CUR_GET_FORMULA_DETAILS IS

Line 254: FM_MATL_DTL

250: SCALE_ROUNDING_VARIANCE,
251: ROUNDING_DIRECTION,
252: CONTRIBUTE_YIELD_IND
253: FROM
254: FM_MATL_DTL
255: WHERE FORMULA_ID = cf_plan_qty_itemumformula.FORMULA_ID;
256: X_TRANS_QTY NUMBER := 0;
257: X_COUNT NUMBER(5);
258: X_ITEM_UM VARCHAR2(4);