744: , rac.party_number
745: FROM
746: OE_ORDER_HEADERS_ALL ooha
747: , OE_ORDER_LINES_ALL oola
748: , HZ_PARTIES rac
749: , HZ_CUST_ACCOUNTS hzc
750: , MTL_SYSTEM_ITEMS si
751: --, CST_ITEM_COSTS_FOR_GL_VIEW cst
752: WHERE ooha.header_id = oola.header_id
1689: , wsh_delivery_assignments_v wda
1690: , WSH_DELIVERY_DETAILS_OB_GRP_V wdd
1691: , OE_ORDER_HEADERS_ALL ooha
1692: , OE_ORDER_LINES_ALL oola
1693: , HZ_PARTIES rac
1694: , HZ_CUST_ACCOUNTS hzc
1695: WHERE wnd.delivery_id = wda.delivery_id
1696: AND wda.delivery_detail_id = wdd.delivery_detail_id
1697: AND wdd.source_line_id = oola.line_id