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_MGT_SEG_UPGRADE_H

Object Details

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

GL_MGT_SEG_UPGRADE_H stores the status of the management segment upgrade for each chart of accounts. Each row in this table includes the chart of accounts, the name of the segment that will become or has become the management segment, the upgrade completion status, the maximum journal batch identifying number of journal batches processed by the upgrade, and the maximum journal identifying number in the system at the time the upgrade was run. The assign complete flag identifies the completion status of the management segment upgrade for a chart of accounts.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Mandatory	Comments
CHART_OF_ACCOUNTS_ID	NUMBER		Yes	Key flexfield structure defining column
MGT_SEG_COLUMN_NAME	VARCHAR2	(30)	Yes	Management segment column name
ASSIGN_COMPLETE_FLAG	VARCHAR2	(1)	Yes	Assignment complete flag
MAX_PROCESSED_BATCH_ID	NUMBER			Maximum processed batch defining column
MAX_BATCH_ID	NUMBER			Maximum journal entry batch defining column
CREATED_BY	NUMBER	(15)	Yes	Standard Who column
CREATION_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who column
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who column

Query Text

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


SELECT CHART_OF_ACCOUNTS_ID
,      MGT_SEG_COLUMN_NAME
,      ASSIGN_COMPLETE_FLAG
,      MAX_PROCESSED_BATCH_ID
,      MAX_BATCH_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM GL.GL_MGT_SEG_UPGRADE_H;

Dependencies

[top of page]

GL.GL_MGT_SEG_UPGRADE_H does not reference any database object

GL.GL_MGT_SEG_UPGRADE_H is referenced by following:

APPS: GL_MGT_SEG_UPGRADE_H