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

TABLE: MRP.MRP_EXCEL_COLUMNS

Object Details
Object Name: MRP_EXCEL_COLUMNS
Object Type: TABLE
Owner: MRP
FND Design Data: TableMRP.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.


Storage Details
Tablespace: TablespaceAPPS_TS_SEED
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
MRP_EXCEL_COLUMNS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_SEED ColumnEXCEL_ID
Columns
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
Query Text

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;

Dependencies

[top of page]

MRP.MRP_EXCEL_COLUMNS does not reference any database object

MRP.MRP_EXCEL_COLUMNS is referenced by following:

SchemaMRP
ViewMRP_EXCEL_COLUMNS#