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_CODE_COMBINATIONS

Object Details

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

GL_CODE_COMBINATIONS stores valid account combinations for each Accounting Flexfield structure within your Oracle General Ledger application. Associated with each account are certain codes and flags, including whether the account is enabled, whether detail posting or detail budgeting is allowed, and others.
Segment values are stored in the SEGMENT columns. Note that each Accounting Flexfield structure may use different SEGMENT columns within the table to store the flexfield value combination. Moreover, the SEGMENT columns that are used are not guaranteed to be in any order.
The Oracle Application Object Library table FND_ID_FLEX_SEGMENTS stores information about which column in this table is used for each segment of each Accounting Flexfield structure. Summary accounts have SUMMARY_FLAG = 'Y' and TEMPLATE_ID not NULL. Detail accounts have SUMMARY_FLAG = 'N' and TEMPLATE_ID NULL.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
GL_CODE_COMBINATIONS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	CODE_COMBINATION_ID
GL_CODE_COMBINATIONS_N31	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TEMPLATE_ID

Columns

Name	Datatype	Length	Mandatory	Comments
CODE_COMBINATION_ID	NUMBER	(15)	Yes	Key flexfield combination defining column
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER		Yes	Standard Who column
CHART_OF_ACCOUNTS_ID	NUMBER	(15)	Yes	Key flexfield structure defining column
DETAIL_POSTING_ALLOWED_FLAG	VARCHAR2	(1)	Yes	Detail posting flag
DETAIL_BUDGETING_ALLOWED_FLAG	VARCHAR2	(1)	Yes	Detail budgeting flag
ACCOUNT_TYPE	VARCHAR2	(1)	Yes	Key flexfield combination type (Asset, Liability, etc)
ENABLED_FLAG	VARCHAR2	(1)	Yes	Key flexfield enabled flag
SUMMARY_FLAG	VARCHAR2	(1)	Yes	Summary account flag
SEGMENT1	VARCHAR2	(25)		Key flexfield segment
SEGMENT2	VARCHAR2	(25)		Key flexfield segment
SEGMENT3	VARCHAR2	(25)		Key flexfield segment
SEGMENT4	VARCHAR2	(25)		Key flexfield segment
SEGMENT5	VARCHAR2	(25)		Key flexfield segment
SEGMENT6	VARCHAR2	(25)		Key flexfield segment
SEGMENT7	VARCHAR2	(25)		Key flexfield segment
SEGMENT8	VARCHAR2	(25)		Key flexfield segment
SEGMENT9	VARCHAR2	(25)		Key flexfield segment
SEGMENT10	VARCHAR2	(25)		Key flexfield segment
SEGMENT11	VARCHAR2	(25)		Key flexfield segment
SEGMENT12	VARCHAR2	(25)		Key flexfield segment
SEGMENT13	VARCHAR2	(25)		Key flexfield segment
SEGMENT14	VARCHAR2	(25)		Key flexfield segment
SEGMENT15	VARCHAR2	(25)		Key flexfield segment
SEGMENT16	VARCHAR2	(25)		Key flexfield segment
SEGMENT17	VARCHAR2	(25)		Key flexfield segment
SEGMENT18	VARCHAR2	(25)		Key flexfield segment
SEGMENT19	VARCHAR2	(25)		Key flexfield segment
SEGMENT20	VARCHAR2	(25)		Key flexfield segment
SEGMENT21	VARCHAR2	(25)		Key flexfield segment
SEGMENT22	VARCHAR2	(25)		Key flexfield segment
SEGMENT23	VARCHAR2	(25)		Key flexfield segment
SEGMENT24	VARCHAR2	(25)		Key flexfield segment
SEGMENT25	VARCHAR2	(25)		Key flexfield segment
SEGMENT26	VARCHAR2	(25)		Key flexfield segment
SEGMENT27	VARCHAR2	(25)		Key flexfield segment
SEGMENT28	VARCHAR2	(25)		Key flexfield segment
SEGMENT29	VARCHAR2	(25)		Key flexfield segment
SEGMENT30	VARCHAR2	(25)		Key flexfield segment
DESCRIPTION	VARCHAR2	(240)		Key flexfield description
TEMPLATE_ID	NUMBER	(15)		Summary template defining column
ALLOCATION_CREATE_FLAG	VARCHAR2	(1)		Not currently used
START_DATE_ACTIVE	DATE			Date before which key flexfield combination is invalid
END_DATE_ACTIVE	DATE			Date after which key flexfield combination is invalid
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
ATTRIBUTE6	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE7	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE8	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE9	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE10	VARCHAR2	(150)		Descriptive flexfield segment
CONTEXT	VARCHAR2	(150)		Descriptive flex context column
SEGMENT_ATTRIBUTE1	VARCHAR2	(60)		Reporting attribute key flexfield segment
SEGMENT_ATTRIBUTE2	VARCHAR2	(60)		Reporting attribute key flexfield segment
SEGMENT_ATTRIBUTE3	VARCHAR2	(60)		Reporting attribute key flexfield segment
SEGMENT_ATTRIBUTE4	VARCHAR2	(60)		Reporting attribute key flexfield segment
SEGMENT_ATTRIBUTE5	VARCHAR2	(60)		Reporting attribute key flexfield segment
SEGMENT_ATTRIBUTE6	VARCHAR2	(60)		Reporting attribute key flexfield segment
SEGMENT_ATTRIBUTE7	VARCHAR2	(60)		Reporting attribute key flexfield segment
SEGMENT_ATTRIBUTE8	VARCHAR2	(60)		Reporting attribute key flexfield segment
SEGMENT_ATTRIBUTE9	VARCHAR2	(60)		Reporting attribute key flexfield segment
SEGMENT_ATTRIBUTE10	VARCHAR2	(60)		Reporting attribute key flexfield segment
SEGMENT_ATTRIBUTE11	VARCHAR2	(60)		Reporting attribute key flexfield segment
SEGMENT_ATTRIBUTE12	VARCHAR2	(60)		Reporting attribute key flexfield segment
SEGMENT_ATTRIBUTE13	VARCHAR2	(60)		Reporting attribute key flexfield segment
SEGMENT_ATTRIBUTE14	VARCHAR2	(60)		Reporting attribute key flexfield segment
SEGMENT_ATTRIBUTE15	VARCHAR2	(60)		Reporting attribute key flexfield segment
SEGMENT_ATTRIBUTE16	VARCHAR2	(60)		Reporting attribute key flexfield segment
SEGMENT_ATTRIBUTE17	VARCHAR2	(60)		Reporting attribute key flexfield segment
SEGMENT_ATTRIBUTE18	VARCHAR2	(60)		Reporting attribute key flexfield segment
SEGMENT_ATTRIBUTE19	VARCHAR2	(60)		Reporting attribute key flexfield segment
SEGMENT_ATTRIBUTE20	VARCHAR2	(60)		Reporting attribute key flexfield segment
SEGMENT_ATTRIBUTE21	VARCHAR2	(60)		Reporting attribute key flexfield segment
SEGMENT_ATTRIBUTE22	VARCHAR2	(60)		Reporting attribute key flexfield segment
SEGMENT_ATTRIBUTE23	VARCHAR2	(60)		Reporting attribute key flexfield segment
SEGMENT_ATTRIBUTE24	VARCHAR2	(60)		Reporting attribute key flexfield segment
SEGMENT_ATTRIBUTE25	VARCHAR2	(60)		Reporting attribute key flexfield segment
SEGMENT_ATTRIBUTE26	VARCHAR2	(60)		Reporting attribute key flexfield segment
SEGMENT_ATTRIBUTE27	VARCHAR2	(60)		Reporting attribute key flexfield segment
SEGMENT_ATTRIBUTE28	VARCHAR2	(60)		Reporting attribute key flexfield segment
SEGMENT_ATTRIBUTE29	VARCHAR2	(60)		Reporting attribute key flexfield segment
SEGMENT_ATTRIBUTE30	VARCHAR2	(60)		Reporting attribute key flexfield segment
SEGMENT_ATTRIBUTE31	VARCHAR2	(60)		Reporting attribute key flexfield segment
SEGMENT_ATTRIBUTE32	VARCHAR2	(60)		Reporting attribute key flexfield segment
SEGMENT_ATTRIBUTE33	VARCHAR2	(60)		Reporting attribute key flexfield segment
SEGMENT_ATTRIBUTE34	VARCHAR2	(60)		Reporting attribute key flexfield segment
SEGMENT_ATTRIBUTE35	VARCHAR2	(60)		Reporting attribute key flexfield segment
SEGMENT_ATTRIBUTE36	VARCHAR2	(60)		Reporting attribute key flexfield segment
SEGMENT_ATTRIBUTE37	VARCHAR2	(60)		Reporting attribute key flexfield segment
SEGMENT_ATTRIBUTE38	VARCHAR2	(60)		Reporting attribute key flexfield segment
SEGMENT_ATTRIBUTE39	VARCHAR2	(60)		Reporting attribute key flexfield segment
SEGMENT_ATTRIBUTE40	VARCHAR2	(60)		Reporting attribute key flexfield segment
SEGMENT_ATTRIBUTE41	VARCHAR2	(60)		Reporting attribute key flexfield segment
SEGMENT_ATTRIBUTE42	VARCHAR2	(60)		Reporting attribute key flexfield segment
REFERENCE1	VARCHAR2	(1)		Reserved for localization use
REFERENCE2	VARCHAR2	(1)		Reserved for localization use
REFERENCE3	VARCHAR2	(25)		Reserved for localization use
REFERENCE4	VARCHAR2	(1)		Reserved for localization use
REFERENCE5	VARCHAR2	(1)		Reserved for localization use
JGZZ_RECON_FLAG	VARCHAR2	(1)		Global reconciliation descriptive flexfield segment
JGZZ_RECON_CONTEXT	VARCHAR2	(30)		Global reconciliation descriptive flexfield context column
PRESERVE_FLAG	VARCHAR2	(1)		Preserve segment value attributes flag
REFRESH_FLAG	VARCHAR2	(1)		Refresh segment value attributes flag
IGI_BALANCED_BUDGET_FLAG	VARCHAR2	(1)		Balance budget enforcement flag
COMPANY_COST_CENTER_ORG_ID	NUMBER	(15)		Organization defining column for the organization associated with the accounts' company/cost center combination.
REVALUATION_ID	NUMBER	(15)		Revaluation defining column
LEDGER_SEGMENT	VARCHAR2	(20)		Dummy column for ledger defining segment.
LEDGER_TYPE_CODE	VARCHAR2	(1)		Dummy column for ledger type code.
ALTERNATE_CODE_COMBINATION_ID	NUMBER	(15)		Alternate key flexfield combination defining column

