MSC_DIM_EXCEPTION_TYPE_V
Details
-
Schema: FUSION
-
Object owner: MSC
-
Object type: VIEW
Columns
| Name |
|---|
|
ID NAME DESCRIPTION LEVEL_ID |
Query
| SQL_Statement |
|---|
|
SELECT DISTINCT MEXB.EXCEPTION_ID AS ID, MEXTL.NAME AS NAME, MEXTL.NAME AS DESCRIPTION, 78 AS LEVEL_ID FROM MSC_EXCEPTION_B MEXB, MSC_EXCEPTION_TL MEXTL WHERE MEXTL.EXCEPTION_ID = MEXB.EXCEPTION_ID and MEXTL.LANGUAGE = USERENV('LANG') |