View: GL_SEGMENT_MAP_CONS_V

Product:	GL - General Ledger
Description:
Implementation/DBA Data:	APPS.GL_SEGMENT_MAP_CONS_V

View Text

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

Columns