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.WSH_WSHRDLAB_XMLP_PKG dependencies on WSH_TRIP_STOPS

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 238: WSH_TRIP_STOPS WTS,

234: WT.SHIP_METHOD_CODE
235: INTO L_SHIP_METHOD_CODE
236: FROM
237: WSH_TRIPS WT,
238: WSH_TRIP_STOPS WTS,
239: WSH_DELIVERY_ASSIGNMENTS_V WDA,
240: WSH_DELIVERY_LEGS WDL
241: WHERE WTS.STOP_ID = WDL.PICK_UP_STOP_ID
242: --AND WDA.DELIVERY_ID = DELIVERY_ID