FND Design Data [Home] [Help]

View: BIS_DIMENSIONS_RPTS_V

Product: BIS - Applications BIS
Description:
Implementation/DBA Data: ViewAPPS.BIS_DIMENSIONS_RPTS_V
View Text

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