[Home] [Help] [Dependency Information]
Object Name: | MRP_SALES_ORDER_UPDATES |
---|---|
Object Type: | TABLE |
Owner: | MRP |
FND Design Data: | MRP.MRP_SALES_ORDER_UPDATES |
Subobject Name: | |
Status: | VALID |
MRP_SALES_ORDER_UPDATES stores information regarding changes to sales
orders that affect forecast consumption. During forecast consumption
this table is first updated so that all new rows (that is rows with
ERROR_MESSAGE and REQUEST_ID set to null and PROCESS_STATUS set to '2'
(waiting to be processed)) are given a new REQUEST_ID and a
PROCESS_STATUS of '3' (in process) by a Planning Manager Worker. The
forecast consumption routine then consumes the forecast for all rows
with a given REQUEST_ID. The rows will then be given a PROCESS_STATUS
of '5' (successful completion) if forecast consumption succeeded or
populated with the corresponding error text if forecast consumption
fails.
.
The SOURCE_CODE can be used to identify third party software used to
load the MRP_SALES_ORDER_UPDATES table. The SOURCE_LINE_ID can be
used to show where the imported data came from within the third party
software (i.e. table_name, field_name).
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
MRP_SALES_ORDER_UPDATES_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | UPDATE_SEQ_NUM |
MRP_SALES_ORDER_UPDATES_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
ORGANIZATION_ID
INVENTORY_ITEM_ID PROCESS_STATUS REQUEST_ID |
MRP_SALES_ORDER_UPDATES_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | SALES_ORDER_ID |
MRP_SALES_ORDER_UPDATES_N3 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
REQUEST_ID
PROCESS_STATUS |
MRP_SALES_ORDER_UPDATES_N4 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
PROCESS_STATUS
INVENTORY_ITEM_ID |
MRP_SALES_ORDER_UPDATES_N5 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | CURRENT_CUSTOMER_ID |
MRP_SALES_ORDER_UPDATES_N6 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | PREVIOUS_CUSTOMER_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
UPDATE_SEQ_NUM | NUMBER | Yes | Unique identifier | |
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 | ||
INVENTORY_ITEM_ID | NUMBER | Yes | Inventory item identifier | |
SALES_ORDER_ID | NUMBER | Yes | Sales order identifier | |
ORGANIZATION_ID | NUMBER | Yes | Organization identifier | |
NEW_SCHEDULE_DATE | DATE | Yes | The planned ship date for a new sales order or a modified sales order | |
OLD_SCHEDULE_DATE | DATE | The planned ship date of the sales order prior to a change in the sales order | ||
NEW_SCHEDULE_QUANTITY | NUMBER | Yes | Quantity ordered for a new or modified sales order | |
OLD_SCHEDULE_QUANTITY | NUMBER | The sales order quantity prior to a change in the sales order | ||
CURRENT_CUSTOMER_ID | NUMBER | Yes | Customer identifier of the initial or modified sales order | |
PREVIOUS_CUSTOMER_ID | NUMBER | Customer identifier of the sales order prior to a change in the sales order | ||
CURRENT_SHIP_ID | NUMBER | Yes | Ship to identifier of the new or modified sales order | |
PREVIOUS_SHIP_ID | NUMBER | Ship to identifier of the sales order prior to a change in the sales order | ||
CURRENT_BILL_ID | NUMBER | Yes | Bill to identifier of the new or modified sales order | |
PREVIOUS_BILL_ID | NUMBER | Bill to identifier of the sales order prior to a change in the sales order | ||
CURRENT_DEMAND_CLASS | VARCHAR2 | (30) | The demand class to which the initial or modified sales order is assigned | |
PREVIOUS_DEMAND_CLASS | VARCHAR2 | (30) | The demand class to which the sales order was assigned prior to modification | |
CURRENT_TERRITORY_ID | NUMBER | Territory identifier of the initial or modified sales order | ||
PREVIOUS_TERRITORY_ID | NUMBER | Territory identifier of the sales order prior to a change in the sales order | ||
LINE_NUM | VARCHAR2 | (30) | Sales order line number | |
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 | ||
SOURCE_CODE | VARCHAR2 | (10) | Source code of application software which imported rows into the table | |
SOURCE_LINE_ID | NUMBER | Information about where the imported data resides within the application responsible for populating this table | ||
PROCESS_STATUS | NUMBER | Processing status | ||
ERROR_MESSAGE | VARCHAR2 | (240) | Error message if processing failed | |
CURRENT_AVAILABLE_TO_MRP | VARCHAR2 | (1) | Yes | Current available to MRP flag |
PREVIOUS_AVAILABLE_TO_MRP | VARCHAR2 | (1) | Previous available to MRP flag | |
BASE_MODEL_ID | NUMBER | Base model item identifier for configurations | ||
ORDERED_ITEM_ID | NUMBER | Not currently used | ||
LAST_EXPLODED_REVISION | VARCHAR2 | (3) | Revision for explosion of configuration sales order line | |
COMPLETED_QUANTITY | NUMBER | Not currently used |
Cut, paste (and edit) the following text to query this object:
SELECT UPDATE_SEQ_NUM
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, INVENTORY_ITEM_ID
, SALES_ORDER_ID
, ORGANIZATION_ID
, NEW_SCHEDULE_DATE
, OLD_SCHEDULE_DATE
, NEW_SCHEDULE_QUANTITY
, OLD_SCHEDULE_QUANTITY
, CURRENT_CUSTOMER_ID
, PREVIOUS_CUSTOMER_ID
, CURRENT_SHIP_ID
, PREVIOUS_SHIP_ID
, CURRENT_BILL_ID
, PREVIOUS_BILL_ID
, CURRENT_DEMAND_CLASS
, PREVIOUS_DEMAND_CLASS
, CURRENT_TERRITORY_ID
, PREVIOUS_TERRITORY_ID
, LINE_NUM
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, SOURCE_CODE
, SOURCE_LINE_ID
, PROCESS_STATUS
, ERROR_MESSAGE
, CURRENT_AVAILABLE_TO_MRP
, PREVIOUS_AVAILABLE_TO_MRP
, BASE_MODEL_ID
, ORDERED_ITEM_ID
, LAST_EXPLODED_REVISION
, COMPLETED_QUANTITY
FROM MRP.MRP_SALES_ORDER_UPDATES;
MRP.MRP_SALES_ORDER_UPDATES does not reference any database object
MRP.MRP_SALES_ORDER_UPDATES is referenced by following:
|
|
|