APPS.FTE_TRIPS_PVT dependencies on WSH_TRIP_STOPS

Line 746: from wsh_trip_stops

742: order by sequence_number;
743:
744: CURSOR trip_stops (l_wsh_trip_id IN NUMBER) IS
745: select stop_id, stop_location_id, stop_sequence_number
746: from wsh_trip_stops
747: where trip_id=l_wsh_trip_id
748: order by stop_sequence_number;
749:
750: l_trip_segments trip_segments%ROWTYPE;

Line 1043: from wsh_delivery_legs wdl, wsh_trip_stops wts

1039: l_noofrows BINARY_INTEGER;
1040:
1041: cursor c_dlegs(p_del_id NUMBER) is
1042: select delivery_leg_id
1043: from wsh_delivery_legs wdl, wsh_trip_stops wts
1044: where wdl.pick_up_stop_id = wts.stop_id
1045: and wts.trip_id = p_wsh_trip_id
1046: and wdl.delivery_id=p_del_id;
1047:

Line 1155: FROM wsh_trip_stops

1151: )
1152: IS
1153: SELECT stop_id, stop_location_id, stop_sequence_number,
1154: planned_departure_date,planned_arrival_date
1155: FROM wsh_trip_stops
1156: WHERE trip_id = p_trip_id
1157: AND stop_sequence_number = ( select max(stop_sequence_number)
1158: from wsh_trip_stops
1159: where trip_id = p_trip_id);

Line 1158: from wsh_trip_stops

1154: planned_departure_date,planned_arrival_date
1155: FROM wsh_trip_stops
1156: WHERE trip_id = p_trip_id
1157: AND stop_sequence_number = ( select max(stop_sequence_number)
1158: from wsh_trip_stops
1159: where trip_id = p_trip_id);
1160: --}
1161: BEGIN
1162: --{

Line 1241: FROM wsh_trip_stops

1237: )
1238: IS
1239: SELECT stop_id, stop_location_id, stop_sequence_number,
1240: planned_departure_date,planned_arrival_date
1241: FROM wsh_trip_stops
1242: WHERE trip_id = p_trip_id
1243: AND stop_sequence_number = ( select min(stop_sequence_number)
1244: from wsh_trip_stops
1245: where trip_id = p_trip_id);

Line 1244: from wsh_trip_stops

1240: planned_departure_date,planned_arrival_date
1241: FROM wsh_trip_stops
1242: WHERE trip_id = p_trip_id
1243: AND stop_sequence_number = ( select min(stop_sequence_number)
1244: from wsh_trip_stops
1245: where trip_id = p_trip_id);
1246: --}
1247: BEGIN
1248: --{

Line 1402: FROM wsh_trip_stops st,mtl_units_of_measure wt, mtl_units_of_measure vol

1398: departure_volume,volume_uom_code,
1399: wt.unit_of_measure_tl weight, vol.unit_of_measure_tl volume ,
1400: st.stop_id stopid,st.planned_arrival_date, st.planned_departure_date,
1401: st.stop_location_id
1402: FROM wsh_trip_stops st,mtl_units_of_measure wt, mtl_units_of_measure vol
1403: WHERE st.trip_id = c_trip_id
1404: AND wt.UOM_CODE (+)= st.weight_uom_code
1405: AND vol.UOM_CODE (+)= st.volume_uom_code
1406: order by st.stop_sequence_number;

Line 1415: wsh_trip_stops stops, org_organization_definitions org

1411: CURSOR get_org_info_cur (c_stop_id IN NUMBER)
1412: IS
1413: SELECT distinct(org.organization_name) org_name
1414: FROM wsh_delivery_legs dlegs, wsh_new_deliveries dlvy,
1415: wsh_trip_stops stops, org_organization_definitions org
1416: WHERE dlegs.delivery_id = dlvy.delivery_id
1417: AND dlegs.pick_up_stop_id = stops.stop_id
1418: AND org.organization_id = dlvy.organization_id
1419: AND stops.stop_id = c_stop_id;

Line 1455: SELECT count(*) INTO l_stop_count FROM WSH_TRIP_STOPS

1451: -- deliveries on it. the find the org name from there
1452: --
1453:
1454: -- first get the stop count
1455: SELECT count(*) INTO l_stop_count FROM WSH_TRIP_STOPS
1456: WHERE TRIP_ID = l_trip_id;
1457:
1458: l_found_first_stop := NULL;
1459:

Line 1626: FROM wsh_trip_stops wts, --t

1622: SELECT delivery_id, gross_weight, weight_uom_code, volume, volume_uom_code
1623: FROM wsh_new_deliveries
1624: WHERE delivery_id IN
1625: (SELECT distinct(wdl.delivery_id)
1626: FROM wsh_trip_stops wts, --t
1627: wsh_delivery_legs wdl --d
1628: WHERE wdl.pick_up_stop_id = wts.stop_id
1629: AND wts.trip_id = l_trip_id);
1630: --}