APPS.WSH_MBOLS_PVT dependencies on WSH_CARRIERS

Line 27: wsh_carriers wc

23: wc.freight_code
24: FROM
25: wsh_trips wt,
26: wsh_carrier_services wcs,
27: wsh_carriers wc
28: WHERE
29: wt.ship_method_code = wcs.ship_method_code(+) AND
30: wcs.carrier_id = wc.carrier_id(+) AND
31: trip_id = l_trip_id;

Line 41: l_freight_code WSH_CARRIERS.FREIGHT_CODE%TYPE;

37: AND entity_id = l_trip_id
38: AND status <> 'CANCELLED';
39:
40: l_trip_name WSH_TRIPS.NAME%TYPE;
41: l_freight_code WSH_CARRIERS.FREIGHT_CODE%TYPE;
42: l_document_number WSH_DOCUMENT_INSTANCES.SEQUENCE_NUMBER%TYPE;
43: l_ledger_id NUMBER; -- LE Uptake
44: l_msg_count NUMBER;
45: l_msg_data VARCHAR2(2000);