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

Joins for INV_RESERVATIONS table to find the demand details

edited Jul 1, 2024 8:35AM in Inventory Management 8 comments

Summary:

Hi Team,

As seen in Inventory Management → Manage Reservations and Picks SaaS cloud UI screen, I'm trying to write a query to find out all the reservations and their corresponding demand document details such as header & line number of the reservations created.

I was able to find the reservation details from the INV_RESERVATIONS table. However, I'm not able to find the tables to join the demand_source_header_id and demand_source_line_id columns in the inv_reservations table to get the demand document details. As far as I understand, the column description present in the Oracle documentation has joins specified for the EBS tables and not for the Fusion Cloud.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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