[Home] [Help]
View: SO_MTL_DEMAND_INT_LINE_ID
View Text
SELECT DEMAND_SOURCE_LINE
, INVENTORY_ITEM_ID
, SESSION_ID
, OE_QUERY.ATP_DATE_LINE_ID(SESSION_ID
, DEMAND_SOURCE_LINE
, INVENTORY_ITEM_ID) ATP_DATE
, OE_QUERY.AVAILABLE_QUANTITY_LINE_ID(SESSION_ID
, DEMAND_SOURCE_LINE
, INVENTORY_ITEM_ID) AVAILABLE_QUANTITY
, OE_QUERY.DEMAND_INTERFACE_ROWID_LINE_ID(SESSION_ID
, DEMAND_SOURCE_LINE) DEMAND_INTERFACE_ROWID
FROM MTL_DEMAND_INTERFACE
WHERE N_COLUMN4 IS NULL
AND LINE_ITEM_QUANTITY > 0
Columns
Name |
DEMAND_SOURCE_LINE |
INVENTORY_ITEM_ID |
SESSION_ID |
ATP_DATE |
AVAILABLE_QUANTITY |
DEMAND_INTERFACE_ROWID |