VIEW: APPS.BSC_OAF_DIM_LEVELS_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'