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,
     wnd.ship_method_code,
         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     wnd.name = :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.

6 comments:

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

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

    ReplyDelete
  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

    ReplyDelete
  4. I read that Post and got it fine and informative. https://europa-road.eu/ nemzetközi szállítmányozás

    ReplyDelete
  5. I definitely enjoy this. It is a great website and has a nice article. I want to thank you. Good job! You guys do a great blog, Keep up the good work.Freight Brokers Brisbane

    ReplyDelete