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: MSC.MSC_SNAPSHOT_TASKS

Object Details

Object Name:	MSC_SNAPSHOT_TASKS
Object Type:	TABLE
Owner:	MSC
FND Design Data:	MSC.MSC_SNAPSHOT_TASKS
Subobject Name:
Status:	VALID

MSC_SNAPSHOT_TASKS stores a queue of tasks to be performed by the
Snapshot. Each entry represents a task to be performed.
The Snapshot launches several workers to perform the tasks in
parallel. Each worker scans MSC_SNAPSHOT_TASKS for the next task that
has not been started. Tasks can be dependent upon other tasks having
been completed. DEPENDENT_TASK and DEPENDENT_TASK2 store the tasks
that must be completed before a given task can begin. REQUIRES_LOCK
indicates whether or not the snapshot must have acquired locks before
this task can be started. DEPENDENCY_AGAINST is set to "Yes" if this
task has other tasks which are dependent upon it. Tasks which have
DEPENDENY_AGAINST set to "Yes" will have a higher priority than other
tasks.
START_DATE and COMPLETION_DATE store the date and time that each task
was started and completed. They also serve to indicate the status of
each tasks. A null value for START_DATE and COMPLETION_DATE indicates
that a task has not yet been started. A value in START_DATE and a
null value in COMPLETION_DATE indicates that a task is currently in
process. Values in START_DATE and COMPLETION_DATE indicates that the
task has completed.
MSC_SNAPSHOT_TASKS is populated by the Snapshot. START_DATE and
COMPLETION_DATE are updated by the Snapshot Workers and by the
Snapshot.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
MSC_SNAPSHOT_TASKS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	PLAN_ID TASK

Columns

Name	Datatype	Mandatory	Comments
PLAN_ID	NUMBER	Yes	Plan identifier
TASK	NUMBER	Yes	Task type
REQUIRES_LOCK	NUMBER	Yes	Flag to indicate if the task requires a snapshot lock
REQUIRES_ITEMS	NUMBER	Yes	Flag to indicate that this task requires that MSC_SYSTEM_ITEMS is complete
DEPENDENCY_AGAINST	NUMBER	Yes	Flag to indicate if this task has other tasks that are dependent on it
START_DATE	DATE		Date the task was started
COMPLETION_DATE	DATE		Date task was completed
DEPENDENT_TASK	NUMBER		Task which must be executed before this task
DEPENDENT_TASK2	NUMBER		Task which must be executed before this task
LAST_UPDATE_DATE	DATE	Yes	Standard Who Column
LAST_UPDATED_BY	NUMBER	Yes	Standard Who Column
CREATION_DATE	DATE	Yes	Standard Who Column
CREATED_BY	NUMBER	Yes	Standard Who Column
LAST_UPDATE_LOGIN	NUMBER		Standard Who Column
REQUEST_ID	NUMBER		Concurrent Who column
PROGRAM_APPLICATION_ID	NUMBER		Concurrent Who column
PROGRAM_ID	NUMBER		Concurrent Who column
PROGRAM_UPDATE_DATE	DATE		Concurrent Who column

Query Text

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


SELECT PLAN_ID
,      TASK
,      REQUIRES_LOCK
,      REQUIRES_ITEMS
,      DEPENDENCY_AGAINST
,      START_DATE
,      COMPLETION_DATE
,      DEPENDENT_TASK
,      DEPENDENT_TASK2
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
FROM MSC.MSC_SNAPSHOT_TASKS;

Dependencies

[top of page]

MSC.MSC_SNAPSHOT_TASKS does not reference any database object

MSC.MSC_SNAPSHOT_TASKS is referenced by following:

APPS: MSC_SNAPSHOT_TASKS