[Home] [Help] [Dependency Information]
Object Name: | MRP_EXCEL_COLUMNS |
---|---|
Object Type: | TABLE |
Owner: | MRP |
FND Design Data: | MRP.MRP_EXCEL_COLUMNS |
Subobject Name: | |
Status: | VALID |
MRP_EXCEL_COLUMNS stores column seed data used for generating graphs
in the Planner's Workbench and other forms.
The FIELD_NAME column refers to the field in the form to be included
in the write to the flat file. The fields are written to the flat file
in the order specified in the SEQUENCE column.
Along with field information prompt information is also stored in this
table in the PROMPT and DYNAMIC_PROMPT columns.
Tablespace: | APPS_TS_SEED |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
MRP_EXCEL_COLUMNS_N1 | NORMAL | NONUNIQUE | APPS_TS_SEED | EXCEL_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
EXCEL_ID | NUMBER | Yes | Excel identifier | |
SEQUENCE | NUMBER | Yes | Field sequence | |
FIELD_NAME | VARCHAR2 | (30) | Yes | Field name |
ACTIVE | NUMBER | Yes | Not currently used | |
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 | ||
PROMPT_TYPE | NUMBER | Prompt type | ||
PROMPT | VARCHAR2 | (80) | Prompt | |
DYNAMIC_PROMPT | VARCHAR2 | (50) | Dynamic Prompt | |
DESCRIPTION | VARCHAR2 | (80) | Not currently used |
Cut, paste (and edit) the following text to query this object:
SELECT EXCEL_ID
, SEQUENCE
, FIELD_NAME
, ACTIVE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, PROMPT_TYPE
, PROMPT
, DYNAMIC_PROMPT
, DESCRIPTION
FROM MRP.MRP_EXCEL_COLUMNS;
MRP.MRP_EXCEL_COLUMNS does not reference any database object
MRP.MRP_EXCEL_COLUMNS is referenced by following:
|
|
|