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]

VIEW: APPS.MRP_SO_UPDATES_SUMMARY_V

Object Details

Object Name:	MRP_SO_UPDATES_SUMMARY_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	MRP.MRP_SO_UPDATES_SUMMARY_V
Subobject Name:
Status:	VALID

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
INVENTORY_ITEM_ID	NUMBER		Yes	Inventory item identifier
ORDERED_ITEM_ID	NUMBER			Ordered item identifier
SALES_ORDER_ID	NUMBER		Yes	Sales order identifier
ORGANIZATION_ID	NUMBER			Organization identifier
OLD_SCHEDULE_DATE	DATE			The planned ship date of the sales order prior to a change in the sales order
OLD_SCHEDULE_QUANTITY	NUMBER			Sum of sales order quantities for the day
PREVIOUS_AVAILABLE_TO_MRP	CHAR	(1)		Previous available to MRP flag
PREVIOUS_CUSTOMER_ID	NUMBER			Constant value
PREVIOUS_SHIP_ID	NUMBER			Constant value
PREVIOUS_BILL_ID	NUMBER			Constant value
PREVIOUS_DEMAND_CLASS	VARCHAR2	(30)		The demand class to which the sales order was assigned prior to modification
LINE_NUM	VARCHAR2	(40)		Constant value
BASE_MODEL_ID	NUMBER			Base model item identifier for configurations
PREVIOUS_TERRITORY_ID	NUMBER			Constant value
UPDATE_SEQ_NUM	NUMBER		Yes	Constant value
ERROR_MESSAGE	VARCHAR2	(0)		Error message if processing failed
PROCESS_STATUS	NUMBER			Processing status

Query Text

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


SELECT INVENTORY_ITEM_ID
,      ORDERED_ITEM_ID
,      SALES_ORDER_ID
,      ORGANIZATION_ID
,      OLD_SCHEDULE_DATE
,      OLD_SCHEDULE_QUANTITY
,      PREVIOUS_AVAILABLE_TO_MRP
,      PREVIOUS_CUSTOMER_ID
,      PREVIOUS_SHIP_ID
,      PREVIOUS_BILL_ID
,      PREVIOUS_DEMAND_CLASS
,      LINE_NUM
,      BASE_MODEL_ID
,      PREVIOUS_TERRITORY_ID
,      UPDATE_SEQ_NUM
,      ERROR_MESSAGE
,      PROCESS_STATUS
FROM APPS.MRP_SO_UPDATES_SUMMARY_V;

Dependencies

[top of page]

APPS.MRP_SO_UPDATES_SUMMARY_V references the following:

APPS: INV_DECIMALS_PUB - show dependent code; INV_SALESORDER - show dependent code; MRP_CALENDAR - show dependent code; OE_ORDER_LINES_ALL

APPS.MRP_SO_UPDATES_SUMMARY_V is not referenced by any database object