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: MST.MST_SNAPSHOT_TASKS

Object Details

Object Name:	MST_SNAPSHOT_TASKS
Object Type:	TABLE
Owner:	MST
Subobject Name:
Status:	VALID

It stores a queue of tasks performed by snapshot

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Mandatory	Comments
PLAN_ID	NUMBER		Yes	This column stores the plan id
TASK_ID	NUMBER		Yes	This column stores the task id to be performed for a plan
DEPENDENCY_AGAINST	NUMBER			This column is set to Yes, if this task has other tasks which are dependent upon it. Tasks which have this column set to Yes will have higher priority to be executed than other tasks
DELETE_START_DATE	DATE			Time at which delete started.
DELETE_COMPLETION_DATE	DATE			Time at which delete ended.
TASK_START_DATE	DATE			Time at which task started.
TASK_COMPLETION_DATE	DATE			Time at which task ended.
DEPENDENT_TASK1	NUMBER			Dependent task number.
DEPENDENT_TASK2	NUMBER			Dependent task number.
REQUEST_ID	NUMBER			Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
LOAD_REQUIRED	NUMBER		Yes	Whether load is required for this task or not. 1 yes, 2 no
DELETE_REQUIRED	NUMBER		Yes	Whether delete is required for this task or not. 1 yes, 2 no
DELETE_TABLE_NAME	VARCHAR2	(30)		Populated if delete is required. Table from which record is to be deleted
FILE_CODE	VARCHAR2	(50)	Yes	Code which is used for file generation.
NETCHANGE_FLAG	NUMBER		Yes	To be created in net change. 1 netchange, 2 full
REUSE_FLAG	NUMBER			Whether file can be reused for other plan or not.1 yes, 2 no
CREATED_BY	NUMBER		Yes	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE	DATE		Yes	Standard who column - date when this row was created.
LAST_UPDATED_BY	NUMBER		Yes	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE	DATE		Yes	Standard Who column - date when a user last updated this row.
LAST_UPDATE_LOGIN	NUMBER			Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).

Query Text

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


SELECT PLAN_ID
,      TASK_ID
,      DEPENDENCY_AGAINST
,      DELETE_START_DATE
,      DELETE_COMPLETION_DATE
,      TASK_START_DATE
,      TASK_COMPLETION_DATE
,      DEPENDENT_TASK1
,      DEPENDENT_TASK2
,      REQUEST_ID
,      LOAD_REQUIRED
,      DELETE_REQUIRED
,      DELETE_TABLE_NAME
,      FILE_CODE
,      NETCHANGE_FLAG
,      REUSE_FLAG
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM MST.MST_SNAPSHOT_TASKS;

Dependencies

[top of page]

MST.MST_SNAPSHOT_TASKS does not reference any database object

MST.MST_SNAPSHOT_TASKS is referenced by following:

APPS: MST_SNAPSHOT_TASKS