VIEW: APPS.GL_SEGMENT_MAP_CONS_V

Source

View Text - Preformatted

SELECT glsm.rowid ROW_ID, glsm.segment_map_id SEGMENT_MAP_ID, glsm.segment_map_type SEGMENT_MAP_TYPE, glsm.coa_mapping_id COA_MAPPING_ID, glsm.last_update_date LAST_UPDATE_DATE, glsm.last_updated_by LAST_UPDATED_BY, glsm.creation_date CREATION_DATE, glsm.created_by CREATED_BY, glsm.last_update_login LAST_UPDATE_LOGIN, glsm.from_application_column_name FROM_APPLICATION_COLUMN_NAME, glsm.from_value_set_id FROM_VALUE_SET_ID, map.from_coa_id FROM_CHART_OF_ACCOUNTS_ID, glsm.to_application_column_name TO_APPLICATION_COLUMN_NAME, glsm.to_value_set_id TO_VALUE_SET_ID, map.to_coa_id TO_CHART_OF_ACCOUNTS_ID, glsm.single_value SINGLE_VALUE, glsm.attribute1 ATTRIBUTE1, glsm.attribute2 ATTRIBUTE2, glsm.attribute3 ATTRIBUTE3, glsm.attribute4 ATTRIBUTE4, glsm.attribute5 ATTRIBUTE5, glsm.context CONTEXT, glsm.parent_rollup_value PARENT_ROLLUP_VALUE FROM gl_coa_mappings map, gl_cons_segment_map glsm WHERE map.coa_mapping_id = glsm.coa_mapping_id

View Text - HTML Formatted

SELECT GLSM.ROWID ROW_ID
, GLSM.SEGMENT_MAP_ID SEGMENT_MAP_ID
, GLSM.SEGMENT_MAP_TYPE SEGMENT_MAP_TYPE
, GLSM.COA_MAPPING_ID COA_MAPPING_ID
, GLSM.LAST_UPDATE_DATE LAST_UPDATE_DATE
, GLSM.LAST_UPDATED_BY LAST_UPDATED_BY
, GLSM.CREATION_DATE CREATION_DATE
, GLSM.CREATED_BY CREATED_BY
, GLSM.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, GLSM.FROM_APPLICATION_COLUMN_NAME FROM_APPLICATION_COLUMN_NAME
, GLSM.FROM_VALUE_SET_ID FROM_VALUE_SET_ID
, MAP.FROM_COA_ID FROM_CHART_OF_ACCOUNTS_ID
, GLSM.TO_APPLICATION_COLUMN_NAME TO_APPLICATION_COLUMN_NAME
, GLSM.TO_VALUE_SET_ID TO_VALUE_SET_ID
, MAP.TO_COA_ID TO_CHART_OF_ACCOUNTS_ID
, GLSM.SINGLE_VALUE SINGLE_VALUE
, GLSM.ATTRIBUTE1 ATTRIBUTE1
, GLSM.ATTRIBUTE2 ATTRIBUTE2
, GLSM.ATTRIBUTE3 ATTRIBUTE3
, GLSM.ATTRIBUTE4 ATTRIBUTE4
, GLSM.ATTRIBUTE5 ATTRIBUTE5
, GLSM.CONTEXT CONTEXT
, GLSM.PARENT_ROLLUP_VALUE PARENT_ROLLUP_VALUE
FROM GL_COA_MAPPINGS MAP
, GL_CONS_SEGMENT_MAP GLSM
WHERE MAP.COA_MAPPING_ID = GLSM.COA_MAPPING_ID