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

TABLE: MRP.MRP_LOAD_PARAMETERS

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


MRP_LOAD_PARAMETERS holds information about batches of tasks to be
processed by a single autoload process. This table is populated by
the Load Forecast and Load Master Schedule forms, and is used for all
types of loads (that is schedule to schedule load, item forecast to
schedule load) and so forth.
.
ORGANIZATION_ID and SOURCE_ORGANIZATION_ID columns indicate the
organization that the data is being posted to and organization that
the data is generated from, respectively.
.
PROCESS_STATUS indicates whether or not the row has been processed.
The form creating the row sets the value of this column to 2 which
means pending to be processed. The autoload program, upon processing
the row, will set this column to 4 or 5 to indicate erroneous or
successful execution respectively. ERROR_MESSAGE column is populated
by the autoload program and contains either a date and time for
successful execution or a date and time plus an error message when
unsuccessful.
.
QUERY_ID identifies a set of rows to be processed by a single autoload
process.
.
The columns LOAD_SOURCE and LOAD_DESTINATION indicate the source and
destination for the load: 1 = schedule, 2 = forecast, 3 = sales order,
4 = interorganization planned order. These columns also dictate what
other columns need to be populated. For example, if these columns
indicate that sales orders are being loaded into a master schedule
(LOAD_SOURCE = 3, LOAD_DESTINATION = 1), only the SCHEDULE_DESIGNATOR
column must be populated. If an item forecast is being loaded into
another item forecast (LOAD_SOURCE = 2, LOAD_DESTINATION = 2), then
FORECAST_DESIGNATOR and SOURCE_FORECAST_DESIGNATOR must be populated.
If an item forecast is being loaded into a master schedule
(LOAD_SOURCE = 2, LOAD_DESTINATION = 1), then SCHEDULE_DESIGNATOR and
SOURCE_FORECAST_DESIGNATOR must be populated.
.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
MRP_LOAD_PARAMETERS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnQUERY_ID
ColumnPROCESS_STATUS
Columns
Name Datatype Length Mandatory Comments
QUERY_ID NUMBER
Yes Batch identifier
PROCESS_STATUS NUMBER
Yes Processing status
LAST_UPDATE_DATE DATE

Standard Who column
LAST_UPDATED_BY NUMBER

Standard Who column
CREATION_DATE DATE

Standard Who column
CREATED_BY NUMBER

Standard Who column
LAST_UPDATE_LOGIN NUMBER

Standard Who column
ORGANIZATION_ID NUMBER
Yes Organization identifier
SCHEDULE_DESIGNATOR VARCHAR2 (10)
Destination master schedule
FORECAST_DESIGNATOR VARCHAR2 (10)
Name of the destination forecast
LOAD_SOURCE NUMBER
Yes Load source (forecasts, schedules or sales orders)
LOAD_DESTINATION NUMBER
Yes Load destination (forecast or schedule)
SOURCE_ORGANIZATION_ID NUMBER
Yes Organization identifier of the source of schedule or forecast or sales orders
SOURCE_SCHEDULE_DESIGNATOR VARCHAR2 (10)
Source master schedule
SOURCE_FORECAST_DESIGNATOR VARCHAR2 (10)
Source forecast
ERROR_MESSAGE VARCHAR2 (240)
Explanation of processing error
SELECTION_LIST_NAME VARCHAR2 (10)
Selection list name
SELECTION_LIST_TYPE NUMBER

Selection list type
Query Text

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


SELECT QUERY_ID
,      PROCESS_STATUS
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      ORGANIZATION_ID
,      SCHEDULE_DESIGNATOR
,      FORECAST_DESIGNATOR
,      LOAD_SOURCE
,      LOAD_DESTINATION
,      SOURCE_ORGANIZATION_ID
,      SOURCE_SCHEDULE_DESIGNATOR
,      SOURCE_FORECAST_DESIGNATOR
,      ERROR_MESSAGE
,      SELECTION_LIST_NAME
,      SELECTION_LIST_TYPE
FROM MRP.MRP_LOAD_PARAMETERS;

Dependencies

[top of page]

MRP.MRP_LOAD_PARAMETERS does not reference any database object

MRP.MRP_LOAD_PARAMETERS is referenced by following:

SchemaMRP
ViewMRP_LOAD_PARAMETERS#