PO Receipt and DELIVER in Oracle EBS r12

 SELECT DISTINCT receipt_num, rt.creation_date, itm.segment1, itm.description,

                mtt.transaction_quantity tq, mtt.primary_quantity pq,

                mtt.actual_cost ac_cost, mtt.transaction_cost t_cost

           FROM rcv_shipment_headers rsh,

                rcv_shipment_lines rsl,

                rcv_transactions rt,

                mtl_material_transactions mtt,

                mtl_system_items_b itm

          WHERE rsh.shipment_header_id = rsl.shipment_header_id

            AND rsl.shipment_header_id = rt.shipment_header_id

            AND rsl.shipment_line_id = rt.shipment_line_id

            AND rt.transaction_id = mtt.rcv_transaction_id

            AND mtt.inventory_item_id = itm.inventory_item_id

            AND rt.transaction_type = 'DELIVER'

            AND mtt.transaction_type_id = 18

            AND mtt.creation_date BETWEEN TO_DATE ('01-FEB-2022') AND TO_DATE ('28-FEB-2022')