Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
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

Need a SQL query to get the Total Quantity of Pending Transactions of a item in oracle fusion

in Reporting and Analytics for SCM

Hi Experts,

I need a SQL query to get the Total Quantity of Pending Transactions for a item.

My requirement is to get "Available to Transact" Quantity of a item. ( = 200 as for this Item)

According to this Post mentioned below,

And according to this attached documentation,

  • Available to Transact = (Quantity On Hand) - Pending Transactions - Reservations

Available to Reserve and Available to Transact Values

Therefore to calculate Available to Transact Quantity,

Total On hand Quantity - INV_ONHAND_QUANTITIES_SUMMARY

Reservations Quantity - INV_RESERVATIONS

were taken from given tables.

Available to Transact = Quantity On Hand - Pending Transactions - Reservations

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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