VIEW: APPS.OPI_PMI_UOMS_MST_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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