[Home] [Help]
View: BSC_OAF_DIM_LEVELS_V
Product: | BSC - Balanced Scorecard |
Description: | View of the dimension levels for IBUILDER |
Implementation/DBA Data: |
APPS.BSC_OAF_DIM_LEVELS_V
|
View Text
SELECT DIM_LEVEL_ID
, SHORT_NAME
, NAME
, LEVEL_VIEW_NAME
, BSC_OAF_VIEWS_PVT.GET_LEVEL_PARENT_NAMES(DIM_LEVEL_ID) AS PARENTS
, BSC_SOURCE SOURCE
, IMPORTED_FLAG
FROM BSC_BIS_DIM_LEVELS_V
WHERE BSC_SOURCE = 'PMF'
Columns
Name |
DIM_LEVEL_ID |
SHORT_NAME |
NAME |
LEVEL_VIEW_NAME |
PARENTS |
SOURCE |
IMPORTED_FLAG |