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_MDC_SRS dependencies on WSH_DELIVERY_LEGS

Line 211: FROM WSH_DELIVERY_LEGS

207:
208: CURSOR Get_Exist_trip(p_delivery_id NUMBER)
209: IS
210: SELECT COUNT(DELIVERY_LEG_ID)
211: FROM WSH_DELIVERY_LEGS
212: WHERE DELIVERY_ID = p_delivery_id;
213:
214: CURSOR Get_Trip(c_delivery_id NUMBER)
215: IS

Line 217: FROM WSH_TRIP_STOPS WTS, WSH_DELIVERY_LEGS WDL

213:
214: CURSOR Get_Trip(c_delivery_id NUMBER)
215: IS
216: SELECT WTS.TRIP_ID
217: FROM WSH_TRIP_STOPS WTS, WSH_DELIVERY_LEGS WDL
218: WHERE WTS.STOP_ID = WDL.PICK_UP_STOP_ID
219: AND WDL.DELIVERY_ID = c_delivery_id;
220:
221:

Line 1587: l_where_clause := l_where_clause || ' AND NOT EXISTS ( SELECT 1 FROM WSH_DELIVERY_LEGS WHERE DELIVERY_ID = WND.DELIVERY_ID AND ROWNUM < 2)';

1583: END IF;
1584:
1585: IF p_sel_del_attr.inc_del_assgnd_trip_flag IS NULL
1586: THEN
1587: l_where_clause := l_where_clause || ' AND NOT EXISTS ( SELECT 1 FROM WSH_DELIVERY_LEGS WHERE DELIVERY_ID = WND.DELIVERY_ID AND ROWNUM < 2)';
1588: ELSE
1589: WSH_UTIL_CORE.PrintMsg(' Including deliveries assigned to trip');
1590: END IF;
1591: