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.FTE_MLS_UTIL dependencies on WSH_TRIP_STOPS

Line 452: FROM wsh_trip_stops

448: p_segment_id IN NUMBER
449: )
450: IS
451: SELECT stop_id, stop_location_id
452: FROM wsh_trip_stops
453: WHERE trip_id = p_segment_id
454: AND stop_sequence_number = ( select min(stop_sequence_number)
455: from wsh_trip_stops
456: where trip_id = p_segment_id );

Line 455: from wsh_trip_stops

451: SELECT stop_id, stop_location_id
452: FROM wsh_trip_stops
453: WHERE trip_id = p_segment_id
454: AND stop_sequence_number = ( select min(stop_sequence_number)
455: from wsh_trip_stops
456: where trip_id = p_segment_id );
457: --}
458: BEGIN
459: --{

Line 535: FROM wsh_trip_stops

531: p_segment_id IN NUMBER
532: )
533: IS
534: SELECT stop_id, stop_location_id
535: FROM wsh_trip_stops
536: WHERE trip_id = p_segment_id
537: AND stop_sequence_number = ( select max(stop_sequence_number)
538: from wsh_trip_stops
539: where trip_id = p_segment_id );

Line 538: from wsh_trip_stops

534: SELECT stop_id, stop_location_id
535: FROM wsh_trip_stops
536: WHERE trip_id = p_segment_id
537: AND stop_sequence_number = ( select max(stop_sequence_number)
538: from wsh_trip_stops
539: where trip_id = p_segment_id );
540:
541: --}
542: BEGIN

Line 1107: FROM wsh_trip_stops WTS,

1103: --{
1104: CURSOR intransit_deliveries_cur
1105: IS
1106: SELECT 'x'
1107: FROM wsh_trip_stops WTS,
1108: wsh_delivery_legs WDL,
1109: wsh_new_deliveries WND
1110: WHERE WTS.trip_id = p_trip_segment_rec.trip_id
1111: AND WND.delivery_id = WDL.delivery_id

Line 1149: FROM wsh_trip_stops WTS,

1145: --{
1146: CURSOR deliveries_cur
1147: IS
1148: SELECT 'x'
1149: FROM wsh_trip_stops WTS,
1150: wsh_delivery_legs WDL
1151: WHERE WTS.trip_id = p_trip_segment_id
1152: AND WDL.delivery_id <> p_delivery_id
1153: AND (

Line 1180: P_trip_stop_rec IN WSH_TRIP_STOPS_GRP.Trip_stop_Pub_Rec_Type

1176: --
1177: --
1178: FUNCTION stop_has_intransit_dlvy
1179: (
1180: P_trip_stop_rec IN WSH_TRIP_STOPS_GRP.Trip_stop_Pub_Rec_Type
1181: )
1182: RETURN BOOLEAN
1183: IS
1184: --{

Line 1442: from wsh_delivery_legs wdl, wsh_trip_stops wts1, wsh_trip_stops wts2,wsh_trips wt

1438:
1439: CURSOR get_deliveries_cur(c_trip_segment_id NUMBER)
1440: IS
1441: Select delivery_leg_id
1442: from wsh_delivery_legs wdl, wsh_trip_stops wts1, wsh_trip_stops wts2,wsh_trips wt
1443: where wdl.pick_up_stop_id = wts1.stop_id
1444: and wdl.drop_off_stop_id = wts2.stop_id
1445: and wts1.trip_id = wt.trip_id
1446: and wts2.trip_id = wt.trip_id

Line 1844: wsh_trip_stops stops, hr_organization_units org

1840: CURSOR get_org_info_cur (c_stop_id IN NUMBER)
1841: IS
1842: SELECT distinct(org.name) org_name
1843: FROM wsh_delivery_legs dlegs, wsh_new_deliveries dlvy,
1844: wsh_trip_stops stops, hr_organization_units org
1845: WHERE dlegs.delivery_id = dlvy.delivery_id
1846: AND dlegs.pick_up_stop_id = stops.stop_id
1847: AND org.organization_id = dlvy.organization_id
1848: AND stops.stop_id = c_stop_id;

Line 1884: wsh_trip_stops stops, hr_organization_units org,

1880: CURSOR get_org_info_cur (c_trip_id IN NUMBER)
1881: IS
1882: SELECT distinct(org.name) org_name
1883: FROM wsh_delivery_legs dlegs, wsh_new_deliveries dlvy,
1884: wsh_trip_stops stops, hr_organization_units org,
1885: wsh_trips trips
1886: WHERE dlegs.delivery_id = dlvy.delivery_id
1887: AND dlegs.pick_up_stop_id = stops.stop_id
1888: AND org.organization_id = dlvy.organization_id

Line 1926: wsh_trip_stops stops, wsh_trips trips

1922: CURSOR get_org_info_cur (c_trip_id IN NUMBER)
1923: IS
1924: SELECT distinct(dlvy.organization_id) org_id
1925: FROM wsh_delivery_legs dlegs, wsh_new_deliveries dlvy,
1926: wsh_trip_stops stops, wsh_trips trips
1927: WHERE dlegs.delivery_id = dlvy.delivery_id
1928: AND dlegs.pick_up_stop_id = stops.stop_id
1929: AND stops.trip_id = trips.trip_id
1930: AND trips.trip_id = c_trip_id;

Line 3113: FROM WSH_TRIP_STOPS stops, WSH_DELIVERY_LEGS leg,

3109: AND trunc(sysdate) <= nvl( hou.date_to, trunc(sysdate));
3110:
3111: CURSOR GET_ORG_ID_BY_DELIVERY (l_stop_id NUMBER) IS
3112: SELECT dlvy.ORGANIZATION_ID
3113: FROM WSH_TRIP_STOPS stops, WSH_DELIVERY_LEGS leg,
3114: WSH_NEW_DELIVERIES dlvy
3115: WHERE stops.stop_id = leg.pick_up_stop_id
3116: AND leg.delivery_id = dlvy.delivery_id
3117: AND stops.stop_id = l_stop_id;

Line 3283: FROM wsh_trip_stops stops, wsh_trips trips

3279: --{
3280: CURSOR GET_TRIP_STOPS IS
3281: SELECT stop_location_id, planned_arrival_date, planned_departure_date ,
3282: stops.stop_id
3283: FROM wsh_trip_stops stops, wsh_trips trips
3284: WHERE trips.trip_id = p_trip_id
3285: and trips.trip_id = stops.trip_id
3286: ORDER BY PLANNED_ARRIVAL_DATE,
3287: STOP_SEQUENCE_NUMBER;