How to get the items which are updated to 0 on-hand quantity?
Summary:
I am trying to find the items which are updated with 0 on hand quantity.
Content (required):
EX: for the first run, Item1 has on hand quantity as 60
inv_onhand_quantities_details.transaction_quantity = 60
then on hand quantity updated to 0 for Item1
for the next run, I don't see this item in inv_onhand_quantities_details table.
How to track this item and display as 0 quantity? Do we have any history tables which holds these details?
Version (include the version you are using, if applicable):
Oracle Cloud Fusion 11.13.23.07.0
Code Snippet (add any code snippets that support your topic, if applicable):
Tagged:
0