PL/SQL (MOSC)

MOSC Banner

Sql for onhand and material transactions

edited Jan 22, 2016 10:02AM in PL/SQL (MOSC) 6 commentsAnswered

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)

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