72: hz_party_sites ps,
73: hz_locations loc,
74: aso_i_parties_v ip,
75: wsh_carrier_ship_methods csm,
76: fnd_lookup_values_vl fl
77: WHERE qh.quote_header_id = s.quote_header_id
78: and s.ship_to_party_site_id = ps.party_site_id(+)
79: and s.ship_to_cust_party_id = ip.party_id(+)
80: and ps.location_id = loc.location_id(+)