View: OPI_PMI_UOMS_MST_V

Product:	OPI - Operations Intelligence
Description:	Allows for the translation of OPM Instance-UOMs to Apps Instance-UOM's. Once facts are in Apps Instance UOMs, they can be converted to EDW Warehouse UOM's using the standard EDW_UTIL package.
Implementation/DBA Data:	APPS.OPI_PMI_UOMS_MST_V

View Text

SELECT DECODE(LENGTH(UOM.UNIT_OF_MEASURE)
, 1
, UOM.UNIT_OF_MEASURE
, 2
, UOM.UNIT_OF_MEASURE
, 3
, UOM.UNIT_OF_MEASURE
, 4
, UOM.UNIT_OF_MEASURE
, UOM.UOM_CODE) UM_CODE
, SUBSTR(UOM.DESCRIPTION
, 1
, 40) UM_DESC
, UOM.UOM_CLASS UM_TYPE
, CONVERSION_RATE STD_FACTOR
, UOM.UNIT_OF_MEASURE UNIT_OF_MEASURE
, UOM.UOM_CODE UOM_CODE
, UOM.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, UOM.LAST_UPDATE_DATE LAST_UPDATE_DATE
, UOM.LAST_UPDATED_BY LAST_UPDATED_BY
, UOM.CREATION_DATE CREATION_DATE
, UOM.CREATED_BY CREATED_BY
, DECODE(SIGN(SYSDATE-UOM.DISABLE_DATE)
, 1
, 1
, 0) DELETE_MARK
, 0 TEXT_CODE
, 0 RND_FACTOR
, NULL REF_UM
, 0 TRANS_CNT
FROM MTL_UNITS_OF_MEASURE UOM
, MTL_UOM_CONVERSIONS UOMC
WHERE UOMC.UNIT_OF_MEASURE = UOM.UNIT_OF_MEASURE
AND UOMC.INVENTORY_ITEM_ID = 0

Columns