VIEW: APPS.MTH_EQUIPMENTS_OCV

Source

View Text - Preformatted

SELECT DISTINCT(CODE), MEANING, USERENV('LANG') LANGUAGE FROM (SELECT ENTITY_PK_KEY CODE,ENTITY_NAME MEANING FROM MTH_EQUIP_ENTITIES_MST UNION SELECT PLANT_PK_KEY CODE,PLANT_NAME MEANING FROM MTH_PLANTS_D UNION SELECT RESOURCE_PK_KEY CODE,RESOURCE_NAME MEANING FROM MTH_RESOURCES_D )CLASSIFICATIONS, MTH_EQUIPMENT_DENORM_D D WHERE D.EQUIPMENT_HIERARCHY_KEY =MTH_UTIL_PKG.Get_UDA_Eq_HId AND CLASSIFICATIONS.CODE = DECODE (MTH_UTIL_PKG.Get_UDA_Eq_LNO,9, D.LEVEL9_LEVEL_KEY, 8,D.LEVEL8_LEVEL_KEY, 7, D.LEVEL7_LEVEL_KEY, 6, D.LEVEL6_LEVEL_KEY, 5, D.LEVEL5_LEVEL_KEY, 4, D.LEVEL4_LEVEL_KEY, 3, D.LEVEL3_LEVEL_KEY, 2, D.LEVEL2_LEVEL_KEY, 1, D.LEVEL1_LEVEL_KEY)

View Text - HTML Formatted

SELECT DISTINCT(CODE)
, MEANING
, USERENV('LANG') LANGUAGE
FROM (SELECT ENTITY_PK_KEY CODE
, ENTITY_NAME MEANING
FROM MTH_EQUIP_ENTITIES_MST UNION SELECT PLANT_PK_KEY CODE
, PLANT_NAME MEANING
FROM MTH_PLANTS_D UNION SELECT RESOURCE_PK_KEY CODE
, RESOURCE_NAME MEANING
FROM MTH_RESOURCES_D )CLASSIFICATIONS
, MTH_EQUIPMENT_DENORM_D D
WHERE D.EQUIPMENT_HIERARCHY_KEY =MTH_UTIL_PKG.GET_UDA_EQ_HID
AND CLASSIFICATIONS.CODE = DECODE (MTH_UTIL_PKG.GET_UDA_EQ_LNO
, 9
, D.LEVEL9_LEVEL_KEY
, 8
, D.LEVEL8_LEVEL_KEY
, 7
, D.LEVEL7_LEVEL_KEY
, 6
, D.LEVEL6_LEVEL_KEY
, 5
, D.LEVEL5_LEVEL_KEY
, 4
, D.LEVEL4_LEVEL_KEY
, 3
, D.LEVEL3_LEVEL_KEY
, 2
, D.LEVEL2_LEVEL_KEY
, 1
, D.LEVEL1_LEVEL_KEY)