VIEW: APPS.BIS_FLEX_SEG_MAPPING_LINES_V

Source

View Text - Preformatted

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 (+)

View Text - HTML Formatted

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 (+)