VIEW: APPS.BIS_DIMENSIONS_RPTS_V

Source

View Text - Preformatted

SELECT bl.source , bd.dimension_id id , bd.name value FROM bis_dimensions_vl bd, bis_levels_vl bl WHERE bd.dimension_id = bl.dimension_id AND NVL(bd.hide_in_design, 'F') <> 'T' GROUP BY bl.source, bd.dimension_id, bd.name

View Text - HTML Formatted

SELECT BL.SOURCE
, BD.DIMENSION_ID ID
, BD.NAME VALUE
FROM BIS_DIMENSIONS_VL BD
, BIS_LEVELS_VL BL
WHERE BD.DIMENSION_ID = BL.DIMENSION_ID
AND NVL(BD.HIDE_IN_DESIGN
, 'F') <> 'T' GROUP BY BL.SOURCE
, BD.DIMENSION_ID
, BD.NAME