APPS.FTE_TL_CACHE dependencies on WSH_DELIVERY_LEGS

Line 4773: wsh_delivery_legs dl ,

4769: da.type,
4770: da.parent_delivery_id,
4771: dl.parent_delivery_leg_id
4772: FROM wsh_delivery_assignments da,
4773: wsh_delivery_legs dl ,
4774: wsh_delivery_details dd,
4775: wsh_trip_stops s
4776: WHERE da.delivery_id=dl.delivery_id and
4777: dl.pick_up_stop_id=s.stop_id and

Line 5276: wsh_delivery_legs dl ,

5272: da.type,
5273: da.parent_delivery_id,
5274: dl.parent_delivery_leg_id
5275: FROM wsh_delivery_assignments da,
5276: wsh_delivery_legs dl ,
5277: wsh_delivery_details dd
5278: WHERE da.delivery_id=dl.delivery_id and
5279: dl.pick_up_stop_id=c_pick_up_stop_id and
5280: da.delivery_detail_id = dd.delivery_detail_id and

Line 5288: exists ( select pdl.pick_up_stop_id from wsh_delivery_legs pdl where pdl.delivery_leg_id=dl.parent_delivery_leg_id and pdl.pick_up_stop_id=c_pick_up_stop_id and pdl.delivery_id=da.parent_delivery_id))

5284: ((da.type='O') and (da.parent_delivery_detail_id is null) and (dl.parent_delivery_leg_id is null))
5285: --MDC trip top level details of top level parent deliveries .If in these cases the type is made 'S' we would not need an extra clause.
5286: OR
5287: ( (da.type='C' ) and (dl.parent_delivery_leg_id is not null) and
5288: exists ( select pdl.pick_up_stop_id from wsh_delivery_legs pdl where pdl.delivery_leg_id=dl.parent_delivery_leg_id and pdl.pick_up_stop_id=c_pick_up_stop_id and pdl.delivery_id=da.parent_delivery_id))
5289: --MDC trip ,top level details of deliveries that have parents that are on the same trip
5290: )
5291: ORDER BY
5292: da.delivery_id;

Line 5338: wsh_delivery_legs dl ,

5334: da.type,
5335: da.parent_delivery_id,
5336: dl.parent_delivery_leg_id
5337: FROM wsh_delivery_assignments da,
5338: wsh_delivery_legs dl ,
5339: wsh_delivery_details dd
5340: WHERE da.delivery_id=dl.delivery_id and
5341: dl.drop_off_stop_id=c_drop_off_stop_id and
5342: da.delivery_detail_id = dd.delivery_detail_id and

Line 5351: exists ( select pdl.drop_off_stop_id from wsh_delivery_legs pdl where pdl.delivery_leg_id=dl.parent_delivery_leg_id and pdl.drop_off_stop_id=c_drop_off_stop_id and pdl.delivery_id=da.parent_delivery_id))

5347: ((da.type='O') and (da.parent_delivery_detail_id is null) and (dl.parent_delivery_leg_id is null))
5348: --MDC trip top level details of top level parent deliveries.If in these cases the type is made 'S' we would not need an extra clause.
5349: OR
5350: ( (da.type='C' ) and (dl.parent_delivery_leg_id is not null) and
5351: exists ( select pdl.drop_off_stop_id from wsh_delivery_legs pdl where pdl.delivery_leg_id=dl.parent_delivery_leg_id and pdl.drop_off_stop_id=c_drop_off_stop_id and pdl.delivery_id=da.parent_delivery_id))
5352: --MDC trip ,top level details of deliveries that have parents that are on the same trip
5353: )
5354: ORDER BY
5355: da.delivery_id;

Line 5494: FROM wsh_delivery_legs dl,

5490: 0,
5491: 0,
5492: null,
5493: null
5494: FROM wsh_delivery_legs dl,
5495: wsh_trip_stops s
5496: WHERE dl.drop_off_stop_id = s.stop_id and
5497: dl.pick_up_stop_id=c_pick_up_stop_id;
5498:

Line 7642: FROM wsh_delivery_legs dl

7638: 0,
7639: 0,
7640: null,
7641: null
7642: FROM wsh_delivery_legs dl
7643: WHERE dl.delivery_leg_id=c_dleg_id;
7644:
7645:
7646:

Line 7683: FROM wsh_delivery_legs dl,

7679: s.stop_id=c_stop_id;
7680:
7681: CURSOR get_trip_id_from_dleg(c_dleg_id IN NUMBER) IS
7682: SELECT s.trip_id
7683: FROM wsh_delivery_legs dl,
7684: wsh_trip_stops s
7685: WHERE dl.delivery_leg_id=c_dleg_id AND
7686: dl.pick_up_stop_id=s.stop_id;
7687:

Line 11738: wsh_delivery_legs dl ,

11734: da.type,
11735: da.parent_delivery_id,
11736: dl.parent_delivery_leg_id
11737: FROM wsh_delivery_assignments da,
11738: wsh_delivery_legs dl ,
11739: wsh_delivery_details dd,
11740: wsh_trip_stops s
11741: WHERE da.delivery_id=dl.delivery_id and
11742: s.trip_id=c_trip_id and