DBA Data[Home] [Help] [Dependency Information]

TABLE: MST.MST_FILES

Object Details
Object Name: MST_FILES
Object Type: TABLE
Owner: MST
Subobject Name:
Status: VALID


This table is used to store the list of files which are used in th generation of an MST plan.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
PLAN_ID NUMBER
Yes FK to MST_PLANS
TASK_ID NUMBER
Yes Seeded values
FILE_NAME VARCHAR2 (255)
Complete file name and path. Prefix and suffix is added to seeded file name value which is different for different subtask. Full patch is determined by APPLCSF (or MRP_TOP if APPLCSF is not defined)
LOAD_ID NUMBER

Request id of the load concurrent program
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).
REMOVE_FLAG NUMBER

Whether snapshot remove previous snapshot file. Default is 1(yes).
NETCHANGE NUMBER
Yes 1 net change, 2 full
CREATED_BY NUMBER

Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE

Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER

Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE

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
,      FILE_NAME
,      LOAD_ID
,      REQUEST_ID
,      REMOVE_FLAG
,      NETCHANGE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM MST.MST_FILES;

Dependencies

[top of page]

MST.MST_FILES does not reference any database object

MST.MST_FILES is referenced by following:

SchemaAPPS
SynonymMST_FILES