VIEW: APPS.BIS_FLEX_SEG_MAPPINGS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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