View: MRP_SO_UPDATES_SUMMARY_V

Product:	MRP - Master Scheduling/MRP
Description:	Sales order summary view
Implementation/DBA Data:	APPS.MRP_SO_UPDATES_SUMMARY_V

View Text

SELECT DEM.INVENTORY_ITEM_ID
, DECODE(DEM.DEMAND_TYPE
, 1
, DEM.INVENTORY_ITEM_ID
, NULL)
, DEM.DEMAND_ID
, DEM.ORGANIZATION_ID
, DEM.REQUIREMENT_DATE
, DECODE(DEM.RESERVATION_QUANTITY
, 0
, DEM.PRIMARY_UOM_QUANTITY
, DEM.RESERVATION_QUANTITY)
, 'Y'
, DEM.CUSTOMER_ID
, DEM.SHIP_TO_SITE_USE_ID
, DEM.BILL_TO_SITE_USE_ID
, DEM.DEMAND_CLASS
, DEM.USER_LINE_NUM
, TO_NUMBER(NULL)
, DEM.DEMAND_SOURCE_HEADER_ID
, DEM.DEMAND_ID
, TO_CHAR(NULL)
, 5
FROM MTL_DEMAND_OMOE DEM
WHERE DEM.AVAILABLE_TO_MRP = 1
AND DEM.DEMAND_SOURCE_TYPE IN (2
, 8)
AND DEM.CUSTOMER_ID IS NOT NULL
AND DEM.SHIP_TO_SITE_USE_ID IS NOT NULL
AND DEM.BILL_TO_SITE_USE_ID IS NOT NULL
AND DEM.PARENT_DEMAND_ID IS NULL
AND OPEN_FLAG = 'Y'
AND COMPLETED_QUANTITY = 0

Columns