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

TABLE: MRP.MRP_SQLLOAD_PARAMETERS

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


MRP_SQLLOAD_PARAMETERS stores the SQL*Loader parameters: Bindsize and Rows, used by the concurrent program 'Loader Worker', launched during MRP plan run.
This table is populated by the 'SQL*Loader Parameter' Form included in the Setup portion of the Material Planning responsibility. For all the MRP tables populated during a plan run, Bindsize is initialized to 1000000 and Rows to 1000. The user can change these parameters if he wishes to tune the performance of the concurrent program 'Loader Worker' launched during the plan run.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
MRP_SQLLOAD_PARAMETERS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnTABLE_NAME
Columns
Name Datatype Length Mandatory Comments
TABLE_NAME VARCHAR2 (30) Yes Table Name
BINDSIZE NUMBER
Yes Bind Size
NUMBER_OF_ROWS NUMBER
Yes Number of Rows to be processed at one time
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
Yes Standard Who Column
Query Text

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


SELECT TABLE_NAME
,      BINDSIZE
,      NUMBER_OF_ROWS
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
FROM MRP.MRP_SQLLOAD_PARAMETERS;

Dependencies

[top of page]

MRP.MRP_SQLLOAD_PARAMETERS does not reference any database object

MRP.MRP_SQLLOAD_PARAMETERS is referenced by following:

SchemaAPPS
SynonymMRP_SQLLOAD_PARAMETERS