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_USA_QUANTITY_PVT dependencies on WSH_NEW_DELIVERIES

Line 114: wsh_new_deliveries wnd,

110: wnd.ignore_for_planning, -- OTM R12 : update requested quantity change
111: wnd.tms_interface_flag, -- OTM R12 : update requested quantity change
112: wdd.replenishment_status --bug# 6689448 (replenishment project)
113: FROM wsh_delivery_details wdd,
114: wsh_new_deliveries wnd,
115: wsh_delivery_assignments_v wda
116: WHERE wdd.delivery_detail_id = wda.delivery_detail_id
117: AND wda.delivery_id = wnd.delivery_id (+)
118: AND wdd.source_line_id = p_changed_attribute.source_line_id

Line 172: wsh_new_deliveries wnd,

168: wnd.ignore_for_planning, -- OTM R12 : update requested quantity change
169: wnd.tms_interface_flag, -- OTM R12 : update requested quantity change
170: wdd.replenishment_status --bug# 6689448 (replenishment project)
171: FROM wsh_delivery_details wdd,
172: wsh_new_deliveries wnd,
173: wsh_delivery_assignments_v wda,
174: mtl_serial_numbers_temp msnt
175: WHERE wdd.delivery_detail_id = wda.delivery_detail_id
176: AND wda.delivery_id = wnd.delivery_id (+)

Line 522: wsh_new_deliveries wnd

518: wdd.source_line_id = p_changed_attribute.source_line_id
519: and wdd.source_code = p_source_code
520: and not exists (select 'x' from
521: wsh_delivery_assignments wda,
522: wsh_new_deliveries wnd
523: where wda.delivery_detail_id = wdd.delivery_detail_id
524: and wda.delivery_id = wnd.delivery_id
525: and wnd.status_code in ('CL', 'IT', 'CO'));
526: --

Line 927: (WSH_NEW_DELIVERIES_PVT.C_TMS_ANSWER_RECEIVED,

923: l_delivery_id_tab(1) := old_delivery_detail_rec.delivery_id;
924:
925: -- calculate the interface flag to be updated
926: IF old_delivery_detail_rec.tms_interface_flag IN
927: (WSH_NEW_DELIVERIES_PVT.C_TMS_ANSWER_RECEIVED,
928: WSH_NEW_DELIVERIES_PVT.C_TMS_AWAITING_ANSWER,
929: WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_IN_PROCESS,
930: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_IN_PROCESS) THEN
931: l_interface_flag_tab(1) := WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED;

Line 928: WSH_NEW_DELIVERIES_PVT.C_TMS_AWAITING_ANSWER,

924:
925: -- calculate the interface flag to be updated
926: IF old_delivery_detail_rec.tms_interface_flag IN
927: (WSH_NEW_DELIVERIES_PVT.C_TMS_ANSWER_RECEIVED,
928: WSH_NEW_DELIVERIES_PVT.C_TMS_AWAITING_ANSWER,
929: WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_IN_PROCESS,
930: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_IN_PROCESS) THEN
931: l_interface_flag_tab(1) := WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED;
932: IF l_debug_on THEN

Line 929: WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_IN_PROCESS,

925: -- calculate the interface flag to be updated
926: IF old_delivery_detail_rec.tms_interface_flag IN
927: (WSH_NEW_DELIVERIES_PVT.C_TMS_ANSWER_RECEIVED,
928: WSH_NEW_DELIVERIES_PVT.C_TMS_AWAITING_ANSWER,
929: WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_IN_PROCESS,
930: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_IN_PROCESS) THEN
931: l_interface_flag_tab(1) := WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED;
932: IF l_debug_on THEN
933: WSH_DEBUG_SV.log(l_module_name, 'l_delivery_id_tab', l_delivery_id_tab(1));

Line 930: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_IN_PROCESS) THEN

