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

TABLE: MSC.MSC_FILES

Object Details
Object Name: MSC_FILES
Object Type: TABLE
Owner: MSC
FND Design Data: TableMSC.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: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
MSC_FILES_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPLAN_ID
ColumnFILE_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:

SchemaMSC
ViewMSC_FILES#