Inventory Items (APC/PLM/PIM) - EBS (MOSC)

MOSC Banner

Available to Reserve quantity in inventory.

edited Sep 17, 2015 10:06AM in Inventory Items (APC/PLM/PIM) - EBS (MOSC) 2 commentsAnswered

Hi ALL,

I am using below api to get Available to Reserve quantity.

But I need with  date wise also how can I pass date or is there any other way to fetch "Available to Reserve quantity".

if I give certain date up to that date should be show "Available to Reserve quantity".


Declare

x_return_status         VARCHAR2 (50);

   x_msg_count             VARCHAR2 (50);

   x_msg_data              VARCHAR2 (50);

   l_item_id               NUMBER;

   l_organization_id       NUMBER;

   l_qty_on_hand           NUMBER;

   l_res_qty_on_hand       NUMBER;

   l_avail_to_tnsct        NUMBER;

   l_avail_to_reserve      NUMBER;

   l_qty_reserved          NUMBER;

   l_qty_suggested         NUMBER;

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center