926: IF old_delivery_detail_rec.tms_interface_flag IN
927: (WSH_NEW_DELIVERIES_PVT.C_TMS_ANSWER_RECEIVED,
928: WSH_NEW_DELIVERIES_PVT.C_TMS_AWAITING_ANSWER,
929: WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_IN_PROCESS,
930: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_IN_PROCESS) THEN
931: l_interface_flag_tab(1) := WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED;
932: IF l_debug_on THEN
933: WSH_DEBUG_SV.log(l_module_name, 'l_delivery_id_tab', l_delivery_id_tab(1));
934: WSH_DEBUG_SV.log(l_module_name, 'l_interface_flag_tab', l_interface_flag_tab(1));

Line 931: l_interface_flag_tab(1) := WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED;

927: (WSH_NEW_DELIVERIES_PVT.C_TMS_ANSWER_RECEIVED,
928: WSH_NEW_DELIVERIES_PVT.C_TMS_AWAITING_ANSWER,
929: WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_IN_PROCESS,
930: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_IN_PROCESS) THEN
931: l_interface_flag_tab(1) := WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED;
932: IF l_debug_on THEN
933: WSH_DEBUG_SV.log(l_module_name, 'l_delivery_id_tab', l_delivery_id_tab(1));
934: WSH_DEBUG_SV.log(l_module_name, 'l_interface_flag_tab', l_interface_flag_tab(1));
935: END IF;

