To find Shipper info

select

wnd.delivery_id delivery_id,

substrb(party.party_name,1,50) customer,

wpb.name batch_name,

wsh_util_core.get_location_description(

wnd.INITIAL_PICKUP_LOCATION_ID,

'NEW UI CODE') ship_from,

wsh_util_core.get_location_description(

wnd.ULTIMATE_DROPOFF_LOCATION_ID,

'NEW UI CODE') ship_to,

wnd.INITIAL_PICKUP_DATE pickup_date,

wnd.ULTIMATE_DROPOFF_DATE dropoff_date,

lv.meaning ship_method,

wnd.WAYBILL waybill,

wnd.GROSS_WEIGHT gross_weight,

wnd.WEIGHT_UOM_CODE uom,

wnd.status_code,

we.message

from wsh_new_deliveries wnd,

wsh_picking_batches wpb,

wsh_exceptions we,

fnd_lookup_values_vl lv,

hz_cust_accounts cust_acct,

hz_parties party

where wnd.delivery_id = 12814

and wpb.batch_id = wnd.batch_id

and we.delivery_id(+) = wnd.delivery_id

and we.exception_name(+) = 'WSH_BATCH_MESSAGE'

and lv.lookup_code(+) = wpb.ship_method_code

and lv.lookup_type(+) = 'SHIP_METHOD'

and lv.view_application_id(+) = 3

and cust_acct.cust_account_id (+)=wnd.customer_id

and party.party_id(+) = cust_acct.party_id