APPS.FTE_TL_RATING dependencies on WSH_DELIVERY_LEGS

Line 482: FROM wsh_delivery_legs dl ,

478: x_return_status OUT NOCOPY VARCHAR2) IS
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;

Line 509: UPDATE wsh_delivery_legs dl

505: OPEN lock_dlegs(p_trip_id);
506: FETCH lock_dlegs INTO l_temp_rec;
507: CLOSE lock_dlegs;
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 );

Line 566: FROM wsh_delivery_legs wdl,

562: )
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

Line 589: FROM wsh_delivery_legs wdl,

585: AND c.manifesting_enabled_flag = 'Y'
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

Line 624: FROM wsh_delivery_legs wdl,

620: )
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

Line 647: FROM wsh_delivery_legs wdl,

643: AND c.manifesting_enabled_flag = 'Y'
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

Line 1064: FROM wsh_delivery_legs dl,

1060: SELECT dl.delivery_id,
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:

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 1497: wsh_delivery_legs dl ,

1493:
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

Line 1697: FROM wsh_delivery_legs dl ,

1693: x_return_status OUT NOCOPY VARCHAR2) IS
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');

Line 1706: FROM wsh_delivery_legs dl ,

1702:
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