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

TABLE: MRP.MRP_EXCEL_COMPONENTS

Object Details
Object Name: MRP_EXCEL_COMPONENTS
Object Type: TABLE
Owner: MRP
FND Design Data: TableMRP.MRP_EXCEL_COMPONENTS
Subobject Name:
Status: VALID


MRP_EXCEL_COMPONENTS table stores miscellaneous seed data information
relevent to generating graphs from the Planners Workbench and other
planning forms.
This table along with MRP_EXCELS and MRP_EXCEL_COLUMNS defines the
different parameters used to generate graphs.


Storage Details
Tablespace: TablespaceAPPS_TS_ARCHIVE
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
MRP_EXCEL_COMPONENTS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_ARCHIVE ColumnEXCEL_ID
Columns
Name Datatype Length Mandatory Comments
EXCEL_ID NUMBER
Yes Excel identifier
COMPONENT_SEQUENCE NUMBER
Yes Component sequence identifier
COMPONENT_TYPE NUMBER
Yes Component 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
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
TITLE_TYPE NUMBER

Title type
TITLE VARCHAR2 (80)
Title
Query Text

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


SELECT EXCEL_ID
,      COMPONENT_SEQUENCE
,      COMPONENT_TYPE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      TITLE_TYPE
,      TITLE
FROM MRP.MRP_EXCEL_COMPONENTS;

Dependencies

[top of page]

MRP.MRP_EXCEL_COMPONENTS does not reference any database object

MRP.MRP_EXCEL_COMPONENTS is referenced by following:

SchemaMRP
ViewMRP_EXCEL_COMPONENTS#