eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

TABLE: GL.GL_CONS_SEGMENT_MAP

Object Details

Object Name:	GL_CONS_SEGMENT_MAP
Object Type:	TABLE
Owner:	GL
FND Design Data:	SQLGL.GL_CONS_SEGMENT_MAP
Subobject Name:
Status:	VALID

GL_CONS_SEGMENT_MAP stores the rules you define in the Segment Rules window of the Consolidation Mappings form. SEGMENT_MAP_TYPE is 'C' for copy value rule, 'S' for single value rule, and 'R' for the Detail Ranges rollup rule, 'U' for the Parent Ranges rollup rule, 'P' for the Detail Parent rollup rule, and 'V' for the Summary Parent rollup rule. SINGLE_VALUE is the parent ledger detail segment value you specify when you use the single value rule or the rollup rules. PARENT_ROLLUP_VALUE is the subsidiary ledger parent segment value that you specify when you use the Detail or Summary Parent rollup rules.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
GL_CONS_SEGMENT_MAP_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	SEGMENT_MAP_ID
GL_CONS_SEGMENT_MAP_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	COA_MAPPING_ID TO_APPLICATION_COLUMN_NAME

Columns

Name	Datatype	Length	Mandatory	Comments
SEGMENT_MAP_ID	NUMBER		Yes	Consolidation segment map defining column
CONSOLIDATION_ID_11I	NUMBER			No Longer Used in R12
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER		Yes	Standard Who column
TO_VALUE_SET_ID	NUMBER		Yes	Parent segment value set defining column
TO_APPLICATION_COLUMN_NAME	VARCHAR2	(30)	Yes	Parent segment column name
SEGMENT_MAP_TYPE	VARCHAR2	(1)	Yes	Segment map type lookup
CREATION_DATE	DATE			Standard Who column
CREATED_BY	NUMBER	(15)		Standard Who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who column
FROM_VALUE_SET_ID	NUMBER			Subsidiary segment value set defining column
FROM_APPLICATION_COLUMN_NAME	VARCHAR2	(30)		Subsidiary segment column name
PARENT_ROLLUP_VALUE	VARCHAR2	(25)		Subsidiary ledger parent rollup value
SINGLE_VALUE	VARCHAR2	(25)		Parent segment value for single value or rollup ranges rule
ATTRIBUTE1	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE2	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE3	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE4	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE5	VARCHAR2	(150)		Descriptive flexfield segment
CONTEXT	VARCHAR2	(150)		Description flexfield context
COA_MAPPING_ID	NUMBER	(15)	Yes	Chart of accounts mapping defining column

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT SEGMENT_MAP_ID
,      CONSOLIDATION_ID_11I
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      TO_VALUE_SET_ID
,      TO_APPLICATION_COLUMN_NAME
,      SEGMENT_MAP_TYPE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      FROM_VALUE_SET_ID
,      FROM_APPLICATION_COLUMN_NAME
,      PARENT_ROLLUP_VALUE
,      SINGLE_VALUE
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      CONTEXT
,      COA_MAPPING_ID
FROM GL.GL_CONS_SEGMENT_MAP;

Dependencies

[top of page]

GL.GL_CONS_SEGMENT_MAP does not reference any database object

GL.GL_CONS_SEGMENT_MAP is referenced by following:

APPS: GL_CONS_SEGMENT_MAP