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: ViewMRP.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:

SchemaAPPS
PL/SQL PackageINV_DECIMALS_PUB - show dependent code
PL/SQL PackageINV_SALESORDER - show dependent code
PL/SQL PackageMRP_CALENDAR - show dependent code
SynonymOE_ORDER_LINES_ALL

APPS.MRP_SO_UPDATES_SUMMARY_V is not referenced by any database object