![INV On-hand Quatity of one Particular Item in whole Organization,AskHareesh Blog for OracleApps](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhJcn95Nkp1tEoRBA-Lwb9SKSw7nQ9IYLt1ylTQ9kVILoRZklh2aAz1yeuSpShkg24Au2M1hE1RSTTGdF5vuQ_gF82RiqYHULXML54zqT70MRzSXk0e7UC71zY8sELknFJgfLtooNLY5Ik/s1600/INV+On-hand+Quatity+of+one+Particular+Item+in+whole+Organization.png)
INV On-hand Quatity of one Particular Item in whole Organization:-
------------------------------
The following Query will On-hand Quatity of particular item in the whole Organization
select sum(primary_transaction_
Example:-
Note:- 123456 is the item ID of the particular item. This can be found in the base table of the item (MTL_SYSTEM_ITEMS_B). SEGMENT1 column of this table would have Item Name and Inventory_item_id is the primary column of the table. The follow query is using this value.
select sum(primary_transaction_
If you want to know the on-hand Quantity of particular item at all the Inventory Organization then use the following the Query.
select sum(primary_transaction_
group by organization_id;
No comments:
Post a Comment