[Home] [Help]
View: EDW_LEVELS_MD_V
| Product: | BIS - Applications BIS |
|---|
| Description: | EDW_LEVELS_MD_V |
|---|
| Implementation/DBA Data: |
Not implemented in this database
|
|---|
View Text
SELECT DIMLVL.ELEMENTID
, DIMLVL.NAME
, DIMLVL.PREFIX
, DIMLVL.LONGNAME
, TBL.ELEMENTID
, DECODE(TBL.ELEMENTID
, NULL
, NULL
, DIMLVL.NAME||'_LTC')
, DIMLVL.DIMENSION
, DIM.NAME
, DIMLVL.DESCRIPTION
FROM CMPLEVEL_V DIMLVL
, CMPWBTABLE_V TBL
, CMPWBDIMENSION_V DIM
WHERE DIMLVL.NAME||'_LTC' = TBL.NAME (+)
AND DIMLVL.DIMENSION = DIM.ELEMENTID WITH READ ONLY
Columns
| Name |
| LEVEL_ID |
| LEVEL_NAME |
| LEVEL_PREFIX |
| LEVEL_LONG_NAME |
| LEVEL_TABLE_ID |
| LEVEL_TABLE_NAME |
| DIM_ID |
| DIM_NAME |
| DESCRIPTION |