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

Key colimn for joining INV_RESERVATIONS and DOO_HEADERS_ALL

edited Apr 15, 2025 1:08AM in Inventory Management 1 comment

I would like to get data of Manage Reservations and Picks.
More specifically, I need order number, quantity, customer, and shipping status from demand tab.
According to the table definition documentation, It seems like I can combine them by header ID.
But also it says "OE_ORDER_HEADERS.HEADER_ID", not DOO_HEADERS_ALL.

question 1; what is the OE_ORDER_HEADERS ? I couldn't find document in Tables and Views for SCM.
question 2; How can I get order number without using OE_ORDER_HEADERS from INV_RESERVATIONS?
In my fusion development, it says there is no table or views "OE_ORDER_HEADERS".

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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