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_TL_RATING dependencies on WSH_TRIP_STOPS

Line 14: FROM WSH_TRIP_STOPS s

10: x_return_status OUT NOCOPY VARCHAR2)
11: IS
12: CURSOR get_trip_stops(c_trip_id IN NUMBER) IS
13: SELECT s.stop_id
14: FROM WSH_TRIP_STOPS s
15: WHERE s.trip_id=c_trip_id
16: ORDER BY s.stop_sequence_number;
17:
18:

Line 78: UPDATE wsh_trip_stops

74: THEN
75: l_distances(2):=0;
76:
77: FORALL i IN l_distances.FIRST..l_distances.LAST
78: UPDATE wsh_trip_stops
79: SET distance_to_next_stop = l_distances(i),
80: distance_uom = l_distance_uom
81: WHERE stop_id = l_stop_ids(i);
82:

Line 483: wsh_trip_stops s

479:
480: CURSOR lock_dlegs( c_trip_id IN NUMBER ) IS
481: SELECT dl.reprice_required
482: FROM wsh_delivery_legs dl ,
483: wsh_trip_stops s
484: WHERE dl.pick_up_stop_id = s.stop_id
485: and s.trip_id=c_trip_id
486: FOR UPDATE NOWAIT;
487:

Line 512: (select s.stop_id FROM wsh_trip_stops s where

508:
509: UPDATE wsh_delivery_legs dl
510: SET dl.reprice_required='N'
511: WHERE dl.pick_up_stop_id IN
512: (select s.stop_id FROM wsh_trip_stops s where
513: s.trip_id=p_trip_id );
514:
515: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Update_Pricing_Required_Flag');
516:

Line 567: wsh_trip_stops wts1,

563: )
564: AND wd.delivery_id in
565: (SELECT wdl.delivery_id
566: FROM wsh_delivery_legs wdl,
567: wsh_trip_stops wts1,
568: wsh_trip_stops wts2
569: WHERE wts1.trip_id = c_trip_id
570: AND wts2.trip_id = c_trip_id
571: AND wts1.stop_id = wdl.pick_up_stop_id

Line 568: wsh_trip_stops wts2

564: AND wd.delivery_id in
565: (SELECT wdl.delivery_id
566: FROM wsh_delivery_legs wdl,
567: wsh_trip_stops wts1,
568: wsh_trip_stops wts2
569: WHERE wts1.trip_id = c_trip_id
570: AND wts2.trip_id = c_trip_id
571: AND wts1.stop_id = wdl.pick_up_stop_id
572: AND wts2.stop_id = wdl.drop_off_stop_id

Line 590: wsh_trip_stops wts1,

586: AND b.carrier_manifesting_flag = 'Y'
587: AND a.delivery_id in
588: (SELECT wdl.delivery_id
589: FROM wsh_delivery_legs wdl,
590: wsh_trip_stops wts1,
591: wsh_trip_stops wts2
592: WHERE wts1.trip_id = c_trip_id
593: AND wts2.trip_id = c_trip_id
594: AND wts1.stop_id = wdl.pick_up_stop_id

Line 591: wsh_trip_stops wts2

587: AND a.delivery_id in
588: (SELECT wdl.delivery_id
589: FROM wsh_delivery_legs wdl,
590: wsh_trip_stops wts1,
591: wsh_trip_stops wts2
592: WHERE wts1.trip_id = c_trip_id
593: AND wts2.trip_id = c_trip_id
594: AND wts1.stop_id = wdl.pick_up_stop_id
595: AND wts2.stop_id = wdl.drop_off_stop_id

Line 625: wsh_trip_stops wts1,

621: )
622: AND wd.delivery_id in
623: (SELECT wdl.delivery_id
624: FROM wsh_delivery_legs wdl,
625: wsh_trip_stops wts1,
626: wsh_trip_stops wts2
627: WHERE wts1.trip_id IN (SELECT m.trip_id from fte_trip_moves m where m.move_id= c_move_id)
628: AND wts2.trip_id = wts1.trip_id
629: AND wts1.stop_id = wdl.pick_up_stop_id

Line 626: wsh_trip_stops wts2

622: AND wd.delivery_id in
623: (SELECT wdl.delivery_id
624: FROM wsh_delivery_legs wdl,
625: wsh_trip_stops wts1,
626: wsh_trip_stops wts2
627: WHERE wts1.trip_id IN (SELECT m.trip_id from fte_trip_moves m where m.move_id= c_move_id)
628: AND wts2.trip_id = wts1.trip_id
629: AND wts1.stop_id = wdl.pick_up_stop_id
630: AND wts2.stop_id = wdl.drop_off_stop_id

Line 648: wsh_trip_stops wts1,

644: AND b.carrier_manifesting_flag = 'Y'
645: AND a.delivery_id in
646: (SELECT wdl.delivery_id
647: FROM wsh_delivery_legs wdl,
648: wsh_trip_stops wts1,
649: wsh_trip_stops wts2
650: WHERE wts1.trip_id IN (SELECT m.trip_id from fte_trip_moves m where m.move_id=c_move_id)
651: AND wts2.trip_id = wts1.trip_id
652: AND wts1.stop_id = wdl.pick_up_stop_id

Line 649: wsh_trip_stops wts2

645: AND a.delivery_id in
646: (SELECT wdl.delivery_id
647: FROM wsh_delivery_legs wdl,
648: wsh_trip_stops wts1,
649: wsh_trip_stops wts2
650: WHERE wts1.trip_id IN (SELECT m.trip_id from fte_trip_moves m where m.move_id=c_move_id)
651: AND wts2.trip_id = wts1.trip_id
652: AND wts1.stop_id = wdl.pick_up_stop_id
653: AND wts2.stop_id = wdl.drop_off_stop_id

Line 1065: wsh_trip_stops s

1061: s.trip_id,
1062: dl.pick_up_stop_id,
1063: dl.drop_off_stop_id
1064: FROM wsh_delivery_legs dl,
1065: wsh_trip_stops s
1066: WHERE dl.drop_off_stop_id = s.stop_id and
1067: dl.delivery_leg_id=c_dleg_id;
1068:
1069:

Line 1476: FROM wsh_trip_stops s

1472: FOR UPDATE NOWAIT;
1473:
1474: CURSOR get_stops(c_trip_id IN NUMBER ) IS
1475: SELECT s.stop_id
1476: FROM wsh_trip_stops s
1477: WHERE s.trip_id= c_trip_id;
1478:
1479:
1480: CURSOR lock_stop_rec(c_stop_id IN NUMBER ) IS

Line 1491: SELECT dl.delivery_leg_id FROM wsh_delivery_legs dl , wsh_trip_stops s

1487:
1488:
1489: CURSOR get_dlegs(c_trip_id IN NUMBER) IS
1490:
1491: SELECT dl.delivery_leg_id FROM wsh_delivery_legs dl , wsh_trip_stops s
1492: WHERE dl.pick_up_stop_id=s.stop_id and s.trip_id=p_trip_id;
1493:
1494: CURSOR lock_detail_recs(c_trip_id IN NUMBER) IS
1495: SELECT wfc.freight_cost_id

Line 1498: wsh_trip_stops s

1494: CURSOR lock_detail_recs(c_trip_id IN NUMBER) IS
1495: SELECT wfc.freight_cost_id
1496: FROM wsh_freight_costs wfc,
1497: wsh_delivery_legs dl ,
1498: wsh_trip_stops s
1499: WHERE wfc.delivery_leg_id = dl.delivery_leg_id
1500: and dl.pick_up_stop_id=s.stop_id
1501: and s.trip_id=c_trip_id
1502: and wfc.charge_source_code='PRICING_ENGINE'

Line 1698: wsh_trip_stops s

1694:
1695: CURSOR get_dlegs_to_be_priced(c_trip_id IN NUMBER) IS
1696: SELECT dl.delivery_leg_id
1697: FROM wsh_delivery_legs dl ,
1698: wsh_trip_stops s
1699: WHERE dl.pick_up_stop_id = s.stop_id
1700: and s.trip_id=c_trip_id
1701: and ( NVL(dl.reprice_required,'Y') = 'Y');
1702:

Line 1707: wsh_trip_stops s

1703:
1704: CURSOR get_move_dlegs_to_be_priced(c_move_id IN NUMBER) IS
1705: SELECT dl.delivery_leg_id
1706: FROM wsh_delivery_legs dl ,
1707: wsh_trip_stops s
1708: WHERE
1709: s.trip_id IN (
1710: SELECT m.trip_id from fte_trip_moves m where m.move_id=c_move_id
1711: )