APPS.WSH_WSHRDLAB_XMLP_PKG dependencies on WSH_DELIVERY_LEGS

Line 108: LP_TRIP_STOP_ID := 'AND wnd.delivery_id in (select distinct delivery_id from wsh_delivery_legs where (pick_up_stop_id =

104: LP_ORGANIZATION_ID := ' ';
105: END IF;
106:
107: IF P_TRIP_STOP_ID IS NOT NULL THEN
108: LP_TRIP_STOP_ID := 'AND wnd.delivery_id in (select distinct delivery_id from wsh_delivery_legs where (pick_up_stop_id =
109: :P_TRIP_STOP_ID OR drop_off_stop_id = :P_TRIP_STOP_ID ))';
110: END IF;
111: IF (LP_TRIP_STOP_ID IS NULL) THEN
112: LP_TRIP_STOP_ID := ' ';

Line 115: LP_TRIP_ID := 'AND wnd.delivery_id in (select distinct delivery_id from wsh_delivery_legs wdl , wsh_trip_stops wts

111: IF (LP_TRIP_STOP_ID IS NULL) THEN
112: LP_TRIP_STOP_ID := ' ';
113: END IF;
114: IF P_TRIP_ID IS NOT NULL THEN
115: LP_TRIP_ID := 'AND wnd.delivery_id in (select distinct delivery_id from wsh_delivery_legs wdl , wsh_trip_stops wts
116: where wdl.pick_up_stop_id = wts.stop_id and
117: wts.trip_id = :P_TRIP_ID )';
118: END IF;
119:

Line 129: LP_DATE_RANGE := 'AND wnd.delivery_id in (select distinct delivery_id from wsh_delivery_legs where pick_up_stop_id in (select stop_id from wsh_trip_stops where planned_departure_date <= :P_DEPARTURE_DATE_HIGH))';

125: CP_DEPARTURE_DATE_HIGH := P_DEPARTURE_DATE_HIGH + (86399 / 86400);
126: END IF;
127: IF P_DEPARTURE_DATE_LOW IS NOT NULL OR P_DEPARTURE_DATE_HIGH IS NOT NULL THEN
128: IF P_DEPARTURE_DATE_LOW IS NULL THEN
129: LP_DATE_RANGE := 'AND wnd.delivery_id in (select distinct delivery_id from wsh_delivery_legs where pick_up_stop_id in (select stop_id from wsh_trip_stops where planned_departure_date <= :P_DEPARTURE_DATE_HIGH))';
130: ELSIF P_DEPARTURE_DATE_HIGH IS NULL THEN
131: LP_DATE_RANGE := 'AND wnd.delivery_id in (select distinct delivery_id from wsh_delivery_legs where pick_up_stop_id in (select stop_id from wsh_trip_stops where planned_departure_date >= :P_DEPARTURE_DATE_LOW))';
132: ELSE
133: LP_DATE_RANGE := 'AND wnd.delivery_id in (select distinct delivery_id from wsh_delivery_legs where pick_up_stop_id in (select stop_id from wsh_trip_stops where planned_departure_date between :P_DEPARTURE_DATE_LOW and :P_DEPARTURE_DATE_HIGH))';

Line 131: LP_DATE_RANGE := 'AND wnd.delivery_id in (select distinct delivery_id from wsh_delivery_legs where pick_up_stop_id in (select stop_id from wsh_trip_stops where planned_departure_date >= :P_DEPARTURE_DATE_LOW))';

127: IF P_DEPARTURE_DATE_LOW IS NOT NULL OR P_DEPARTURE_DATE_HIGH IS NOT NULL THEN
128: IF P_DEPARTURE_DATE_LOW IS NULL THEN
129: LP_DATE_RANGE := 'AND wnd.delivery_id in (select distinct delivery_id from wsh_delivery_legs where pick_up_stop_id in (select stop_id from wsh_trip_stops where planned_departure_date <= :P_DEPARTURE_DATE_HIGH))';
130: ELSIF P_DEPARTURE_DATE_HIGH IS NULL THEN
131: LP_DATE_RANGE := 'AND wnd.delivery_id in (select distinct delivery_id from wsh_delivery_legs where pick_up_stop_id in (select stop_id from wsh_trip_stops where planned_departure_date >= :P_DEPARTURE_DATE_LOW))';
132: ELSE
133: LP_DATE_RANGE := 'AND wnd.delivery_id in (select distinct delivery_id from wsh_delivery_legs where pick_up_stop_id in (select stop_id from wsh_trip_stops where planned_departure_date between :P_DEPARTURE_DATE_LOW and :P_DEPARTURE_DATE_HIGH))';
134: END IF;
135: END IF;

Line 133: LP_DATE_RANGE := 'AND wnd.delivery_id in (select distinct delivery_id from wsh_delivery_legs where pick_up_stop_id in (select stop_id from wsh_trip_stops where planned_departure_date between :P_DEPARTURE_DATE_LOW and :P_DEPARTURE_DATE_HIGH))';

129: LP_DATE_RANGE := 'AND wnd.delivery_id in (select distinct delivery_id from wsh_delivery_legs where pick_up_stop_id in (select stop_id from wsh_trip_stops where planned_departure_date <= :P_DEPARTURE_DATE_HIGH))';
130: ELSIF P_DEPARTURE_DATE_HIGH IS NULL THEN
131: LP_DATE_RANGE := 'AND wnd.delivery_id in (select distinct delivery_id from wsh_delivery_legs where pick_up_stop_id in (select stop_id from wsh_trip_stops where planned_departure_date >= :P_DEPARTURE_DATE_LOW))';
132: ELSE
133: LP_DATE_RANGE := 'AND wnd.delivery_id in (select distinct delivery_id from wsh_delivery_legs where pick_up_stop_id in (select stop_id from wsh_trip_stops where planned_departure_date between :P_DEPARTURE_DATE_LOW and :P_DEPARTURE_DATE_HIGH))';
134: END IF;
135: END IF;
136: IF (LP_DATE_RANGE IS NULL) THEN
137: LP_DATE_RANGE := ' ';

Line 247: WSH_DELIVERY_LEGS WDL

243: FROM
244: WSH_TRIPS WT,
245: WSH_TRIP_STOPS WTS,
246: WSH_DELIVERY_ASSIGNMENTS_V WDA,
247: WSH_DELIVERY_LEGS WDL
248: WHERE WTS.STOP_ID = WDL.PICK_UP_STOP_ID
249: --AND WDA.DELIVERY_ID = DELIVERY_ID
250: AND WDA.DELIVERY_ID = DELIVERY_ID1
251: AND WDA.DELIVERY_ID = WDL.DELIVERY_ID