Product: | BIS - Applications BIS |
---|---|
Description: | |
Implementation/DBA Data: | APPS.BIS_FLEX_SEG_MAPPING_LINES_V |
SELECT SML.ROWID ROW_ID
, SML.SEG_MAPPING_LINE_ID
, SML.APPLICATION_ID
, SML.ID_FLEX_CODE
, SML.STRUCTURE_NUM
, SML.STRUCTURE_NAME
, SML.APPLICATION_COLUMN_NAME
, SML.SEGMENT_NAME
, SML.VALUE_SET_ID
, INST.NAME INSTANCE_NAME
, SML.DIMENSION_ID
, SML.LEVEL_ID
, BD.NAME DIMENSION_NAME
, BL.NAME LEVEL_NAME
, SML.WH_DIMENSION_NAME
, SML.LAST_UPDATE_DATE
, SML.LAST_UPDATED_BY
, SML.LAST_UPDATE_LOGIN
, SML.CREATED_BY
, SML.CREATION_DATE
, INST.INSTANCE_CODE
FROM BIS_FLEX_SEG_MAPPING_LINES SML
, BIS_DIMENSIONS_VL BD
, BIS_LEVELS_VL BL
, EDW_SOURCE_INSTANCES_VL INST
WHERE BD.DIMENSION_ID = SML.DIMENSION_ID
AND BL.LEVEL_ID = SML.LEVEL_ID
AND SML.INSTANCE_CODE = INST.INSTANCE_CODE (+)