VIEW: APPS.PMITS_ITEM_LOT_UOM_CONV_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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