[Home] [Help]
View: EDW_HIERARCHY_LEVEL_MD_V
| Product: | BIS - Applications BIS |
|---|
| Description: | EDW_HIERARCHY_LEVEL_MD_V |
|---|
| Implementation/DBA Data: |
Not implemented in this database
|
|---|
View Text
SELECT DIM.ELEMENTID
, DIM.NAME
, HIER.ELEMENTID
, HIER.NAME
, CLVL.ELEMENTID
, CLVL.NAME
, CLVL.PREFIX
, LVLREL.PARENTLEVEL
FROM CMPWBDIMENSION_V DIM
, CMPITEMHIERARCHY_V HIER
, CMPLEVELRELATIONSHIP_V LVLREL
, CMPLEVEL_V CLVL
WHERE DIM.ELEMENTID = HIER.OWNDIMENSION
AND HIER.ELEMENTID = LVLREL.HIERARCHY
AND LVLREL.CHILDLEVEL = CLVL.ELEMENTID WITH READ ONLY
Columns
| Name |
| DIM_ID |
| DIM_NAME |
| HIER_ID |
| HIER_NAME |
| LVL_ID |
| LVL_NAME |
| LVL_PREFIX |
| PARENT_LVL_ID |