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