Query to get Items which are in Inspection.

SELECT poh.segment1 PoNUM,
              pol.line_num LineNum,
              msi.segment1 Item,
              rsh.receipt_num ReceiptNum,
              rct.quantity Quantity
      FROM apps.po_headers_all poh,
           apps.po_lines_all pol,
           apps.po_line_locations_all pll,
           apps.rcv_transactions rct,
           apps.rcv_shipment_headers rsh,
           apps.rcv_shipment_lines rsl,
           apps.rcv_routing_headers rrh,
           apps.mtl_system_items msi
     WHERE rsh.shipment_header_id = rsl.shipment_header_id
       AND rsl.po_line_location_id = rct.po_Line_location_id
       AND rsl.po_line_location_id = pll.Line_location_id
       AND rct.po_line_location_id = pll.Line_location_id
       AND poh.po_header_id = pol.po_header_id
       AND poh.po_header_id = rct.po_header_id
       AND pol.po_line_id = rct.po_line_id
       AND rct.transaction_type IN ('RECEIVE')
       AND rrh.routing_header_id=rct.routing_header_id
       AND rrh.routing_name='Inspection Required'
       AND msi.inventory_item_id=pol.item_id
       AND msi.organization_id=rct.organization_id
       AND NOT EXISTS
                     (SELECT 1
                        FROM apps.rcv_transactions rct1
                       WHERE 1=1
                         AND rct.transaction_id = rct1.parent_transaction_id
                         AND rct1.transaction_type = 'ACCEPT'
                      );