View: PMI_REP_EXP_INVENTORY_V

Product:	PMI - Process Manufacturing Intelligence
Description:	This view is used for PMI Expired Inventory Report
Implementation/DBA Data:	APPS.PMI_REP_EXP_INVENTORY_V

View Text

SELECT ORGMST.CO_CODE COMPANY_ID
, ORGMST.ORGN_CODE ORGANIZATION_ID
, WHSMST.WHSE_CODE WAREHOUSE_ID
, DECODE(PROFILE.DEFAULT_UOM
, ITMMST.ITEM_UM
, LOCTINV.LOCT_ONHAND
, ITMMST.ITEM_UM2
, LOCTINV.LOCT_ONHAND2
, GMICUOM.I2UOM_CV(LOCTINV.ITEM_ID
, LOCTINV.LOT_ID
, ITMMST.ITEM_UM
, LOCTINV.LOCT_ONHAND
, PROFILE.DEFAULT_UOM)) CONV_ONHAND
, LOCTINV.LOCT_ONHAND * PMI_COMMON_PKG.PMICO_GET_COST(LOCTINV.ITEM_ID
, LOCTINV.WHSE_CODE
, NULL
, SYSDATE) CUR_OHD_VAL
, DECODE(SIGN(SYSDATE-LOTMST.EXPIRE_DATE)
, 1
, (DECODE(PROFILE.DEFAULT_UOM
, ITMMST.ITEM_UM
, LOCTINV.LOCT_ONHAND
, ITMMST.ITEM_UM2
, LOCTINV.LOCT_ONHAND2
, GMICUOM.I2UOM_CV(LOCTINV.ITEM_ID
, LOCTINV.LOT_ID
, ITMMST.ITEM_UM
, LOCTINV.LOCT_ONHAND
, PROFILE.DEFAULT_UOM)))
, 0) CONV_EXP_QTY
, DECODE(SIGN(SYSDATE-LOTMST.EXPIRE_DATE)
, 1
, (LOCTINV.LOCT_ONHAND * PMI_COMMON_PKG.PMICO_GET_COST(LOCTINV.ITEM_ID
, LOCTINV.WHSE_CODE
, NULL
, SYSDATE))
, 0) CUR_EXP_VAL
FROM IC_LOCT_INV LOCTINV
, IC_ITEM_MST ITMMST
, IC_LOTS_MST LOTMST
, IC_WHSE_MST WHSMST
, SY_ORGN_MST ORGMST
, (SELECT FND_PROFILE.VALUE('PMI$CONV_UOM') DEFAULT_UOM
FROM DUAL) PROFILE
WHERE ORGMST.ORGN_CODE = WHSMST.ORGN_CODE
AND WHSMST.WHSE_CODE = LOCTINV.WHSE_CODE
AND ITMMST.ITEM_ID = LOCTINV.ITEM_ID
AND LOCTINV.ITEM_ID = LOTMST.ITEM_ID
AND LOCTINV.LOT_ID = LOTMST.LOT_ID
AND LOCTINV.LOCT_ONHAND <> 0
AND LOCTINV.LOT_ID <> 0
AND 'TRUE' = PMI_SECURITY_PKG.SHOW_RECORD(ORGMST.ORGN_CODE)

Columns