Query to get the Receiving Transaction where data not yet created in MMT and MMTT

select rt.transaction_id, rsl.transfer_percentage, msi.revision_qty_control_code,
rsl.item_revision, rsl.item_id,
rsl.from_organization_id, rsl.shipment_unit_price, rsh.shipment_num,
rsh.freight_carrier_code, rsh.num_of_containers, rsh.waybill_airbill_num,
rsh.ussgl_transaction_code, rp.receiving_account_id
from rcv_transactions rt, mtl_system_items msi,
rcv_shipment_headers rsh, rcv_shipment_lines rsl, rcv_parameters rp
where
rt.transaction_id = &your_transaction_id
and rt.TRANSACTION_TYPE = 'DELIVER'
and rt.DESTINATION_TYPE_CODE = 'INVENTORY'
and rt.shipment_header_id = rsh.shipment_header_id
and rsl.shipment_header_id = rsh.shipment_header_id
and rt.shipment_line_id = rsl.shipment_line_id

and msi.inventory_item_id = rsl.item_id
and msi.organization_id = rt.organization_id
and rp.organization_id = rt.organization_id
and not exists
(select 'Found' from mtl_material_transactions
where rcv_transaction_id = rt.transaction_id)
and not exists
(select 'Found' from mtl_material_transactions_temp
where rcv_transaction_id = rt.transaction_id) ;