wc.manifesting_enabled_flag, wc.currency_code, hp.party_name,
DECODE (hpu.party_id, NULL, 'I', 'A'), hpu.party_usg_assignment_id,
wc.attribute_category, wc.attribute1, wc.attribute2, wc.attribute3,
wc.attribute4, wc.attribute5, wc.attribute6, wc.attribute7,
wc.attribute8, wc.attribute9, wc.attribute10, wc.attribute11,
wc.attribute12, wc.attribute13, wc.attribute14, wc.attribute15,
wc.creation_date, wc.created_by, wc.last_update_date,
wc.last_updated_by, wc.last_update_login,
wc.max_num_stops_permitted, wc.max_total_distance,
wc.max_total_time, wc.allow_intersperse_load, wc.max_layover_time,
wc.min_layover_time, wc.max_total_distance_in_24hr,
wc.max_driving_time_in_24hr, wc.max_duty_time_in_24hr,
wc.allow_continuous_move, wc.max_cm_distance, wc.max_cm_time,
wc.max_cm_dh_distance, wc.max_cm_dh_time, wc.max_size_width,
wc.max_size_height, wc.max_size_length, wc.min_size_width,
wc.min_size_height, wc.min_size_length, wc.time_uom,
wc.dimension_uom, wc.distance_uom, wc.max_out_of_route,
wc.cm_free_dh_mileage, wc.min_cm_distance,
wc.cm_first_load_discount, wc.min_cm_time, wc.unit_rate_basis,
wc.weight_uom, wc.volume_uom, wc.generic_flag,
wc.freight_bill_auto_approval, wc.freight_audit_line_level,
wc.supplier_id, wc.supplier_site_id, wc.cm_rate_variant,
wc.distance_calculation_method, wc.origin_dstn_surcharge_level,
wc.dim_dimensional_factor, wc.dim_weight_uom, wc.dim_volume_uom,
wc.dim_dimension_uom, wc.dim_min_pack_vol
FROM hz_parties hp, wsh_carriers wc, hz_party_usg_assignments hpu
WHERE wc.carrier_id = hp.party_id
AND hp.party_id = hpu.party_id(+)
AND hpu.effective_end_date(+) = TO_DATE ('31/12/4712', 'DD/MM/RRRR')
AND hpu.party_usage_code(+) = 'TRANSPORTATION_PROVIDER';
