[Home] [Help]
View: SY_UOMS_MST_V
Product: | GMA - Process Manufacturing Systems |
Description: | View of unit of measure master |
Implementation/DBA Data: |
APPS.SY_UOMS_MST_V
|
View Text
SELECT DECODE(LENGTHB(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)
, UOM.UOM_CLASS
, CONVERSION_RATE
, UOM.UNIT_OF_MEASURE
, UOM.UOM_CODE
, UOM.LAST_UPDATE_LOGIN
, UOM.LAST_UPDATE_DATE
, UOM.LAST_UPDATED_BY
, UOM.CREATION_DATE
, UOM.CREATED_BY
, DECODE(SIGN(SYSDATE-UOM.DISABLE_DATE)
, 1
, 1
, 0)
, 0
, 0
, NULL
, 0
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
Name |
UM_CODE |
UM_DESC |
UM_TYPE |
STD_FACTOR |
UNIT_OF_MEASURE |
UOM_CODE |
LAST_UPDATE_LOGIN |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
CREATION_DATE |
CREATED_BY |
DELETE_MARK |
TEXT_CODE |
RND_FACTOR |
REF_UM |
TRANS_CNT |