DBA Data[Home] [Help]

APPS.GME_GMEMUSBV_XMLP_PKG dependencies on FM_MATL_DTL

Line 326: FM_MATL_DTL

322: SELECT
323: QTY,
324: DETAIL_UOM
325: FROM
326: FM_MATL_DTL
327: WHERE FORMULA_ID = trans_qtyformula_005.FORMULA_ID
328: AND ORGANIZATION_ID = P_ORG_ID
329: AND INVENTORY_ITEM_ID = X_ITEM_ID
330: AND LINE_TYPE = 1;

Line 350: FM_MATL_DTL

346: CURSOR CUR_SCRAP_FACTOR IS
347: SELECT
348: SCRAP_FACTOR
349: FROM
350: FM_MATL_DTL
351: WHERE FORMULALINE_ID = trans_qtyformula_005.FORMULALINE_ID
352: AND FORMULA_ID = trans_qtyformula_005.FORMULA_ID
353: AND LINE_TYPE = - 1;
354: CURSOR CUR_GET_INFO(PBATCH_ID IN NUMBER) IS

Line 388: FM_MATL_DTL

384: CURSOR CUR_MTL_DTLS IS
385: SELECT
386: *
387: FROM
388: FM_MATL_DTL
389: WHERE FORMULA_ID = trans_qtyformula_005.FORMULA_ID
390: AND LINE_TYPE in ( 1 , 2 );
391: L_RECIPE_ID NUMBER;
392: L_ORGN_CODE VARCHAR2(4);