DBA Data[Home] [Help]

APPS.PMI_PRODUCTION_SUM dependencies on GMICUOM

Line 556: SELECT sum(gmicuom.i2uom_cv(BtchDtl.ITEM_ID,0,BtchDtl.ITEM_UM,

552: FUNCTION PLAN_ING_VALUE(BATCH_ID_VI IN INTEGER) RETURN NUMBER
553: is
554: PLAN_ING_VALUE_V NUMBER := 0;
555: Begin
556: SELECT sum(gmicuom.i2uom_cv(BtchDtl.ITEM_ID,0,BtchDtl.ITEM_UM,
557: BtchDtl.PLAN_QTY,ItemMst.ITEM_UM)*pmi_common_pkg.PMICO_GET_COST(
558: BtchDtl.ITEM_ID,BtchHdr.WIP_WHSE_CODE,NULL,BtchHdr.ACTUAL_CMPLT_DATE))
559: into PLAN_ING_VALUE_V
560: FROM

Line 576: SELECT sum(gmicuom.i2uom_cv(BtchDtl.ITEM_ID,0,BtchDtl.ITEM_UM,

572: FUNCTION ACTUAL_ING_VALUE(BATCH_ID_VI IN INTEGER) RETURN NUMBER
573: is
574: ACTUAL_ING_VALUE_V NUMBER := 0;
575: Begin
576: SELECT sum(gmicuom.i2uom_cv(BtchDtl.ITEM_ID,0,BtchDtl.ITEM_UM,
577: BtchDtl.ACTUAL_QTY,ItemMst.ITEM_UM)*pmi_common_pkg.PMICO_GET_COST(
578: BtchDtl.ITEM_ID,BtchHdr.WIP_WHSE_CODE,NULL,BtchHdr.ACTUAL_CMPLT_DATE))
579: into ACTUAL_ING_VALUE_V
580: FROM