[Home] [Help] [Dependency Information]
Object Name: | MRP_SO_LINES_TEMP |
---|---|
Object Type: | TABLE |
Owner: | MRP |
FND Design Data: | MRP.MRP_SO_LINES_TEMP |
Subobject Name: | |
Status: | VALID |
This table stores the list of all the modified sales order lines affected during the sales order scheduling, rescheduling or canceling of the sales order. The records are inserted into this table with process_status = 2.
The planning manager updates MRP's copy of sales order (Table: mrp_sales_order_updates) by processing these records and finally setting the process_status on these records to 5.
This improves the performance of the planning manager. The 'Planning Manager Worker (Once-a-day Tasks)' deletes the processed records (process_status = 5) from this table that are more that two days old. This prevents this table from growing very big.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
MRP_SO_LINES_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
PROCESS_STATUS
REQUEST_ID |
MRP_SO_LINES_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | LINE_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
LAST_UPDATED_BY | NUMBER | Yes | Standard Who column | |
LAST_UPDATE_DATE | DATE | 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 | ||
LINE_ID | NUMBER | Yes | Standard Who column | |
PROCESS_STATUS | NUMBER | Yes | Standard Who column | |
REQUEST_ID | NUMBER | Request Id of the concurrent request that processed this record |
Cut, paste (and edit) the following text to query this object:
SELECT LAST_UPDATED_BY
, LAST_UPDATE_DATE
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, LINE_ID
, PROCESS_STATUS
, REQUEST_ID
FROM MRP.MRP_SO_LINES_TEMP;
MRP.MRP_SO_LINES_TEMP does not reference any database object
MRP.MRP_SO_LINES_TEMP is referenced by following:
|
|
|