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_TP_RELEASE_INT dependencies on WSH_DELIVERY_LEGS

Line 1836: FROM wsh_delivery_legs wdl,

1832: wts_do.physical_stop_id do_physical_stop_id,
1833: wts_do.planned_arrival_date do_planned_arrival_date,
1834: wts_do.planned_departure_date do_planned_departure_date,
1835: wts_do.wv_frozen_flag do_wv_flag
1836: FROM wsh_delivery_legs wdl,
1837: wsh_trip_stops wts_pu,
1838: wsh_trip_stops wts_do,
1839: wsh_trips wt
1840: WHERE wdl.delivery_id = p_delivery_id

Line 3771: wsh_delivery_legs_pvt.lock_dlvy_leg_no_compare(

3767: IF x_plan_deliveries(l_plan_del_index).delivery_id IS NOT NULL THEN
3768:
3769: -- lock legs in this delivery
3770: BEGIN
3771: wsh_delivery_legs_pvt.lock_dlvy_leg_no_compare(
3772: p_delivery_id => x_plan_deliveries(l_plan_del_index).delivery_id);
3773: EXCEPTION
3774: WHEN OTHERS THEN
3775: stamp_interface_error(

Line 4763: from wsh_delivery_legs wdl,

4759: -- delivery does not have its wv frozen.
4760: -- Used when unassigning from delivery.
4761: cursor c_check_del_stop_wv_frozen(p_delivery_id in number) IS
4762: select wts.stop_id, wts.stop_location_id
4763: from wsh_delivery_legs wdl,
4764: wsh_trip_stops wts,
4765: wsh_trip_stops wtspu,
4766: wsh_trip_stops wtsdo
4767: where wdl.delivery_id = p_delivery_id

Line 6587: from wsh_delivery_legs wdl,

6583: select wdl.delivery_leg_id,
6584: wdl.pick_up_stop_id,
6585: wdl.drop_off_stop_id,
6586: wts.trip_id
6587: from wsh_delivery_legs wdl,
6588: wsh_trip_stops wts
6589: where wdl.delivery_id = p_del_id
6590: and wts.stop_id = wdl.pick_up_stop_id;
6591:

Line 6604: wsh_delivery_legs l

6600: cursor c_initial_pu_date (p_delivery_id in number,
6601: p_init_pu_loc_id in number) is
6602: select s.planned_departure_date
6603: from wsh_trip_stops s,
6604: wsh_delivery_legs l
6605: where s.stop_location_id = p_init_pu_loc_id
6606: and s.stop_id = l.pick_up_stop_id
6607: and l.delivery_id = p_delivery_id;
6608:

Line 6614: wsh_delivery_legs l

6610: cursor c_final_do_date(p_delivery_id in number,
6611: p_ult_do_loc_id in number) is
6612: select s.planned_arrival_date
6613: from wsh_trip_stops s,
6614: wsh_delivery_legs l
6615: where s.stop_location_id = p_ult_do_loc_id
6616: and s.stop_id = l.drop_off_stop_id
6617: and l.delivery_id = p_delivery_id;
6618:

Line 6625: wsh_delivery_legs l

6621: cursor c_final_do_date_dummy(p_delivery_id in number,
6622: p_ult_do_loc_id in number) is
6623: select s.planned_arrival_date
6624: from wsh_trip_stops s,
6625: wsh_delivery_legs l
6626: where s.stop_location_id = p_ult_do_loc_id
6627: and s.stop_id = l.drop_off_stop_id
6628: and l.delivery_id = p_delivery_id
6629: and s.physical_stop_id IS NOT NULL

Line 6634: wsh_delivery_legs l

6630: UNION
6631: select phys_s.planned_arrival_date
6632: from wsh_trip_stops s,
6633: wsh_trip_stops phys_s,
6634: wsh_delivery_legs l
6635: where s.stop_location_id = p_ult_do_loc_id
6636: and s.stop_id = l.drop_off_stop_id
6637: and l.delivery_id = p_delivery_id
6638: and phys_s.stop_id = s.physical_stop_id

Line 6669: FROM WSH_DELIVERY_LEGS wdl,

6665:
6666: -- check if trip has deliveries assigned.
6667: CURSOR c_exist_dels(p_trip_id NUMBER) IS
6668: SELECT wdl.delivery_leg_id
6669: FROM WSH_DELIVERY_LEGS wdl,
6670: WSH_TRIP_STOPS wts
6671: WHERE wdl.pick_up_stop_id = wts.stop_id
6672: AND wts.trip_id = p_trip_id
6673: AND rownum = 1

Line 6676: FROM WSH_DELIVERY_LEGS wdl,

6672: AND wts.trip_id = p_trip_id
6673: AND rownum = 1
6674: UNION
6675: SELECT wdl.delivery_leg_id
6676: FROM WSH_DELIVERY_LEGS wdl,
6677: WSH_TRIP_STOPS wts
6678: WHERE wdl.drop_off_stop_id = wts.stop_id
6679: AND wts.trip_id = p_trip_id
6680: AND rownum = 1;

Line 6761: FROM WSH_DELIVERY_LEGS wdl

6757: p_trip_id IN NUMBER) IS
6758: -- check if stop has any delivery to pick up or drop off
6759: CURSOR c_stop_dels(p_stop_id NUMBER) IS
6760: SELECT wdl.delivery_leg_id
6761: FROM WSH_DELIVERY_LEGS wdl
6762: WHERE wdl.pick_up_stop_id = p_stop_id
6763: AND rownum = 1
6764: UNION
6765: SELECT wdl.delivery_leg_id

Line 6766: FROM WSH_DELIVERY_LEGS wdl

6762: WHERE wdl.pick_up_stop_id = p_stop_id
6763: AND rownum = 1
6764: UNION
6765: SELECT wdl.delivery_leg_id
6766: FROM WSH_DELIVERY_LEGS wdl
6767: WHERE wdl.drop_off_stop_id = p_stop_id
6768: AND rownum = 1;
6769:
6770: l_temp_id NUMBER;

Line 8900: FROM wsh_delivery_legs l,

8896: SELECT l.delivery_id,
8897: d.organization_id,
8898: l.pick_up_stop_id,
8899: l.drop_off_stop_id
8900: FROM wsh_delivery_legs l,
8901: wsh_new_deliveries d
8902: WHERE l.pick_up_stop_id = p_stop_id
8903: AND d.delivery_id = l.delivery_id
8904: UNION

Line 8909: FROM wsh_delivery_legs l,

8905: SELECT l.delivery_id,
8906: d.organization_id,
8907: l.pick_up_stop_id,
8908: l.drop_off_stop_id
8909: FROM wsh_delivery_legs l,
8910: wsh_new_deliveries d
8911: WHERE l.drop_off_stop_id = p_stop_id
8912: AND d.delivery_id = l.delivery_id;
8913: