DBA Data[Home] [Help]

APPS.PMI_BUILD_ONHANDSALE_SUM dependencies on PMI_COMMON_PKG

Line 444: pmi_common_pkg.PMICO_GET_COST(item_id,whse_code,null,GL_PERIOD_START_DATE) WHSE_ONHAND_VALUE

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,
447: gmicuom.i2uom_cv(item_id,0,item_um,WHSE_SALE_QTY,PV_conv_uom)) WHSE_SALE_CONV
448: ,WHSE_SALE_QTY *

Line 449: pmi_common_pkg.PMICO_GET_COST(item_id,whse_code,null,GL_PERIOD_START_DATE) WHSE_SALE_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
452: ,WHSE_RTRN_VALUE
453: ,LOG_END_DATE