eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: MRP.MRP_SALES_ORDER_UPDATES

Object Details

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).

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

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

Columns

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

Query Text

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;

Dependencies

[top of page]

MRP.MRP_SALES_ORDER_UPDATES does not reference any database object

MRP.MRP_SALES_ORDER_UPDATES is referenced by following:

MRP: MRP_SALES_ORDER_UPDATES#