Product: | PMI - Process Manufacturing Intelligence (Obsolete) |
---|---|
Description: | This is created on top of OPM IC_ITEM_CNV. This view gives UOM Conversion factor at item lot level. |
Implementation/DBA Data: | APPS.PMITS_ITEM_LOT_UOM_CONV_V |
SELECT LOT.LOT_ID
, LOT.LOT_NO
, LOT.SUBLOT_NO
, CNV.UM_TYPE
, FROM_UOM_TYP.UM_TYPE
, FROM_UOM_TYP.STD_UM
, TO_UOM_TYP.STD_UM
, ITEM.ITEM_ID
, ITEM.ITEM_NO
, ITEM.ITEM_UM
, CNV.TYPE_FACTOR
, CNV.TYPE_FACTORREV
, CNV.CREATION_DATE
, CNV.CREATED_BY
, CNV.LAST_UPDATE_LOGIN
, CNV.LAST_UPDATE_DATE
, CNV.LAST_UPDATED_BY
, CNV.DELETE_MARK
, CNV.TEXT_CODE
FROM IC_ITEM_CNV CNV
, IC_ITEM_MST ITEM
, IC_LOTS_MST LOT
, SY_UOMS_TYP_V FROM_UOM_TYP
, SY_UOMS_TYP_V TO_UOM_TYP
, SY_UOMS_MST_V FROM_ITEM_UOM
WHERE CNV.ITEM_ID = ITEM.ITEM_ID
AND CNV.ITEM_ID = LOT.ITEM_ID
AND CNV.LOT_ID = LOT.LOT_ID
AND ITEM.ITEM_UM = FROM_ITEM_UOM.UM_CODE
AND FROM_ITEM_UOM.UM_TYPE = FROM_UOM_TYP.UM_TYPE
AND TO_UOM_TYP.UM_TYPE = CNV.UM_TYPE