[Home] [Help]
View: EDW_LEVELS_MD_V
Product: | BIS - Applications BIS |
Description: | EDW_LEVELS_MD_V |
Implementation/DBA Data: |
APPS.EDW_LEVELS_MD_V
|
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 |