Sql for onhand and material transactions
I have a select and the lines are doubled for transaction_id. Is there anything else that should be added to get the in and out only once
select *
FROM APPS.mtl_onhand_quantities moq,
INV.mtl_material_transactions MMT
where moq.lot_number in ( '72015208939')
and moq.organization_id = mmt.organization_id
and moq.inventory_item_id = mmt.inventory_item_id
and mmt.transaction_id in (87604262,87604266,90575736,90575738,91212687,92248150)