PO Receipts and inventory Material Transactions Link Query RCV_SHIPMENT_LINES and mtl_material_transactions

select b.* from apps.RCV_SHIPMENT_LINES a, apps.mtl_material_transactions b
where a.creation_date > to_date('29-JUL-2015', 'DD-MON-YYYY') and a.creation_date < to_date('30-JUL-2015', 'DD-MON-YYYY')
and b.transaction_type_id = 21
AND a.mmt_transaction_id = b.transaction_id
and b.transaction_date > to_date('29-JUL-2015', 'DD-MON-YYYY') and b.transaction_date < to_date('30-JUL-2015', 'DD-MON-YYYY')
and a.SHIPMENT_LINE_STATUS_CODE = 'EXPECTED'