MTL ITEM RESERVATIONS QUERY

==========     MTL ITEM RESERVATIONS QUERY  ===========

select * from MTL_RESERVATIONS

select * from mtl_reservations where organization_id= 2035

select * from mtl_system_items_b bb where bb.INVENTORY_ITEM_ID = 133109 and bb.ORGANIZATION_ID = 10--


select *  from mtl_reservations where organization_id = 2035 and INVENTORY_ITEM_ID = 133109 and RESERVATION_ID=1345--

select * from MTL_DEMAND

SELECT o.organization_code, o.organization_name, i.segment1, i.description,
       r.reservation_quantity, orig_demand_source_header_id,
       supply_source_type_id
  FROM mtl_reservations r,
       org_organization_definitions o,
       mtl_system_items_b i
 WHERE r.inventory_item_id = 396964  --132940
   AND r.organization_id = o.organization_id
   AND r.organization_id = i.organization_id
   AND r.inventory_item_id = i.inventory_item_id

----------DEL---RES--TB--

SELECT *
  FROM gme_batch_header b
 WHERE b.batch_id = 1349161 --2052297



SELECT *
  FROM mtl_material_transactions_temp t
 WHERE t.inventory_item_id = 396964 --132940

 select * from MTL_RESERVATIONS_INTERFACE ri
where ri.INVENTORY_ITEM_ID = 396964


select * from mtl_transactions_interface rt
where rt.INVENTORY_ITEM_ID = 396964


select *  from mtl_reservations where organization_id = 2035 and INVENTORY_ITEM_ID = 133109 and RESERVATION_ID=134598531