DBA Data[Home] [Help]

APPS.PMI_BUILD_ONHANDSALE_SUM dependencies on GMICUOM

Line 442: gmicuom.i2uom_cv(item_id,0,item_um,WHSE_ONHAND_QTY,PV_conv_uom)) WHSE_ONHAND_CONV

438: ,ITEM_NO
439: ,ITEM_UM
440: ,WHSE_ONHAND_QTY
441: ,decode(PV_conv_uom,item_um,WHSE_ONHAND_QTY,
442: gmicuom.i2uom_cv(item_id,0,item_um,WHSE_ONHAND_QTY,PV_conv_uom)) WHSE_ONHAND_CONV
443: ,WHSE_ONHAND_QTY *
444: pmi_common_pkg.PMICO_GET_COST(item_id,whse_code,null,GL_PERIOD_START_DATE) WHSE_ONHAND_VALUE
445: ,WHSE_SALE_QTY
446: ,decode(PV_conv_uom,item_um,WHSE_SALE_QTY,

Line 447: gmicuom.i2uom_cv(item_id,0,item_um,WHSE_SALE_QTY,PV_conv_uom)) WHSE_SALE_CONV

443: ,WHSE_ONHAND_QTY *
444: pmi_common_pkg.PMICO_GET_COST(item_id,whse_code,null,GL_PERIOD_START_DATE) WHSE_ONHAND_VALUE
445: ,WHSE_SALE_QTY
446: ,decode(PV_conv_uom,item_um,WHSE_SALE_QTY,
447: gmicuom.i2uom_cv(item_id,0,item_um,WHSE_SALE_QTY,PV_conv_uom)) WHSE_SALE_CONV
448: ,WHSE_SALE_QTY *
449: pmi_common_pkg.PMICO_GET_COST(item_id,whse_code,null,GL_PERIOD_START_DATE) WHSE_SALE_VALUE
450: ,WHSE_RTRN_QTY
451: ,WHSE_RTRN_CONV