Search from 700 + Posts

Feb 17, 2011

Query to Derive Freight Carrier Information for a Delivery

Query to Derive Freight Carrier Information for a Delivery

SELECT wlok.meaning status,
     to_char(NULL) name,
         WSH_UTIL_CORE.get_location_description(wnd.initial_pickup_location_id,'CSZ') pickup_loc,
         hp.party_name carrier_name,
     to_char(NULL) bill_of_lading
  FROM     wsh_lookups wlok,
     wsh_new_deliveries wnd,
         hz_parties hp, hz_party_usg_assignments hpu
  WHERE = :v_delivery_name
  AND    hp.party_id(+) = wnd.carrier_id
  AND    hp.party_id = hpu.party_id(+)
  AND    hpu.party_usage_code(+) = 'TRANSPORTATION_PROVIDER'
  AND     wlok.lookup_type = 'DELIVERY_STATUS'
  AND     wlok.lookup_code = wnd.status_code
  AND    nvl(wnd.SHIPMENT_DIRECTION , 'O') IN ('O', 'IO')
  AND     wnd.status_code not in ('CL','IT');

Note - Please Note that Freight Carriers are Defined as Party in TCA.With Party Type = Organization.


  1. Share great information about your blog , Blog really helpful for us . Shipping from China to US

  2. It’s great to come across a blog. as we provide Air Freight Forwarders at affordable prices. for more info visit our website.

  3. There are different types of freight forwarder in the market that claim to offer real time tracking of your shipment. We are not talking about all, but a few of them, don’t share the status of shipment once shipment is loaded for the delivery. In this context this blog will turn out to be a great help. Here you have shared a query to derive the freight carrier information for the delivery. It is great help for the freight forwarders and their customers. Thanks for sharing it with us; we have got some valuable point from it regarding the selection of the freight forward partner for shipping from China to Australia

  4. I read that Post and got it fine and informative. nemzetközi szállítmányozás