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)
Outside Processing Setups and Cycle in Oracle EBS R12
OSP Cycle This post is about Oracle Outside Processing Cycle. Outside processing is used when we don't have in house resources to comp...
-
Stock In Trade - Returnable Receive/Return (Loan)
-
The process flow for Internal Orders Internal orders normally start with creation of requisitions in Oracle Purchasing (which is created a...
-
WIP TABLES Oracle Apps WIP KEY Tables WIP_LINES WIP_LINES stores production line information. Each row includes a line name, maximum a...
No comments:
Post a Comment
Text Message