View: BIS_FLEX_MAPPINGS_V

Product:	BIS - Applications BIS
Description:
Implementation/DBA Data:	APPS.BIS_FLEX_MAPPINGS_V

View Text

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

Columns