Inventory Management - EBS (MOSC)

MOSC Banner

Diffrence between Transaction quantity and Primary quantity?

edited May 10, 2015 4:19AM in Inventory Management - EBS (MOSC) 4 commentsAnswered

Hello experts,

Can u please explain me exact difference between Transaction Qty and Primary Qty ???

e.g. while doing Reconcilition ,

for item,

select sum(transaction_quantity), sum(primary_quantity)  from mtl_material_transactions where inventory_item_id = 8

and organization_id in (86) and transaction_date >=  TO_DATE('31-Dec-2009 00:00:00','dd-mon-yyyy hh24:mi:ss')

and transaction_date <=  TO_DATE('30-apr-2013 23:59:59','dd-mon-yyyy hh24:mi:ss')"

i checked with above query and it gives output-->

sum of transaction qty=  -13893228

sum of primary qty =   42423

so , plz tell me what is the difference if this???

Regards,

Kunal

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