View: WIP_COMP_SALES_ORDERS_VAL_V

Product:	WIP - Work in Process
Description:	Sales orders for completion transactions
Implementation/DBA Data:	APPS.WIP_COMP_SALES_ORDERS_VAL_V

View Text

SELECT MD.ORGANIZATION_ID
, MD.INVENTORY_ITEM_ID
, MD.REVISION
, MD.SUPPLY_SOURCE_HEADER_ID WIP_ENTITY_ID
, MD.DEMAND_SOURCE_HEADER_ID
, MD.DEMAND_SOURCE_LINE
, MD.USER_LINE_NUM ORDER_LINE
, MD.DEMAND_SOURCE_DELIVERY
, MD.USER_DELIVERY SHIPMENT
, MD.REQUIREMENT_DATE REQUEST_DATE
, MD.PRIMARY_UOM_QUANTITY QUANTITY
, MD.SUBINVENTORY
FROM MTL_DEMAND MD
WHERE MD.DEMAND_SOURCE_TYPE = 2
AND MD.SUPPLY_SOURCE_TYPE = 5
AND MD.RESERVATION_TYPE = 3
AND MD.ROW_STATUS_FLAG = 1
AND MD.PRIMARY_UOM_QUANTITY > 0

Columns