SQL to get current inventory Supply/Demand details

 Hi,

Is it possible to get the Inventory Supply / Demand information in a sql script . . . I just tried to query from mtl_supply_demand_temp table. But it gives the exact output only when the Supply/Demand screen is open and gives different output when the same screen is closed.

select organization_id , inventory_item_id , quantity, on_hand_quantity, requirement_date from mtl_supply_demand_temp a where inventory_item_id = 116522 and seq_num = (select max(seq_num) from mtl_supply_demand_temp where inventory_item_id = a.inventory_item_id) organization_id , inventory_item_id , quantity, on_hand_quantity