SQL for BIll to and Ship To Contact name from Sales Order — Cloud Customer Connect
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

SQL for BIll to and Ship To Contact name from Sales Order

Hello,

What is the SQL used in the OTBI model for SELECT
"Distributed Order Orchestration - Order Headers Real Time"."Bill-to Contact"."Related Party Name" s_1,
"Distributed Order Orchestration - Order Headers Real Time"."Orchestration Orders Details"."Order Number" s_2,
"Distributed Order Orchestration - Order Headers Real Time"."Ship-to Contact"."Related Party Name" s_3
FROM "Distributed Order Orchestration - Order Headers Real Time" ?

The OTBI is getting the correct data, but when I try to do joins to the DOO_ORDER_ADDRESSES_V table, I am unable to get the Bill to Contact name (it didn't JOIN to any table I could find either HZ_PARTIES or HZ_RELATIONSHIPS), but I was able to join the Ship to contact using the HZ_RELATIONSHIPS table.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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