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

Line 180: l_sc_EXISTS_BOL := l_sc_EXISTS_BOL ||' FROM wsh_delivery_legs wlg ';

176: END IF;
177:
178: IF (p_input_info.bol_number_lo IS NOT NULL OR p_input_info.bol_number_hi IS NOT NULL) THEN
179: l_sc_EXISTS_BOL := l_sc_EXISTS_BOL ||' SELECT wdi.document_instance_id ';
180: l_sc_EXISTS_BOL := l_sc_EXISTS_BOL ||' FROM wsh_delivery_legs wlg ';
181: l_sc_EXISTS_BOL := l_sc_EXISTS_BOL ||' ,wsh_document_instances wdi ';
182: l_sc_EXISTS_BOL := l_sc_EXISTS_BOL ||' WHERE wnd.delivery_id = wlg.delivery_id ';
183: l_sc_EXISTS_BOL := l_sc_EXISTS_BOL ||' AND wlg.delivery_leg_id = wdi.entity_id ';
184: l_sc_EXISTS_BOL := l_sc_EXISTS_BOL ||' AND wdi.entity_name= ''WSH_DELIVERY_LEGS'' ';

Line 184: l_sc_EXISTS_BOL := l_sc_EXISTS_BOL ||' AND wdi.entity_name= ''WSH_DELIVERY_LEGS'' ';

180: l_sc_EXISTS_BOL := l_sc_EXISTS_BOL ||' FROM wsh_delivery_legs wlg ';
181: l_sc_EXISTS_BOL := l_sc_EXISTS_BOL ||' ,wsh_document_instances wdi ';
182: l_sc_EXISTS_BOL := l_sc_EXISTS_BOL ||' WHERE wnd.delivery_id = wlg.delivery_id ';
183: l_sc_EXISTS_BOL := l_sc_EXISTS_BOL ||' AND wlg.delivery_leg_id = wdi.entity_id ';
184: l_sc_EXISTS_BOL := l_sc_EXISTS_BOL ||' AND wdi.entity_name= ''WSH_DELIVERY_LEGS'' ';
185: l_sc_EXISTS_BOL := l_sc_EXISTS_BOL ||' AND wdi.document_type =''BOL'' ';
186: l_sc_EXISTS_BOL := l_sc_EXISTS_BOL ||' AND wdi.status <> ''CANCELED'' ';
187:
188: IF p_input_info.bol_number_lo IS NOT NULL AND p_input_info.bol_number_hi IS NOT NULL THEN

Line 527: FROM wsh_delivery_legs dlg,

523: -- bug 4302048: respect rule's ship method defaulting
524: CURSOR c_first_trip_ship_method (x_delivery_id IN NUMBER,
525: x_initial_loc_id IN NUMBER)IS
526: SELECT wt.ship_method_code
527: FROM wsh_delivery_legs dlg,
528: wsh_trip_stops st,
529: wsh_trips wt
530: WHERE dlg.delivery_id = x_delivery_id
531: AND st.stop_id = dlg.pick_up_stop_id

Line 913: wsh_delivery_legs wlg,

909: -- 3667595
910: CURSOR get_pick_up_stops IS
911: SELECT DISTINCT wtp.trip_id, wst.stop_sequence_number, wst.stop_id, wst.stop_location_id
912: FROM wsh_new_deliveries wnd,
913: wsh_delivery_legs wlg,
914: wsh_trip_stops wst,
915: wsh_trips wtp
916: WHERE wnd.delivery_id = wlg.delivery_id AND
917: wlg.pick_up_stop_id = wst.stop_id AND

Line 937: , wsh_delivery_legs wlg

933: CURSOR get_all_stops IS
934: select wsto.trip_id, wsto.stop_sequence_number, wsto.stop_id , wsto.stop_location_id
935: from wsh_trip_stops wsto
936: , wsh_new_deliveries wnd
937: , wsh_delivery_legs wlg
938: , wsh_trip_stops wst
939: where wnd.batch_id = p_sc_batch_id
940: and wnd.status_code = 'CO'
941: and wnd.delivery_id = wlg.delivery_id

Line 960: wsh_delivery_legs wdl,

956: -- 3667595
957: CURSOR c_batch_stop(p_batch_id NUMBER)IS
958: SELECT wts.stop_id
959: FROM wsh_trip_stops wts,
960: wsh_delivery_legs wdl,
961: wsh_new_deliveries wnd,
962: wsh_picking_batches wpb
963: WHERE p_batch_id IS NOT NULL
964: AND wnd.batch_id = p_batch_id