[Home] [Help]
View: BIS_FLEX_SEG_MAPPINGS_V
View Text
SELECT DISTINCT SML.APPLICATION_ID
, SML.ID_FLEX_CODE
, SML.DIMENSION_ID
, SML.LEVEL_ID
, BD.NAME DIMENSION_NAME
, BL.NAME LEVEL_NAME
, SML.WH_DIMENSION_NAME
FROM BIS_FLEX_SEG_MAPPING_LINES SML
, BIS_DIMENSIONS_VL BD
, BIS_LEVELS_VL BL
WHERE BD.DIMENSION_ID = SML.DIMENSION_ID
AND BL.LEVEL_ID = SML.LEVEL_ID
Columns
Name |
APPLICATION_ID |
ID_FLEX_CODE |
DIMENSION_ID |
LEVEL_ID |
DIMENSION_NAME |
LEVEL_NAME |
WH_DIMENSION_NAME |