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;
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
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);