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 10188: AND d1.delivery_type = 'STANDARD'

10184: WHERE d1.delivery_id <> l_delivery_id
10185: AND s1.stop_id = dl1.pick_up_stop_id
10186: AND d1.delivery_id = dl1.delivery_id
10187: AND d1.status_code = 'OP'
10188: AND d1.delivery_type = 'STANDARD'
10189: AND s2.trip_id = s1.trip_id
10190: AND s2.stop_id = dl2.pick_up_stop_id
10191: AND dl2.delivery_id = l_delivery_id
10192: AND rownum = 1;

Line 10547: IF p_delivery_type = 'STANDARD' THEN

10543: wsh_debug_sv.push (l_module_name);
10544: END IF;
10545: --
10546:
10547: IF p_delivery_type = 'STANDARD' THEN
10548:
10549: OPEN c_get_ship_to_site;
10550: FETCH c_get_ship_to_site BULK COLLECT INTO l_site_tab;
10551: CLOSE c_get_ship_to_site;

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

12797: and d.delivery_type = 'CONSOLIDATION'
12798: and s1.trip_id = t.trip_id ;
12799:
12800:
12801: -- make sure that the delivery is open, STANDARD and
12802: -- is not assigned to a parent delivery.
12803: cursor c_check_valid_child(p_delivery_id in number) is
12804: select d.delivery_id
12805: from wsh_new_deliveries d

Line 12808: and d.delivery_type = 'STANDARD'

12804: select d.delivery_id
12805: from wsh_new_deliveries d
12806: where d.delivery_id = p_delivery_id
12807: and d.status_code = 'OP'
12808: and d.delivery_type = 'STANDARD'
12809: and not exists (select 1 from wsh_delivery_legs
12810: where parent_delivery_leg_id is not null
12811: and delivery_id = d.delivery_id);
12812: -- check if the delivery is assigned to a trip