27: , party.party_name --c.customer_name
28: , party.party_id --c.customer_id
29: , party.party_number--c.customer_number
30: FROM wsh_delivery_details wdd
31: , hz_parties party --ra_customers c
32: , hz_cust_accounts cust_acct
33: , oe_transaction_types_tl otl
34: , wsh_delivery_assignments_v wda
35: WHERE wdd.customer_id = party.party_id
54: , party.party_name --c.customer_name
55: , party.party_id --c.customer_id
56: , party.party_number--c.customer_number
57: FROM wsh_delivery_details wdd
58: , hz_parties party --ra_customers c
59: , hz_cust_accounts cust_acct
60: , oe_transaction_types_tl otl
61: , wsh_delivery_assignments_v wda
62: WHERE wdd.customer_id = party.party_id