[Home] [Help]
21: SELECT
22: wt.name,
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
32:
33: CURSOR c_get_seq_num (l_trip_id NUMBER) IS
34: SELECT sequence_number
35: FROM wsh_document_instances
36: WHERE entity_name = 'WSH_TRIPS'
37: AND entity_id = l_trip_id
38: AND status <> 'CANCELLED';
39:
40: l_trip_name WSH_TRIPS.NAME%TYPE;
36: WHERE entity_name = 'WSH_TRIPS'
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;
180: , p_validation_level => NULL
181: , x_return_status => l_return_status
182: , x_msg_count => l_msg_count
183: , x_msg_data => l_msg_data
184: , p_entity_name => 'WSH_TRIPS'
185: , p_entity_id => p_trip_id
186: , p_application_id => 665
187: , p_location_id => NULL
188: , p_document_type => 'MBOL'
253: wt.name
254: FROM wsh_new_deliveries del,
255: wsh_delivery_legs dlg,
256: wsh_trip_stops st,
257: wsh_trips wt
258: WHERE del.delivery_id = dlg.delivery_id
259: AND dlg.pick_up_stop_id = st.stop_id
260: AND dlg.parent_delivery_leg_id IS NULL
261: AND st.trip_id = wt.trip_id
997: l_organization_id NUMBER;
998: l_first_delivery_id NUMBER;
999: cursor get_shipments_type_flag is
1000: select shipments_type_flag
1001: from wsh_trips
1002: where trip_id = p_trip_id;
1003:
1004: cursor locations_csr is
1005: select stop_location_id into l_location_id