Query to list GRN Received but not transected as of Date

HI,

Please help me to write a query to find list of GRN Recived but not delivered as of date 

Below is my query. Please help to correct it.

SELECT aps.vendor_name vendor_name,

       TO_CHAR (rt.transaction_date, 'DD-MON-RRRR') transaction_date,       --pha.segment1 segment1,

       rt.order_number segment1, rt.receipt_num receipt_num,

       msi.segment1 || '|' || msi.segment2 || '|' || msi.segment3 item_code,

       msi.description description, rt.quantity quantity,

       rt.unit_of_measure unit_of_measure, rt.line_number line_number

  FROM rcv_transactions_v rt, mtl_system_items msi, ap_suppliers aps

 WHERE rt.item_id = msi.inventory_item_id