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: XLA.XLA_UPGRADE_REQUESTS

Object Details

Object Name:	XLA_UPGRADE_REQUESTS
Object Type:	TABLE
Owner:	XLA
FND Design Data:	XLA.XLA_UPGRADE_REQUESTS
Subobject Name:
Status:	VALID

For SLA upgrade: stores the parameters for each post upgrade request.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Mandatory	Comments
APPLICATION_ID	NUMBER	(15)	Yes	The application for which the post upgrade request is submitted.
REQUEST_CONTROL_ID	NUMBER	(15)	Yes	Request id for the request that upgrades the data.
PARENT_REQUEST_CONTROL_ID	NUMBER	(15)		Request id of the SLA post upgrade program submitted by the user.
PHASE_NUM	NUMBER	(15)	Yes	Phase of the upgrade program.
PROGRAM_CODE	VARCHAR2	(80)		Program code of the upgrade program.
DESCRIPTION	VARCHAR2	(2000)		Description of the upgrade program.
STATUS_CODE	VARCHAR2	(30)	Yes	Status of the upgrade program.
LEDGER_ID	NUMBER	(15)	Yes	Ledger to be upgraded.
PERIOD_NAME	VARCHAR2	(15)		Name of the period to be upgraded.
WORKER_ID	NUMBER	(15)		Worker id for the upgrade program.
WORKERS_NUM	NUMBER	(15)		Number of workers.
TABLE_NAME	VARCHAR2	(30)		Name of the table updated by the upgrade program.
SCRIPT_NAME	VARCHAR2	(30)		Name of the script of the upgrade program.
BATCH_SIZE	NUMBER	(15)		Size of the batch for the upgrade program.
BATCH_ID	NUMBER	(15)		Batch id for the upgrade program.
ORDER_NUM	NUMBER	(15)	Yes	Order of the upgrade program.
START_DATE	DATE			Start date of the upgrade request.
END_DATE	DATE			End date of the upgrade request.
CREATION_DATE	DATE		Yes	Standard who column.
CREATED_BY	NUMBER	(15)	Yes	Standard who column.
LAST_UPDATE_DATE	DATE		Yes	Standard who column.
LAST_UPDATED_BY	NUMBER	(15)	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 APPLICATION_ID
,      REQUEST_CONTROL_ID
,      PARENT_REQUEST_CONTROL_ID
,      PHASE_NUM
,      PROGRAM_CODE
,      DESCRIPTION
,      STATUS_CODE
,      LEDGER_ID
,      PERIOD_NAME
,      WORKER_ID
,      WORKERS_NUM
,      TABLE_NAME
,      SCRIPT_NAME
,      BATCH_SIZE
,      BATCH_ID
,      ORDER_NUM
,      START_DATE
,      END_DATE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
FROM XLA.XLA_UPGRADE_REQUESTS;

Dependencies

[top of page]

XLA.XLA_UPGRADE_REQUESTS does not reference any database object

XLA.XLA_UPGRADE_REQUESTS is referenced by following:

XLA: XLA_UPGRADE_REQUESTS#