[Home] [Help]
View: SY_UOMS_TYP_V
Product: | GMA - Process Manufacturing Systems |
Description: | View of unit of measure types |
Implementation/DBA Data: |
APPS.SY_UOMS_TYP_V
|
View Text
SELECT UOMC.UOM_CLASS
, SUBSTR(UOMC.DESCRIPTION
, 1
, 40)
, UOMC.LAST_UPDATE_LOGIN
, UOMC.LAST_UPDATE_DATE
, UOMC.LAST_UPDATED_BY
, UOMC.CREATION_DATE
, UOMC.CREATED_BY
, DECODE(SIGN(SYSDATE-UOMC.DISABLE_DATE)
, 1
, 1
, 0)
, 0
, 0
, 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) STD_UM
FROM MTL_UNITS_OF_MEASURE UOM
, MTL_UOM_CLASSES UOMC
WHERE UOMC.UOM_CLASS = UOM.UOM_CLASS
AND UOM.BASE_UOM_FLAG = 'Y'
Columns
Name |
UM_TYPE |
TYPE_DESC |
LAST_UPDATE_LOGIN |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
CREATION_DATE |
CREATED_BY |
DELETE_MARK |
TEXT_CODE |
TRANS_CNT |
STD_UM |