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: ICX.ICX_CAT_SCHEMA_VERSIONS

Object Details

Object Name:	ICX_CAT_SCHEMA_VERSIONS
Object Type:	TABLE
Owner:	ICX
FND Design Data:	ICX.ICX_CAT_SCHEMA_VERSIONS
Subobject Name:
Status:	VALID

Version tracking table for internal use. Should be maintained so that you can determine the version of the schema changes. Initially, the columns DESCRIPTOR_SET_ID and VERSION are set to 0, 1 & 1, 1 respectively.
The DESCRIPTOR_SET_ID value corresponds to
- 0 for changes in root descriptors
- 1 for changes in local descriptors
The version corresponding to the DESCRIPTOR_SET_ID is incremented for each the following scenarios
1. Any Changes in base descriptor row
2. Any Changes in local descriptor row
3. If the category is deleted

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Mandatory	Comments
DESCRIPTOR_SET_ID	NUMBER		Stores Descriptor Set Id. Possible values are 0 and 1.
VERSION	NUMBER		Version. Set to 1 initially, incremented every time row is updated.
LAST_UPDATE_LOGIN	NUMBER		Standard Who column: identifies sign-on audit information of the user who last updated this record. (References FND_LOGINS.login_id.)
LAST_UPDATED_BY	NUMBER	Yes	Standard Who column: the user who last updated this record. (References FND_USERS.user_id.)
LAST_UPDATE_DATE	DATE	Yes	Standard Who column: date when this record was last updated
CREATED_BY	NUMBER	Yes	Standard Who column: the user who created this record. (References FND_USERS.user_id.)
CREATION_DATE	DATE	Yes	Standard Who column: date when this record was created
REQUEST_ID	NUMBER		Standard Concurrent Request Column: Identifies the concurrent request instance that spawned the concurrent program
PROGRAM_APPLICATION_ID	NUMBER		Standard Concurrent Request Column: Identifies the Oracle Application that spawned the concurrent program
PROGRAM_ID	NUMBER		Standard Concurrent Request Column: Identifies the concurrent program
PROGRAM_LOGIN_ID	NUMBER		Standard Concurrent Request Column: Identifies the Oracle Applications Concurrent Program Login ID

Query Text

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


SELECT DESCRIPTOR_SET_ID
,      VERSION
,      LAST_UPDATE_LOGIN
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      CREATED_BY
,      CREATION_DATE
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_LOGIN_ID
FROM ICX.ICX_CAT_SCHEMA_VERSIONS;

Dependencies

[top of page]

ICX.ICX_CAT_SCHEMA_VERSIONS does not reference any database object

ICX.ICX_CAT_SCHEMA_VERSIONS is referenced by following:

APPS: ICX_CAT_SCHEMA_VERSIONS