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: MRP.MRP_SNAPSHOT_TASKS

Object Details

Object Name:	MRP_SNAPSHOT_TASKS
Object Type:	TABLE
Owner:	MRP
FND Design Data:	MRP.MRP_SNAPSHOT_TASKS
Subobject Name:
Status:	VALID

MRP_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 MRP_SNAPSHOT_TASKS for the next task that
has not been started. Tasks can be dependent upon other tasks having
being 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.
.
MRP_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
MRP_SNAPSHOT_TASKS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	COMPILE_DESIGNATOR ORGANIZATION_ID TASK

Columns

Name	Datatype	Length	Mandatory	Comments
TASK	NUMBER		Yes	Task type
ORGANIZATION_ID	NUMBER		Yes	Organization identifier
COMPILE_DESIGNATOR	VARCHAR2	(10)	Yes	MPS, MRP or DRP plan identifier
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
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 MRP_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
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 TASK
,      ORGANIZATION_ID
,      COMPILE_DESIGNATOR
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REQUIRES_LOCK
,      REQUIRES_ITEMS
,      DEPENDENCY_AGAINST
,      START_DATE
,      COMPLETION_DATE
,      DEPENDENT_TASK
,      DEPENDENT_TASK2
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
FROM MRP.MRP_SNAPSHOT_TASKS;

Dependencies

[top of page]

MRP.MRP_SNAPSHOT_TASKS does not reference any database object

MRP.MRP_SNAPSHOT_TASKS is referenced by following:

MRP: MRP_SNAPSHOT_TASKS#