View: EDW_LEVEL_ATTS_MD_V

View Text

SELECT DIM.ELEMENTID
, DIM.NAME
, LVL.ELEMENTID
, LVL.NAME
, UCOL.ELEMENTID
, UCOL.NAME
, UCOL.LONGNAME
, TO_NUMBER(NULL)
, NULL
FROM CMPWBDIMENSION_V DIM
, CMPLEVEL_V LVL
, CMPRELATIONALDBITEM_V UCOL
WHERE DIM.ELEMENTID = LVL.DIMENSION
AND LVL.ELEMENTID = UCOL.OWNINGRELATION
AND NOT EXISTS ( SELECT 1
FROM CMPUNIQUEKEY_V UK
, CMPWBITEMSETUSAGE_V UKEYCOL
WHERE LVL.ELEMENTID = UK.OWNINGRELATION
AND UK.ELEMENTID = UKEYCOL.ITEMSET
AND UKEYCOL.ATTRIBUTE = UCOL.ELEMENTID ) UNION SELECT DIM.ELEMENTID
, DIM.NAME
, LVL.ELEMENTID
, LVL.NAME
, UCOL.ELEMENTID
, UCOL.NAME
, UCOL.LONGNAME
, UK.ELEMENTID
, UK.NAME
FROM CMPLEVEL_V LVL
, CMPUNIQUEKEY_V UK
, CMPWBITEMSETUSAGE_V UKEYCOL
, CMPRELATIONALDBITEM_V UCOL
, CMPWBDIMENSION_V DIM
WHERE DIM.ELEMENTID = LVL.DIMENSION
AND LVL.ELEMENTID = UCOL.OWNINGRELATION
AND LVL.ELEMENTID = UK.OWNINGRELATION
AND UK.ELEMENTID = UKEYCOL.ITEMSET
AND UKEYCOL.ATTRIBUTE = UCOL.ELEMENTID WITH READ ONLY

Columns