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;
Subscribe to:
Post Comments (Atom)
-
Oracle Alert : Move order Created from Production Batch I Got one Requirement from Production and Store Team, as below So I created... -
Oracle Process Manufacturing Process Execution – List of database tables GME_BATCH_HEADER GME_BATCH_HEADER_MIG GME_BATCH_HISTORY GME_BATCH_...
-
Discrete Jobs End to End Cycle with Cost Roll-up in Standard Cost Organization in R12.2 STEP 1: CREATE ITEMS Responsibility: ...
No comments:
Post a Comment
Text Message