eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WSH_NEW_DELIVERY_ACTIONS dependencies on STANDARD

Line 10384: AND d1.delivery_type = 'STANDARD'

10380: WHERE d1.delivery_id <> l_delivery_id
10381: AND s1.stop_id = dl1.pick_up_stop_id
10382: AND d1.delivery_id = dl1.delivery_id
10383: AND d1.status_code = 'OP'
10384: AND d1.delivery_type = 'STANDARD'
10385: AND s2.trip_id = s1.trip_id
10386: AND s2.stop_id = dl2.pick_up_stop_id
10387: AND dl2.delivery_id = l_delivery_id
10388: AND rownum = 1;

Line 10743: IF p_delivery_type = 'STANDARD' THEN

10739: wsh_debug_sv.push (l_module_name);
10740: END IF;
10741: --
10742:
10743: IF p_delivery_type = 'STANDARD' THEN
10744:
10745: OPEN c_get_ship_to_site;
10746: FETCH c_get_ship_to_site BULK COLLECT INTO l_site_tab;
10747: CLOSE c_get_ship_to_site;

Line 12998: -- make sure that the delivery is open, STANDARD and

12994: and d.delivery_type = 'CONSOLIDATION'
12995: and s1.trip_id = t.trip_id ;
12996:
12997:
12998: -- make sure that the delivery is open, STANDARD and
12999: -- is not assigned to a parent delivery.
13000: cursor c_check_valid_child(p_delivery_id in number) is
13001: select d.delivery_id
13002: from wsh_new_deliveries d

Line 13005: and d.delivery_type = 'STANDARD'

13001: select d.delivery_id
13002: from wsh_new_deliveries d
13003: where d.delivery_id = p_delivery_id
13004: and d.status_code = 'OP'
13005: and d.delivery_type = 'STANDARD'
13006: and not exists (select 1 from wsh_delivery_legs
13007: where parent_delivery_leg_id is not null
13008: and delivery_id = d.delivery_id);
13009: -- check if the delivery is assigned to a trip