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: BSC.BSC_UPGRADE_TASK

Object Details

Object Name:	BSC_UPGRADE_TASK
Object Type:	TABLE
Owner:	BSC
FND Design Data:	BSC.BSC_UPGRADE_TASK
Subobject Name:
Status:	VALID

BSC_UPGRADE_TASK stores information about all the task to perform during the migration process.

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Mandatory	Comments
TASK_ID	NUMBER	(3)	Yes	Task identifier
OBJ_NAME	VARCHAR2	(30)	Yes	Database object name
ACTION	VARCHAR2	(30)	Yes	Create,drop,delete,insert,update
STATUS	VARCHAR2	(1)	Yes	Task Status. (P)ending,(C)omplete, (F)ail
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 TASK_ID
,      OBJ_NAME
,      ACTION
,      STATUS
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
FROM BSC.BSC_UPGRADE_TASK;

Dependencies

[top of page]

BSC.BSC_UPGRADE_TASK does not reference any database object

BSC.BSC_UPGRADE_TASK is referenced by following:

APPS: BSC_UPGRADE_TASK