Query to Derive Freight Carrier Information for a Delivery
SELECT wlok.meaning status,
FROM wsh_lookups wlok,
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.
Share great information about your blog , Blog really helpful for us . Shipping from China to USReplyDelete
I got some valuable points through this blog. Shipping from China to USReplyDelete
It’s great to come across a blog. as we provide Air Freight Forwarders at affordable prices. for more info visit our website.ReplyDelete
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 AustraliaReplyDelete
I read that Post and got it fine and informative. https://europa-road.eu/ nemzetközi szállítmányozásReplyDelete