Translate

Thursday, July 6, 2017

Total received Qty in 9 months


select sum(transaction_quantity) from mtl_material_transactions mtl
where mtl.organization_id = mtl.organization_id
and mtl.transaction_quantity>0
and mtl.transaction_date between trunc(sysdate) and trunc(sysdate-270)"kooo"; --- tot_rec_qty_9mths;

No comments:

Post a Comment

Text Message

Item Rate Update for Stock In Trade - Returnable Receive/Return (Loan)

  Stock In Trade - Returnable Receive/Return (Loan)