VIEW: APPS.GL_CONS_SEGMENT_MAP_V

Source

View Text - Preformatted

SELECT mapv.row_id ROW_ID, mapv.segment_map_id SEGMENT_MAP_ID, mapv.coa_mapping_id MAPPING_ID, mapv.last_update_date LAST_UPDATE_DATE, mapv.last_updated_by LAST_UPDATED_BY, mapv.to_value_set_id TO_VALUE_SET_ID, mapv.to_application_column_name TO_APPLICATION_COLUMN_NAME, ffs1.segment_name TO_SEGMENT_NAME, ffs1.segment_num TO_SEGMENT_NUM, mapv.segment_map_type SEGMENT_MAP_TYPE, l.meaning SEGMENT_MAP_TYPE_DISPLAY, mapv.creation_date CREATION_DATE, mapv.created_by CREATED_BY, mapv.last_update_login LAST_UPDATE_LOGIN, mapv.from_value_set_id FROM_VALUE_SET_ID, mapv.from_application_column_name FROM_APPLICATION_COLUMN_NAME, ffs2.segment_name FROM_SEGMENT_NAME, ffs2.segment_num FROM_SEGMENT_NUM, mapv.single_value SINGLE_VALUE, mapv.attribute1 ATTRIBUTE1, mapv.attribute2 ATTRIBUTE2, mapv.attribute3 ATTRIBUTE3, mapv.attribute4 ATTRIBUTE4, mapv.attribute5 ATTRIBUTE5, mapv.context CONTEXT, mapv.parent_rollup_value PARENT_ROLLUP_VALUE, fvs.validation_type VALIDATION_TYPE FROM gl_lookups l, fnd_id_flex_segments ffs1, fnd_id_flex_segments ffs2, fnd_flex_value_sets fvs, gl_segment_map_cons_v mapv WHERE ffs1.application_id = 101 AND ffs1.id_flex_code = 'GL#' AND ffs1.id_flex_num = mapv.to_chart_of_accounts_id AND ffs1.application_column_name = mapv.to_application_column_name AND ffs2.application_id(+) = 101 AND ffs2.id_flex_code(+) = 'GL#' AND ffs2.id_flex_num(+) = mapv.from_chart_of_accounts_id AND ffs2.application_column_name(+) = mapv.from_application_column_name AND l.lookup_type = 'SEGMENT_MAP_TYPE' AND l.lookup_code = mapv.SEGMENT_MAP_TYPE AND fvs.flex_value_set_id = mapv.to_value_set_id

View Text - HTML Formatted

SELECT MAPV.ROW_ID ROW_ID
, MAPV.SEGMENT_MAP_ID SEGMENT_MAP_ID
, MAPV.COA_MAPPING_ID MAPPING_ID
, MAPV.LAST_UPDATE_DATE LAST_UPDATE_DATE
, MAPV.LAST_UPDATED_BY LAST_UPDATED_BY
, MAPV.TO_VALUE_SET_ID TO_VALUE_SET_ID
, MAPV.TO_APPLICATION_COLUMN_NAME TO_APPLICATION_COLUMN_NAME
, FFS1.SEGMENT_NAME TO_SEGMENT_NAME
, FFS1.SEGMENT_NUM TO_SEGMENT_NUM
, MAPV.SEGMENT_MAP_TYPE SEGMENT_MAP_TYPE
, L.MEANING SEGMENT_MAP_TYPE_DISPLAY
, MAPV.CREATION_DATE CREATION_DATE
, MAPV.CREATED_BY CREATED_BY
, MAPV.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, MAPV.FROM_VALUE_SET_ID FROM_VALUE_SET_ID
, MAPV.FROM_APPLICATION_COLUMN_NAME FROM_APPLICATION_COLUMN_NAME
, FFS2.SEGMENT_NAME FROM_SEGMENT_NAME
, FFS2.SEGMENT_NUM FROM_SEGMENT_NUM
, MAPV.SINGLE_VALUE SINGLE_VALUE
, MAPV.ATTRIBUTE1 ATTRIBUTE1
, MAPV.ATTRIBUTE2 ATTRIBUTE2
, MAPV.ATTRIBUTE3 ATTRIBUTE3
, MAPV.ATTRIBUTE4 ATTRIBUTE4
, MAPV.ATTRIBUTE5 ATTRIBUTE5
, MAPV.CONTEXT CONTEXT
, MAPV.PARENT_ROLLUP_VALUE PARENT_ROLLUP_VALUE
, FVS.VALIDATION_TYPE VALIDATION_TYPE
FROM GL_LOOKUPS L
, FND_ID_FLEX_SEGMENTS FFS1
, FND_ID_FLEX_SEGMENTS FFS2
, FND_FLEX_VALUE_SETS FVS
, GL_SEGMENT_MAP_CONS_V MAPV
WHERE FFS1.APPLICATION_ID = 101
AND FFS1.ID_FLEX_CODE = 'GL#'
AND FFS1.ID_FLEX_NUM = MAPV.TO_CHART_OF_ACCOUNTS_ID
AND FFS1.APPLICATION_COLUMN_NAME = MAPV.TO_APPLICATION_COLUMN_NAME
AND FFS2.APPLICATION_ID(+) = 101
AND FFS2.ID_FLEX_CODE(+) = 'GL#'
AND FFS2.ID_FLEX_NUM(+) = MAPV.FROM_CHART_OF_ACCOUNTS_ID
AND FFS2.APPLICATION_COLUMN_NAME(+) = MAPV.FROM_APPLICATION_COLUMN_NAME
AND L.LOOKUP_TYPE = 'SEGMENT_MAP_TYPE'
AND L.LOOKUP_CODE = MAPV.SEGMENT_MAP_TYPE
AND FVS.FLEX_VALUE_SET_ID = MAPV.TO_VALUE_SET_ID