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_NEW_DELIVERIES

Line 72: l_sc_FROM := l_sc_FROM || 'wsh_new_deliveries wnd ';

68: x_selected_del_tab.delete;
69:
70: l_sc_SELECT := l_sc_SELECT || ' wnd.delivery_id , wnd.organization_id, wnd.initial_pickup_location_id ';
71:
72: l_sc_FROM := l_sc_FROM || 'wsh_new_deliveries wnd ';
73:
74: IF p_input_info.process_mode = G_SHIP_CONFIRM THEN
75: l_sc_WHERE := l_sc_WHERE || 'NVL(wnd.auto_sc_exclude_flag, ''N'') = ''N'' ';
76: ELSIF p_input_info.process_mode = G_AUTO_PACK THEN

Line 517: FROM wsh_new_deliveries

513: initial_pickup_date,
514: organization_id,
515: ship_method_code,
516: initial_pickup_location_id
517: FROM wsh_new_deliveries
518: WHERE delivery_id = c_delivery_id and
519: status_code = 'OP' AND
520: NVL(auto_sc_exclude_flag, 'N')= 'N' FOR UPDATE NOWAIT;
521:

Line 537: l_ship_method_code WSH_NEW_DELIVERIES.SHIP_METHOD_CODE%TYPE;

533: AND st.trip_id = wt.trip_id
534: AND wt.ship_method_code IS NOT NULL
535: AND rownum = 1;
536:
537: l_ship_method_code WSH_NEW_DELIVERIES.SHIP_METHOD_CODE%TYPE;
538:
539: l_delivery_rec get_delivery%ROWTYPE;
540: l_tmp_del_tab WSH_UTIL_CORE.Id_Tab_Type;
541: l_err_entity_ids WSH_UTIL_CORE.Id_Tab_Type;

Line 545: l_rec_attr_tab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;

541: l_err_entity_ids WSH_UTIL_CORE.Id_Tab_Type;
542: l_return_status VARCHAR2(1) := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
543: l_actual_dep_date DATE ;
544: l_action_prms WSH_DELIVERIES_GRP.action_parameters_rectype;
545: l_rec_attr_tab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;
546: l_delivery_out_rec WSH_DELIVERIES_GRP.Delivery_Action_Out_Rec_Type;
547: l_defaults_rec WSH_DELIVERIES_GRP.default_parameters_rectype;
548: l_msg_count NUMBER;
549: l_msg_data VARCHAR2(4000);

Line 586: UPDATE WSH_NEW_DELIVERIES SET BATCH_ID = p_sc_batch_id

582: IF l_debug_on THEN
583: WSH_DEBUG_SV.log(l_module_name, 'Check if ship confirm is allowed for delivery ID: ' || to_char(l_tmp_del_tab(1)));
584: END IF;
585:
586: UPDATE WSH_NEW_DELIVERIES SET BATCH_ID = p_sc_batch_id
587: WHERE delivery_id = p_delivery_id;
588:
589: SAVEPOINT beginning_of_loop;
590:

Line 912: FROM wsh_new_deliveries wnd,

908:
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

Line 936: , wsh_new_deliveries wnd

932: --Modified the following SQL as part of bug 4280371 ( 30-Jun-2005 ).
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'

Line 961: wsh_new_deliveries wnd,

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
965: AND wdl.delivery_id = wnd.delivery_id

Line 1150: select status_code into l_status_code from wsh_new_deliveries where delivery_id = p_del_tab(i).delivery_id;

1146: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1147: x_results_summary.success := x_results_summary.success + 1;
1148: l_sc_confirmed_dels(l_sc_confirmed_dels.count+1):= p_del_tab(i).delivery_id;
1149: IF l_debug_on THEN
1150: select status_code into l_status_code from wsh_new_deliveries where delivery_id = p_del_tab(i).delivery_id;
1151: WSH_DEBUG_SV.logmsg(l_module_name,'Delivery ID ' || to_char(p_del_tab(i).delivery_id)||' is ship confirmed successfully with status '|| l_status_code);
1152: END IF;
1153:
1154:

Line 1488: FROM wsh_new_deliveries

1484: planned_flag,
1485: initial_pickup_date,
1486: organization_id,
1487: ship_method_code
1488: FROM wsh_new_deliveries
1489: WHERE delivery_id = c_delivery_id and
1490: status_code = 'OP' AND
1491: NVL(auto_ap_exclude_flag, 'N')= 'N' FOR UPDATE NOWAIT;
1492:

Line 1502: l_rec_attr_tab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;

1498: l_err_entity_ids WSH_UTIL_CORE.Id_Tab_Type;
1499: l_cont_instance_tab WSH_UTIL_CORE.Id_Tab_Type;
1500: l_return_status VARCHAR2(1) := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1501: l_action_prms WSH_DELIVERIES_GRP.action_parameters_rectype;
1502: l_rec_attr_tab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;
1503: l_delivery_out_rec WSH_DELIVERIES_GRP.Delivery_Action_Out_Rec_Type;
1504: l_defaults_rec WSH_DELIVERIES_GRP.default_parameters_rectype;
1505: l_msg_count NUMBER;
1506: l_msg_data VARCHAR2(4000);

Line 1556: UPDATE WSH_NEW_DELIVERIES SET AP_BATCH_ID = p_ap_batch_id

1552:
1553:
1554: SAVEPOINT beginning_of_loop;
1555:
1556: UPDATE WSH_NEW_DELIVERIES SET AP_BATCH_ID = p_ap_batch_id
1557: WHERE delivery_id = p_delivery_id;
1558:
1559: fnd_msg_pub.initialize; -- clear messages
1560: