Query to get data from mtl_material_transactions and mtl_transaction_details_v
Dear All,
What is the the query to get data from mtl_material_transactions and mtl_transaction_details_v without using distinct to eliminate duplication in retrieved rows.
Example:
SELECT mt.transaction_id, mt.transaction_date, mt.organization_id,
mtv.object_id, mtv.transaction_quantity, mtv.transaction_type_id
FROM mtl_material_transactions mt, mtl_transaction_details_v mtv
WHERE mt.transaction_id = mtv.transaction_id AND mt.transaction_id = 7578171
Out Put:
TRANSACTION_ID TRANSACTION_DATE ORGANIZATION_ID OBJECT_ID TRANSACTION_QUANTITY TRANSACTION_TYPE_ID
7578171 30/11/2016 7:00:07 AM 999 134337 1 15
7578171 30/11/2016 7:00:07 AM 999 132257 1 15
This is one transaction actually; but as you can see there are two records for this single transaction.