APPS.FTE_MLS_UTIL dependencies on WSH_DELIVERY_LEGS

Line 1108: wsh_delivery_legs WDL,

1104: CURSOR intransit_deliveries_cur
1105: IS
1106: SELECT 'x'
1107: FROM wsh_trip_stops WTS,
1108: wsh_delivery_legs WDL,
1109: wsh_new_deliveries WND
1110: WHERE WTS.trip_id = p_trip_segment_rec.trip_id
1111: AND WND.delivery_id = WDL.delivery_id
1112: AND WND.status_code IN ( 'IT', 'CL' )

Line 1150: wsh_delivery_legs WDL

1146: CURSOR deliveries_cur
1147: IS
1148: SELECT 'x'
1149: FROM wsh_trip_stops WTS,
1150: wsh_delivery_legs WDL
1151: WHERE WTS.trip_id = p_trip_segment_id
1152: AND WDL.delivery_id <> p_delivery_id
1153: AND (
1154: WDL.pick_up_stop_id = WTS.STOP_ID

Line 1214: FROM wsh_delivery_legs WDL,

1210: --{
1211: CURSOR intransit_deliveries_cur
1212: IS
1213: SELECT 'x'
1214: FROM wsh_delivery_legs WDL,
1215: wsh_new_deliveries WND
1216: WHERE WND.delivery_id = WDL.delivery_id
1217: AND WND.status_code IN ( 'IT', 'CL' )
1218: AND (

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 1843: FROM wsh_delivery_legs dlegs, wsh_new_deliveries dlvy,

1839:
1840: CURSOR get_org_info_cur (c_stop_id IN NUMBER)
1841: IS
1842: SELECT distinct(org.name) org_name
1843: FROM wsh_delivery_legs dlegs, wsh_new_deliveries dlvy,
1844: wsh_trip_stops stops, hr_organization_units org
1845: WHERE dlegs.delivery_id = dlvy.delivery_id
1846: AND dlegs.pick_up_stop_id = stops.stop_id
1847: AND org.organization_id = dlvy.organization_id

Line 1883: FROM wsh_delivery_legs dlegs, wsh_new_deliveries dlvy,

1879:
1880: CURSOR get_org_info_cur (c_trip_id IN NUMBER)
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

Line 1925: FROM wsh_delivery_legs dlegs, wsh_new_deliveries dlvy,

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

Line 3113: FROM WSH_TRIP_STOPS stops, WSH_DELIVERY_LEGS leg,

3109: AND trunc(sysdate) <= nvl( hou.date_to, trunc(sysdate));
3110:
3111: CURSOR GET_ORG_ID_BY_DELIVERY (l_stop_id NUMBER) IS
3112: SELECT dlvy.ORGANIZATION_ID
3113: FROM WSH_TRIP_STOPS stops, WSH_DELIVERY_LEGS leg,
3114: WSH_NEW_DELIVERIES dlvy
3115: WHERE stops.stop_id = leg.pick_up_stop_id
3116: AND leg.delivery_id = dlvy.delivery_id
3117: AND stops.stop_id = l_stop_id;