Inventory Management - EBS (MOSC)

MOSC Banner

Query to get data from mtl_material_transactions and mtl_transaction_details_v

edited Feb 28, 2019 9:08AM in Inventory Management - EBS (MOSC) 6 commentsAnswered ✓

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center