View: BSC_SYS_DIM_LEVEL_RELS_V

Product:	BSC - Balanced Scorecard
Description:	View of BSC_SYS_DIM_RELS and BSC_SYS_DIM_LEVELS_B.
Implementation/DBA Data:	APPS.BSC_SYS_DIM_LEVEL_RELS_V

View Text

SELECT LR.DIM_LEVEL_ID
, DL.SHORT_NAME
, DL .SOURCE
, LR.PARENT_DIM_LEVEL_ID
, PL.SHORT_NAME PARENT_SHORT_NAME
, PL.NAME PARENT_NAME
, PL.SOURCE PARENT_SOURCE
, LR.RELATION_COL
FROM BSC_SYS_DIM_LEVEL_RELS LR
, BSC_SYS_DIM_LEVELS_VL DL
, BSC_SYS_DIM_LEVELS_VL PL
WHERE DL.DIM_LEVEL_ID = LR.DIM_LEVEL_ID
AND PL.DIM_LEVEL_ID = LR.PARENT_DIM_LEVEL_ID

Columns