You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

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):

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!