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: TableSQLGL.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: TablespaceAPPS_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:

SchemaGL
ViewGL_MGT_SEG_UPGRADE_H#