[Home] [Help]
View: 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
Name |
ORGANIZATION_ID |
INVENTORY_ITEM_ID |
REVISION |
WIP_ENTITY_ID |
DEMAND_SOURCE_HEADER_ID |
DEMAND_SOURCE_LINE |
ORDER_LINE |
DEMAND_SOURCE_DELIVERY |
SHIPMENT |
REQUEST_DATE |
QUANTITY |
SUBINVENTORY |