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_FILES

Object Details

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

The MSC_FILES table is used to store the list of files which are used
in the generation of an MPS, MRP or DRP plan. Data in this table is
updated each time a plan is run.
The FILE_TYPE column contains predefined values which are used during
a planning run. The FILE_NAME column contains the name of the data
file which was generated during the last plan run.
The ROW_COUNT and COPY_FLAG columns are used in the planning engine
and the Copy Plan program.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
MSC_FILES_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PLAN_ID FILE_TYPE

Columns

Name	Datatype	Length	Mandatory	Comments
PLAN_ID	NUMBER		Yes	Plan identifier
FILE_TYPE	NUMBER		Yes	File type
FILE_NAME	VARCHAR2	(255)	Yes	Name of file
FILE_SIZE	NUMBER			File size
FILE_CREATION_DATE	DATE			File creation date
ROW_COUNT	NUMBER			Row count
COPY_FLAG	NUMBER			Copy flag(used in Copy Plan program)
NETCHANGE	NUMBER			Net Change
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
LOAD_ID	NUMBER			Load identfier
ATTACHMENT_ID	NUMBER			Attachment identifier
REQUEST_ID	NUMBER			Request identifier
HEADER_ID	NUMBER			Header identifier

Query Text

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


SELECT PLAN_ID
,      FILE_TYPE
,      FILE_NAME
,      FILE_SIZE
,      FILE_CREATION_DATE
,      ROW_COUNT
,      COPY_FLAG
,      NETCHANGE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      LOAD_ID
,      ATTACHMENT_ID
,      REQUEST_ID
,      HEADER_ID
FROM MSC.MSC_FILES;

Dependencies

[top of page]

MSC.MSC_FILES does not reference any database object

MSC.MSC_FILES is referenced by following:

APPS: MSC_FILES