VIEW: APPS.BIS_FLEX_MAPPINGS_V

Source

View Text - Preformatted

SELECT f.SEG_MAPPING_LINE_ID ,f.SEGMENT_NAME ,f.APPLICATION_ID ,e.APPLICATION_NAME ,f.ID_FLEX_CODE ,e.FLEX_FIELD_NAME ,e.FLEX_FIELD_TYPE ,f.STRUCTURE_NUM ,f.STRUCTURE_NAME ,f.APPLICATION_COLUMN_NAME ,f.VALUE_SET_ID ,f.INSTANCE_CODE ,f.DIMENSION_ID ,d.NAME ,f.LEVEL_ID ,l.SHORT_NAME ,l.NAME ,f.WH_DIMENSION_NAME ,f.LAST_UPDATE_DATE ,f.LAST_UPDATED_BY ,f.LAST_UPDATE_LOGIN ,f.CREATED_BY ,f.CREATION_DATE FROM BIS_FLEX_SEG_MAPPING_LINES f ,BIS_FLEX_FIELDS_V e ,BIS_LEVELS_VL l ,BIS_DIMENSIONS_VL d WHERE f.APPLICATION_ID = e.APPLICATION_ID AND f.ID_FLEX_CODE = e.FLEX_FIELD_CODE AND f.DIMENSION_ID = l.DIMENSION_ID(+) AND f.LEVEL_ID = l.LEVEL_ID AND l.DIMENSION_ID = d.DIMENSION_ID(+) WITH READ ONLY

View Text - HTML Formatted

SELECT F.SEG_MAPPING_LINE_ID
, F.SEGMENT_NAME
, F.APPLICATION_ID
, E.APPLICATION_NAME
, F.ID_FLEX_CODE
, E.FLEX_FIELD_NAME
, E.FLEX_FIELD_TYPE
, F.STRUCTURE_NUM
, F.STRUCTURE_NAME
, F.APPLICATION_COLUMN_NAME
, F.VALUE_SET_ID
, F.INSTANCE_CODE
, F.DIMENSION_ID
, D.NAME
, F.LEVEL_ID
, L.SHORT_NAME
, L.NAME
, F.WH_DIMENSION_NAME
, F.LAST_UPDATE_DATE
, F.LAST_UPDATED_BY
, F.LAST_UPDATE_LOGIN
, F.CREATED_BY
, F.CREATION_DATE
FROM BIS_FLEX_SEG_MAPPING_LINES F
, BIS_FLEX_FIELDS_V E
, BIS_LEVELS_VL L
, BIS_DIMENSIONS_VL D
WHERE F.APPLICATION_ID = E.APPLICATION_ID
AND F.ID_FLEX_CODE = E.FLEX_FIELD_CODE
AND F.DIMENSION_ID = L.DIMENSION_ID(+)
AND F.LEVEL_ID = L.LEVEL_ID
AND L.DIMENSION_ID = D.DIMENSION_ID(+) WITH READ ONLY