VIEW: APPS.BIS_IND_TL_LVL_V

Source

View Text - Preformatted

SELECT indicator_id, target_level_id, dimension1_level_id FROM ( SELECT indicator_id, target_level_id, dimension1_level_id FROM bis_target_levels WHERE dimension1_level_id IS NOT NULL UNION SELECT indicator_id, target_level_id, dimension2_level_id FROM bis_target_levels WHERE dimension2_level_id IS NOT NULL UNION SELECT indicator_id, target_level_id, dimension3_level_id FROM bis_target_levels WHERE dimension3_level_id IS NOT NULL UNION SELECT indicator_id, target_level_id, dimension4_level_id FROM bis_target_levels WHERE dimension4_level_id IS NOT NULL UNION SELECT indicator_id, target_level_id, dimension5_level_id FROM bis_target_levels WHERE dimension5_level_id IS NOT NULL UNION SELECT indicator_id, target_level_id, dimension6_level_id FROM bis_target_levels WHERE dimension6_level_id IS NOT NULL UNION SELECT indicator_id, target_level_id, dimension7_level_id FROM bis_target_levels WHERE dimension7_level_id IS NOT NULL ) GROUP BY indicator_id, target_level_id, dimension1_level_id

View Text - HTML Formatted

SELECT INDICATOR_ID
, TARGET_LEVEL_ID
, DIMENSION1_LEVEL_ID
FROM ( SELECT INDICATOR_ID
, TARGET_LEVEL_ID
, DIMENSION1_LEVEL_ID
FROM BIS_TARGET_LEVELS
WHERE DIMENSION1_LEVEL_ID IS NOT NULL UNION SELECT INDICATOR_ID
, TARGET_LEVEL_ID
, DIMENSION2_LEVEL_ID
FROM BIS_TARGET_LEVELS
WHERE DIMENSION2_LEVEL_ID IS NOT NULL UNION SELECT INDICATOR_ID
, TARGET_LEVEL_ID
, DIMENSION3_LEVEL_ID
FROM BIS_TARGET_LEVELS
WHERE DIMENSION3_LEVEL_ID IS NOT NULL UNION SELECT INDICATOR_ID
, TARGET_LEVEL_ID
, DIMENSION4_LEVEL_ID
FROM BIS_TARGET_LEVELS
WHERE DIMENSION4_LEVEL_ID IS NOT NULL UNION SELECT INDICATOR_ID
, TARGET_LEVEL_ID
, DIMENSION5_LEVEL_ID
FROM BIS_TARGET_LEVELS
WHERE DIMENSION5_LEVEL_ID IS NOT NULL UNION SELECT INDICATOR_ID
, TARGET_LEVEL_ID
, DIMENSION6_LEVEL_ID
FROM BIS_TARGET_LEVELS
WHERE DIMENSION6_LEVEL_ID IS NOT NULL UNION SELECT INDICATOR_ID
, TARGET_LEVEL_ID
, DIMENSION7_LEVEL_ID
FROM BIS_TARGET_LEVELS
WHERE DIMENSION7_LEVEL_ID IS NOT NULL ) GROUP BY INDICATOR_ID
, TARGET_LEVEL_ID
, DIMENSION1_LEVEL_ID