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 163: l_sc_EXISTS_BOL := l_sc_EXISTS_BOL ||' FROM wsh_delivery_legs wlg ';

159: END IF;
160:
161: IF (p_input_info.bol_number_lo IS NOT NULL OR p_input_info.bol_number_hi IS NOT NULL) THEN
162: l_sc_EXISTS_BOL := l_sc_EXISTS_BOL ||' SELECT wdi.document_instance_id ';
163: l_sc_EXISTS_BOL := l_sc_EXISTS_BOL ||' FROM wsh_delivery_legs wlg ';
164: l_sc_EXISTS_BOL := l_sc_EXISTS_BOL ||' ,wsh_document_instances wdi ';
165: l_sc_EXISTS_BOL := l_sc_EXISTS_BOL ||' WHERE wnd.delivery_id = wlg.delivery_id ';
166: l_sc_EXISTS_BOL := l_sc_EXISTS_BOL ||' AND wlg.delivery_leg_id = wdi.entity_id ';
167: l_sc_EXISTS_BOL := l_sc_EXISTS_BOL ||' AND wdi.entity_name= ''WSH_DELIVERY_LEGS'' ';

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

163: l_sc_EXISTS_BOL := l_sc_EXISTS_BOL ||' FROM wsh_delivery_legs wlg ';
164: l_sc_EXISTS_BOL := l_sc_EXISTS_BOL ||' ,wsh_document_instances wdi ';
165: l_sc_EXISTS_BOL := l_sc_EXISTS_BOL ||' WHERE wnd.delivery_id = wlg.delivery_id ';
166: l_sc_EXISTS_BOL := l_sc_EXISTS_BOL ||' AND wlg.delivery_leg_id = wdi.entity_id ';
167: l_sc_EXISTS_BOL := l_sc_EXISTS_BOL ||' AND wdi.entity_name= ''WSH_DELIVERY_LEGS'' ';
168: l_sc_EXISTS_BOL := l_sc_EXISTS_BOL ||' AND wdi.document_type =''BOL'' ';
169: l_sc_EXISTS_BOL := l_sc_EXISTS_BOL ||' AND wdi.status <> ''CANCELED'' ';
170:
171: IF p_input_info.bol_number_lo IS NOT NULL AND p_input_info.bol_number_hi IS NOT NULL THEN

Line 503: FROM wsh_delivery_legs dlg,

499: -- bug 4302048: respect rule's ship method defaulting
500: CURSOR c_first_trip_ship_method (x_delivery_id IN NUMBER,
501: x_initial_loc_id IN NUMBER)IS
502: SELECT wt.ship_method_code
503: FROM wsh_delivery_legs dlg,
504: wsh_trip_stops st,
505: wsh_trips wt
506: WHERE dlg.delivery_id = x_delivery_id
507: AND st.stop_id = dlg.pick_up_stop_id

Line 889: wsh_delivery_legs wlg,

885: -- 3667595
886: CURSOR get_pick_up_stops IS
887: SELECT DISTINCT wtp.trip_id, wst.stop_sequence_number, wst.stop_id, wst.stop_location_id
888: FROM wsh_new_deliveries wnd,
889: wsh_delivery_legs wlg,
890: wsh_trip_stops wst,
891: wsh_trips wtp
892: WHERE wnd.delivery_id = wlg.delivery_id AND
893: wlg.pick_up_stop_id = wst.stop_id AND

Line 913: , wsh_delivery_legs wlg

909: CURSOR get_all_stops IS
910: select wsto.trip_id, wsto.stop_sequence_number, wsto.stop_id , wsto.stop_location_id
911: from wsh_trip_stops wsto
912: , wsh_new_deliveries wnd
913: , wsh_delivery_legs wlg
914: , wsh_trip_stops wst
915: where wnd.batch_id = p_sc_batch_id
916: and wnd.status_code = 'CO'
917: and wnd.delivery_id = wlg.delivery_id

Line 936: wsh_delivery_legs wdl,

932: -- 3667595
933: CURSOR c_batch_stop(p_batch_id NUMBER)IS
934: SELECT wts.stop_id
935: FROM wsh_trip_stops wts,
936: wsh_delivery_legs wdl,
937: wsh_new_deliveries wnd,
938: wsh_picking_batches wpb
939: WHERE p_batch_id IS NOT NULL
940: AND wnd.batch_id = p_batch_id