Query Text

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


SELECT CODE_COMBINATION_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CHART_OF_ACCOUNTS_ID
,      DETAIL_POSTING_ALLOWED_FLAG
,      DETAIL_BUDGETING_ALLOWED_FLAG
,      ACCOUNT_TYPE
,      ENABLED_FLAG
,      SUMMARY_FLAG
,      SEGMENT1
,      SEGMENT2
,      SEGMENT3
,      SEGMENT4
,      SEGMENT5
,      SEGMENT6
,      SEGMENT7
,      SEGMENT8
,      SEGMENT9
,      SEGMENT10
,      SEGMENT11
,      SEGMENT12
,      SEGMENT13
,      SEGMENT14
,      SEGMENT15
,      SEGMENT16
,      SEGMENT17
,      SEGMENT18
,      SEGMENT19
,      SEGMENT20
,      SEGMENT21
,      SEGMENT22
,      SEGMENT23
,      SEGMENT24
,      SEGMENT25
,      SEGMENT26
,      SEGMENT27
,      SEGMENT28
,      SEGMENT29
,      SEGMENT30
,      DESCRIPTION
,      TEMPLATE_ID
,      ALLOCATION_CREATE_FLAG
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      CONTEXT
,      SEGMENT_ATTRIBUTE1
,      SEGMENT_ATTRIBUTE2
,      SEGMENT_ATTRIBUTE3
,      SEGMENT_ATTRIBUTE4
,      SEGMENT_ATTRIBUTE5
,      SEGMENT_ATTRIBUTE6
,      SEGMENT_ATTRIBUTE7
,      SEGMENT_ATTRIBUTE8
,      SEGMENT_ATTRIBUTE9
,      SEGMENT_ATTRIBUTE10
,      SEGMENT_ATTRIBUTE11
,      SEGMENT_ATTRIBUTE12
,      SEGMENT_ATTRIBUTE13
,      SEGMENT_ATTRIBUTE14
,      SEGMENT_ATTRIBUTE15
,      SEGMENT_ATTRIBUTE16
,      SEGMENT_ATTRIBUTE17
,      SEGMENT_ATTRIBUTE18
,      SEGMENT_ATTRIBUTE19
,      SEGMENT_ATTRIBUTE20
,      SEGMENT_ATTRIBUTE21
,      SEGMENT_ATTRIBUTE22
,      SEGMENT_ATTRIBUTE23
,      SEGMENT_ATTRIBUTE24
,      SEGMENT_ATTRIBUTE25
,      SEGMENT_ATTRIBUTE26
,      SEGMENT_ATTRIBUTE27
,      SEGMENT_ATTRIBUTE28
,      SEGMENT_ATTRIBUTE29
,      SEGMENT_ATTRIBUTE30
,      SEGMENT_ATTRIBUTE31
,      SEGMENT_ATTRIBUTE32
,      SEGMENT_ATTRIBUTE33
,      SEGMENT_ATTRIBUTE34
,      SEGMENT_ATTRIBUTE35
,      SEGMENT_ATTRIBUTE36
,      SEGMENT_ATTRIBUTE37
,      SEGMENT_ATTRIBUTE38
,      SEGMENT_ATTRIBUTE39
,      SEGMENT_ATTRIBUTE40
,      SEGMENT_ATTRIBUTE41
,      SEGMENT_ATTRIBUTE42
,      REFERENCE1
,      REFERENCE2
,      REFERENCE3
,      REFERENCE4
,      REFERENCE5
,      JGZZ_RECON_FLAG
,      JGZZ_RECON_CONTEXT
,      PRESERVE_FLAG
,      REFRESH_FLAG
,      IGI_BALANCED_BUDGET_FLAG
,      COMPANY_COST_CENTER_ORG_ID
,      REVALUATION_ID
,      LEDGER_SEGMENT
,      LEDGER_TYPE_CODE
,      ALTERNATE_CODE_COMBINATION_ID
FROM GL.GL_CODE_COMBINATIONS;

Dependencies

[top of page]

GL.GL_CODE_COMBINATIONS does not reference any database object

GL.GL_CODE_COMBINATIONS is referenced by following:

GL: GL_CODE_COMBINATIONS#