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_TRIPS

Line 128: FROM wsh_trips

124: --
125: CURSOR get_trip_segment_cur
126: IS
127: SELECT name
128: FROM wsh_trips
129: WHERE trip_id = p_trip_segment_id;
130: --}
131: BEGIN
132: --{

Line 176: FROM fte_wsh_trips a, wsh_trips b

172: --{
173: CURSOR check_other_segments_cur
174: IS
175: SELECT 1
176: FROM fte_wsh_trips a, wsh_trips b
177: WHERE a.fte_trip_id = p_trip_id
178: AND a.wsh_trip_id <> p_trip_segment_id
179: AND a.wsh_trip_id = b.trip_id
180: AND b.status_code IN ('OP','IT');

Line 225: FROM fte_wsh_trips

221: --
222: CURSOR get_next_segment_cur
223: IS
224: SELECT wsh_trip_id
225: FROM fte_wsh_trips
226: WHERE fte_trip_id = p_trip_id
227: AND sequence_number = ( select min(sequence_number)
228: from fte_wsh_trips
229: where fte_trip_id = p_trip_id

Line 228: from fte_wsh_trips

224: SELECT wsh_trip_id
225: FROM fte_wsh_trips
226: WHERE fte_trip_id = p_trip_id
227: AND sequence_number = ( select min(sequence_number)
228: from fte_wsh_trips
229: where fte_trip_id = p_trip_id
230: and sequence_number > p_sequence_number );
231: --}
232: BEGIN

Line 338: FROM fte_wsh_trips

334: --
335: CURSOR get_previous_segment_cur
336: IS
337: SELECT wsh_trip_id
338: FROM fte_wsh_trips
339: WHERE fte_trip_id = p_trip_id
340: AND sequence_number = ( select max(sequence_number)
341: from fte_wsh_trips
342: where fte_trip_id = p_trip_id

Line 341: from fte_wsh_trips

337: SELECT wsh_trip_id
338: FROM fte_wsh_trips
339: WHERE fte_trip_id = p_trip_id
340: AND sequence_number = ( select max(sequence_number)
341: from fte_wsh_trips
342: where fte_trip_id = p_trip_id
343: and sequence_number < p_sequence_number );
344: --}
345: BEGIN

Line 816: p_trip_segment_rec IN WSH_TRIPS_PVT.Trip_Rec_Type,

812: --
813: PROCEDURE check_next_segment
814: (
815: p_trip_id IN NUMBER,
816: p_trip_segment_rec IN WSH_TRIPS_PVT.Trip_Rec_Type,
817: p_sequence_number IN NUMBER,
818: p_last_stop_location_id IN NUMBER DEFAULT NULL,
819: x_trip_name IN OUT NOCOPY VARCHAR2,
820: x_connected OUT NOCOPY BOOLEAN,

Line 1060: p_trip_segment_rec IN WSH_TRIPS_PVT.Trip_Rec_Type,

1056: --
1057: PROCEDURE check_previous_segment
1058: (
1059: p_trip_id IN NUMBER,
1060: p_trip_segment_rec IN WSH_TRIPS_PVT.Trip_Rec_Type,
1061: p_sequence_number IN NUMBER,
1062: p_first_stop_location_id IN NUMBER DEFAULT NULL,
1063: x_trip_name IN OUT NOCOPY VARCHAR2,
1064: x_connected OUT NOCOPY BOOLEAN,

Line 1099: P_trip_segment_rec IN WSH_TRIPS_GRP.Trip_Pub_Rec_Type

1095: --
1096: --
1097: FUNCTION segment_has_intransit_dlvy
1098: (
1099: P_trip_segment_rec IN WSH_TRIPS_GRP.Trip_Pub_Rec_Type
1100: )
1101: RETURN BOOLEAN
1102: IS
1103: --{

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 1694: FROM wsh_trips

1690: -- cursor to get the contact id from the trip table
1691: CURSOR get_contact_id_cur (c_tender_number NUMBER)
1692: IS
1693: SELECT carrier_contact_id
1694: FROM wsh_trips
1695: WHERE load_tender_number = c_tender_number;
1696: ---
1697: --Cursor to get the contact information
1698: CURSOR get_contact_info_cur (c_contact_id NUMBER)

Line 1885: wsh_trips trips

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
1889: AND stops.trip_id = trips.trip_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 2133: wsh_trips

2129: --{
2130: CURSOR get_carrier_id_cur(tender_id NUMBER) IS
2131: SELECT carrier_id
2132: FROM
2133: wsh_trips
2134: where load_tender_number = tender_id;
2135:
2136: l_carrier_id NUMBER;
2137:

Line 2519: WSH_CARRIERS car, wsh_trips trips

2515: SELECT decode(sites.supplier_site_id,null,car.supplier_site_id,
2516: sites.supplier_site_id), car.currency_code
2517: FROM WSH_ORG_CARRIER_SITES org_sites,
2518: WSH_CARRIER_SITES sites,
2519: WSH_CARRIERS car, wsh_trips trips
2520: WHERE org_sites.ORGANIZATION_ID = l_organization_id
2521: AND sites.carrier_site_id = org_sites.carrier_site_id
2522: AND sites.carrier_id = car.carrier_id
2523: AND car.CARRIER_ID = trips.carrier_id

Line 2616: FROM WSH_TRIPS

2612: THEN
2613: l_carrier_id := p_carrier_id;
2614: ELSE
2615: SELECT CARRIER_ID INTO l_carrier_id
2616: FROM WSH_TRIPS
2617: WHERE TRIP_ID = p_entity_id;
2618: END IF;
2619:
2620: END IF;

Line 2851: WSH_CARRIERS car, wsh_trips trips

2847: sites.supplier_site_id), car.currency_code,
2848: car.supplier_id,sites.carrier_site_id
2849: FROM WSH_ORG_CARRIER_SITES org_sites,
2850: WSH_CARRIER_SITES sites,
2851: WSH_CARRIERS car, wsh_trips trips
2852: WHERE org_sites.ORGANIZATION_ID = l_organization_id
2853: AND sites.carrier_site_id = org_sites.carrier_site_id
2854: AND sites.carrier_id = car.carrier_id
2855: AND car.CARRIER_ID = trips.carrier_id

Line 3165: FROM WSH_TRIPS

3161: RAISE FND_API.G_EXC_ERROR;
3162: END IF;
3163:
3164: SELECT shipments_type_flag INTO l_typeflag
3165: FROM WSH_TRIPS
3166: WHERE TRIP_ID = p_trip_id;
3167:
3168:
3169: IF (l_typeflag = 'O' OR l_typeflag = 'M')

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;