Search 800 + 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. 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
  2. I read that Post and got it fine and informative. https://europa-road.eu/ nemzetközi szállítmányozás

    ReplyDelete
  3. chicago frieght Awesome article, it was exceptionally helpful! I simply began in this and I'm becoming more acquainted with it better! Cheers, keep doing awesome!

    ReplyDelete
  4. Transcontinental shipping Awesome article, it was exceptionally helpful! I simply began in this and I'm becoming more acquainted with it better! Cheers, keep doing awesome!

    ReplyDelete
  5. This post is so helfull and attractive.keep updating with more information...
    Need For Data Science
    Data Science Uses

    ReplyDelete