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_EXCELS

Object Details

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

MRP_EXCELS table stores seed data necessary for generating graphs in
the Planner's Workbench and other planning forms.
EXCEL_NAME column uniquely identifies a record in the MRP_EXCELS
table. BLOCK_NAME contains the name of the block for which the graph
is drawn.
The DESCRIPTION column contains a descriptive text of the graph, for
instance 'Planners Workbench Horizontal Plan'.
APPLICATION_SHORT_NAME identifies the application whether it is MRP or
CRP.
FILE_NAME and INITIAL_SHEET columns contain Excel specific attributes.

Storage Details

Tablespace:	APPS_TS_SEED
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
MRP_EXCEL_U1	NORMAL	UNIQUE	APPS_TS_SEED	EXCEL_NAME

Columns

Name	Datatype	Length	Mandatory	Comments
EXCEL_ID	NUMBER		Yes	Unique identifier
EXCEL_NAME	VARCHAR2	(30)	Yes	Excel name(unique)
BLOCK_NAME	VARCHAR2	(30)	Yes	Block for which the graph is plotted
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
REQUEST_ID	NUMBER			Concurrent Who column
PROGRAM_APPLICATION_ID	NUMBER			Concurrent Who column
PROGRAM_ID	NUMBER			Concurrent Who column
PROGRAM_UPDATE_DATE	DATE			Concurrent Who column
DESCRIPTION	VARCHAR2	(80)		Graph description
APPLICATION_SHORT_NAME	VARCHAR2	(50)	Yes	Application short name (MRP or CRP)
FILE_NAME	VARCHAR2	(50)	Yes	File name (Excel attribute)
INITIAL_SHEET	VARCHAR2	(50)	Yes	Initial sheet (Excel attribute)

Query Text

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


SELECT EXCEL_ID
,      EXCEL_NAME
,      BLOCK_NAME
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      DESCRIPTION
,      APPLICATION_SHORT_NAME
,      FILE_NAME
,      INITIAL_SHEET
FROM MRP.MRP_EXCELS;

Dependencies

[top of page]

MRP.MRP_EXCELS does not reference any database object

MRP.MRP_EXCELS is referenced by following:

APPS: MRP_EXCELS