Query to find freight related info of order viz: freight carrier, ship method and service level

col shipping_method_code form a32
col carrier_name form a24

select
h.order_number,
h.shipping_method_code,
wc.carrier_name,
wcsm.SERVICE_LEVEL ,
wcsm.freight_code
from
wsh_carrier_ship_methods_v wcsm,
wsh_carriers_v wc,
oe_order_headers_all h
where h.order_number= 14463
and h.org_id = 204
and h.shipping_method_code = wcsm.ship_method_code(+)
and nvl(wcsm.organization_id(+),0) = 204 --Master Organization
and wcsm.freight_code = wc.freight_code(+)
order by h.order_number;