VIEW: APPS.BSC_SYS_DIM_LEVEL_RELS_V

Source

View Text - Preformatted

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 , LR.DATA_SOURCE_TYPE, LR.DATA_SOURCE 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

View Text - HTML Formatted

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
, LR.DATA_SOURCE_TYPE
, LR.DATA_SOURCE
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