Line 942: WSH_NEW_DELIVERIES_PVT.UPDATE_TMS_INTERFACE_FLAG(

938: END IF;
939:
940:
941: IF (l_call_update = 'Y') THEN
942: WSH_NEW_DELIVERIES_PVT.UPDATE_TMS_INTERFACE_FLAG(
943: p_delivery_id_tab => l_delivery_id_tab,
944: p_tms_interface_flag_tab => l_interface_flag_tab,
945: x_return_status => l_return_status);
946:

Line 950: WSH_DEBUG_SV.logmsg(l_module_name,'Error in WSH_NEW_DELIVERIES_PVT.UPDATE_TMS_INTERFACE_FLAG');

946:
947: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
948: x_return_status := l_return_status;
949: IF l_debug_on THEN
950: WSH_DEBUG_SV.logmsg(l_module_name,'Error in WSH_NEW_DELIVERIES_PVT.UPDATE_TMS_INTERFACE_FLAG');
951: WSH_DEBUG_SV.pop(l_module_name);
952: END IF;
953: RETURN;
954: END IF;

Line 2428: wsh_new_deliveries wnd

2424: SELECT wda.delivery_id, wnd.planned_flag,
2425: wnd.ignore_for_planning, -- OTM R12 : cancel quantity
2426: wnd.tms_interface_flag -- OTM R12 : cancel quantity
2427: FROM wsh_delivery_assignments_v wda,
2428: wsh_new_deliveries wnd
2429: WHERE wda.delivery_id is not null
2430: AND wda.delivery_detail_id = p_del_det
2431: AND wda.delivery_id = wnd.delivery_id;
2432:

Line 2468: l_ignore WSH_NEW_DELIVERIES.IGNORE_FOR_PLANNING%TYPE;

2464:
2465: l_planned_flag VARCHAR2(1); -- Bug fix 2864546
2466:
2467: -- OTM R12 : cancel quantity
2468: l_ignore WSH_NEW_DELIVERIES.IGNORE_FOR_PLANNING%TYPE;
2469: l_tms_interface_flag WSH_NEW_DELIVERIES.TMS_INTERFACE_FLAG%TYPE;
2470: l_delivery_id_tab WSH_UTIL_CORE.ID_TAB_TYPE;
2471: l_interface_flag_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE;
2472: l_call_update VARCHAR2(1);

Line 2469: l_tms_interface_flag WSH_NEW_DELIVERIES.TMS_INTERFACE_FLAG%TYPE;

2465: l_planned_flag VARCHAR2(1); -- Bug fix 2864546
2466:
2467: -- OTM R12 : cancel quantity
2468: l_ignore WSH_NEW_DELIVERIES.IGNORE_FOR_PLANNING%TYPE;
2469: l_tms_interface_flag WSH_NEW_DELIVERIES.TMS_INTERFACE_FLAG%TYPE;
2470: l_delivery_id_tab WSH_UTIL_CORE.ID_TAB_TYPE;
2471: l_interface_flag_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE;
2472: l_call_update VARCHAR2(1);
2473: l_del_assigned VARCHAR2(1);

Line 2682: (WSH_NEW_DELIVERIES_PVT.C_TMS_ANSWER_RECEIVED,

2678: l_delivery_id_tab(1) := l_delivery_id;
2679:
2680: --calculate the interface flag to be updated
2681: IF l_tms_interface_flag IN
2682: (WSH_NEW_DELIVERIES_PVT.C_TMS_ANSWER_RECEIVED,
2683: WSH_NEW_DELIVERIES_PVT.C_TMS_AWAITING_ANSWER,
2684: WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_IN_PROCESS,
2685: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_IN_PROCESS) THEN
2686: l_interface_flag_tab(1) := WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED;

Line 2683: WSH_NEW_DELIVERIES_PVT.C_TMS_AWAITING_ANSWER,

2679:
2680: --calculate the interface flag to be updated
2681: IF l_tms_interface_flag IN
2682: (WSH_NEW_DELIVERIES_PVT.C_TMS_ANSWER_RECEIVED,
2683: WSH_NEW_DELIVERIES_PVT.C_TMS_AWAITING_ANSWER,
2684: WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_IN_PROCESS,
2685: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_IN_PROCESS) THEN
2686: l_interface_flag_tab(1) := WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED;
2687: ELSE

Line 2684: WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_IN_PROCESS,

2680: --calculate the interface flag to be updated
2681: IF l_tms_interface_flag IN
2682: (WSH_NEW_DELIVERIES_PVT.C_TMS_ANSWER_RECEIVED,
2683: WSH_NEW_DELIVERIES_PVT.C_TMS_AWAITING_ANSWER,
2684: WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_IN_PROCESS,
2685: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_IN_PROCESS) THEN
2686: l_interface_flag_tab(1) := WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED;
2687: ELSE
2688: l_call_update := 'N';

Line 2685: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_IN_PROCESS) THEN

2681: IF l_tms_interface_flag IN
2682: (WSH_NEW_DELIVERIES_PVT.C_TMS_ANSWER_RECEIVED,
2683: WSH_NEW_DELIVERIES_PVT.C_TMS_AWAITING_ANSWER,
2684: WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_IN_PROCESS,
2685: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_IN_PROCESS) THEN
2686: l_interface_flag_tab(1) := WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED;
2687: ELSE
2688: l_call_update := 'N';
2689: END IF;

Line 2686: l_interface_flag_tab(1) := WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED;

2682: (WSH_NEW_DELIVERIES_PVT.C_TMS_ANSWER_RECEIVED,
2683: WSH_NEW_DELIVERIES_PVT.C_TMS_AWAITING_ANSWER,
2684: WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_IN_PROCESS,
2685: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_IN_PROCESS) THEN
2686: l_interface_flag_tab(1) := WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED;
2687: ELSE
2688: l_call_update := 'N';
2689: END IF;
2690:

Line 2692: WSH_NEW_DELIVERIES_PVT.UPDATE_TMS_INTERFACE_FLAG(

2688: l_call_update := 'N';
2689: END IF;
2690:
2691: IF (l_call_update = 'Y') THEN
2692: WSH_NEW_DELIVERIES_PVT.UPDATE_TMS_INTERFACE_FLAG(
2693: p_delivery_id_tab => l_delivery_id_tab,
2694: p_tms_interface_flag_tab => l_interface_flag_tab,
2695: x_return_status => l_return_status);
2696: