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_DATES

Object Details

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

For SLA upgrade: contains start and enddate for a ledger.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
XLA_UPGRADE_DATES_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	LEDGER_ID START_DATE END_DATE

Columns

Name	Datatype	Length	Mandatory	Comments
LEDGER_ID	NUMBER	(15)	Yes	Ledger to be upgraded based on its periods.
START_DATE	DATE		Yes	Start date for the first period to be upgraded.
END_DATE	DATE		Yes	End date for the last period to be upgraded.

Query Text

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


SELECT LEDGER_ID
,      START_DATE
,      END_DATE
FROM XLA.XLA_UPGRADE_DATES;

Dependencies

[top of page]

XLA.XLA_UPGRADE_DATES does not reference any database object

XLA.XLA_UPGRADE_DATES is referenced by following:

APPS: XLA_UPGRADE_DATES