RESERVATION QUERY FOR INVENTORY

SELECT  ORGANIZATION_CODE From_Organization ,substr(SHIPMENT_PRIORITY_CODE,1,3) to_organization,wdd.SOURCE_HEADER_NUMBER Order_number,
         wdd.SOURCE_LINE_NUMBER Line_no,
         SOURCE_LINE_ID,
         msib.segment1 parts,
         rs.RESERVATION_QUANTITY,
         wdd.organization_id,RESERVATION_ID
  FROM   mtl_reservations rs,
         wsh_delivery_details wdd,
         mtl_system_items_b msib,
         org_organization_definitions ord
 WHERE       rs.DEMAND_SOURCE_LINE_ID = wdd.SOURCE_LINE_ID
         AND wdd.RELEASED_STATUS = 'B'
         AND wdd.SOURCE_HEADER_TYPE_NAME LIKE 'Internal%Order%'
         AND STAGED_FLAG IS NULL
         AND wdd.REQUESTED_QUANTITY = RESERVATION_QUANTITY
         AND DETAILED_QUANTITY = 0
         AND msib.inventory_item_id = wdd.inventory_item_id
         AND msib.organization_id = wdd.organization_id
         AND ord.organization_id = wdd.organization_id
        
        
        
        
        
        
        
         SELECT *
  FROM mtl_reservations
 WHERE reservation_id IN (
          SELECT reservation_id
            FROM mtl_reservations rs,
                 wsh_delivery_details wdd,
                 mtl_system_items_b msib,
                 org_organization_definitions ord
           WHERE rs.demand_source_line_id = wdd.source_line_id
             AND wdd.released_status = 'B'
             AND wdd.source_header_type_name LIKE 'Internal%Order%'
             AND staged_flag IS NULL
             AND wdd.requested_quantity = reservation_quantity
             AND detailed_quantity = 0
             AND msib.inventory_item_id = wdd.inventory_item_id
             AND msib.organization_id = wdd.organization_id
             AND ord.organization_id = wdd.organization_id)
            
               
            
            
            
            
            
 delete from mtl_reservations
 WHERE reservation_id IN (
          SELECT reservation_id
            FROM mtl_reservations rs,
                 wsh_delivery_details wdd,
                 mtl_system_items_b msib,
                 org_organization_definitions ord
           WHERE rs.demand_source_line_id = wdd.source_line_id
             AND wdd.released_status = 'B'
             AND wdd.source_header_type_name LIKE 'Internal%Order%'
             AND staged_flag IS NULL
             AND wdd.requested_quantity = reservation_quantity
             AND detailed_quantity = 0
             AND msib.inventory_item_id = wdd.inventory_item_id
             AND msib.organization_id = wdd.organization_id
             AND ord.organization_id = wdd.organization_id)
            
            
            


Please find the Back_Order_details for today And Please find the attachment.


Thanks & Regards

Amresh kumaran M I