[Home] [Help]
View: SO_MTL_DEMAND_INT_DELIVERY
View Text
SELECT DEMAND_SOURCE_DELIVERY
, INVENTORY_ITEM_ID
, SESSION_ID
, OE_QUERY.ATP_DATE_DELIVERY(SESSION_ID
, DEMAND_SOURCE_DELIVERY) ATP_DATE
, OE_QUERY.AVAILABLE_QUANTITY_DELIVERY(SESSION_ID
, DEMAND_SOURCE_DELIVERY) AVAILABLE_QUANTITY
, OE_QUERY.DEMAND_INTERFACE_ROWID_DEL(SESSION_ID
, DEMAND_SOURCE_DELIVERY) DEMAND_INTERFACE_ROWID
FROM MTL_DEMAND_INTERFACE
WHERE N_COLUMN4 IS NULL
AND LINE_ITEM_QUANTITY > 0
Columns
Name |
DEMAND_SOURCE_DELIVERY |
INVENTORY_ITEM_ID |
SESSION_ID |
ATP_DATE |
AVAILABLE_QUANTITY |
DEMAND_INTERFACE_ROWID |