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.