[Home] [Help] [Dependency Information]
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.
Tablespace: | APPS_TS_SEED |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
MRP_EXCEL_U1 | NORMAL | UNIQUE | APPS_TS_SEED | EXCEL_NAME |
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) |
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;
MRP.MRP_EXCELS does not reference any database object
MRP.MRP_EXCELS is referenced by following:
|
|
|