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_FILES

Object Details

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

The MRP_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
MRP_FILES_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	FILE_TYPE COMPILE_DESIGNATOR ORGANIZATION_ID

Columns

Name	Datatype	Length	Mandatory	Comments
ORGANIZATION_ID	NUMBER		Yes	Organization identifier
COMPILE_DESIGNATOR	VARCHAR2	(10)	Yes	MPS, MRP or DRP plan identifier
FILE_TYPE	NUMBER		Yes	File type
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
FILE_NAME	VARCHAR2	(255)	Yes	Name of file
FILE_SIZE	NUMBER			File size
FILE_CREATION_DATE	DATE			File creation date
NEW_SNAPSHOT	NUMBER			Not currently used
NEW_PLANNER	NUMBER			Not currently used
ROW_COUNT	NUMBER			Row count
COPY_FLAG	NUMBER			Copy flag(used in Copy Plan program)

Query Text

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


SELECT ORGANIZATION_ID
,      COMPILE_DESIGNATOR
,      FILE_TYPE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      FILE_NAME
,      FILE_SIZE
,      FILE_CREATION_DATE
,      NEW_SNAPSHOT
,      NEW_PLANNER
,      ROW_COUNT
,      COPY_FLAG
FROM MRP.MRP_FILES;

Dependencies

[top of page]

MRP.MRP_FILES does not reference any database object

MRP.MRP_FILES is referenced by following:

APPS: MRP_FILES