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 125: wsh_new_deliveries wnd,

121: wnd.ignore_for_planning, -- OTM R12 : update requested quantity change
122: wnd.tms_interface_flag, -- OTM R12 : update requested quantity change
123: wdd.replenishment_status --bug# 6689448 (replenishment project)
124: FROM wsh_delivery_details wdd,
125: wsh_new_deliveries wnd,
126: wsh_delivery_assignments_v wda
127: WHERE wdd.delivery_detail_id = wda.delivery_detail_id
128: AND wda.delivery_id = wnd.delivery_id (+)
129: AND wdd.source_line_id = p_changed_attribute.source_line_id

Line 189: wsh_new_deliveries wnd,

185: wnd.ignore_for_planning, -- OTM R12 : update requested quantity change
186: wnd.tms_interface_flag, -- OTM R12 : update requested quantity change
187: wdd.replenishment_status --bug# 6689448 (replenishment project)
188: FROM wsh_delivery_details wdd,
189: wsh_new_deliveries wnd,
190: wsh_delivery_assignments_v wda,
191: mtl_serial_numbers_temp msnt
192: WHERE wdd.delivery_detail_id = wda.delivery_detail_id
193: AND wda.delivery_id = wnd.delivery_id (+)

Line 582: wsh_new_deliveries wnd

578: wdd.source_line_id = p_changed_attribute.source_line_id
579: and wdd.source_code = p_source_code
580: and not exists (select 'x' from
581: wsh_delivery_assignments wda,
582: wsh_new_deliveries wnd
583: where wda.delivery_detail_id = wdd.delivery_detail_id
584: and wda.delivery_id = wnd.delivery_id
585: and wnd.status_code in ('CL', 'IT', 'CO'));
586: --

Line 1065: (WSH_NEW_DELIVERIES_PVT.C_TMS_ANSWER_RECEIVED,

1061: l_delivery_id_tab(1) := old_delivery_detail_rec.delivery_id;
1062:
1063: -- calculate the interface flag to be updated
1064: IF old_delivery_detail_rec.tms_interface_flag IN
1065: (WSH_NEW_DELIVERIES_PVT.C_TMS_ANSWER_RECEIVED,
1066: WSH_NEW_DELIVERIES_PVT.C_TMS_AWAITING_ANSWER,
1067: WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_IN_PROCESS,
1068: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_IN_PROCESS) THEN
1069: l_interface_flag_tab(1) := WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED;

Line 1066: WSH_NEW_DELIVERIES_PVT.C_TMS_AWAITING_ANSWER,

1062:
1063: -- calculate the interface flag to be updated
1064: IF old_delivery_detail_rec.tms_interface_flag IN
1065: (WSH_NEW_DELIVERIES_PVT.C_TMS_ANSWER_RECEIVED,
1066: WSH_NEW_DELIVERIES_PVT.C_TMS_AWAITING_ANSWER,
1067: WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_IN_PROCESS,
1068: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_IN_PROCESS) THEN
1069: l_interface_flag_tab(1) := WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED;
1070: IF l_debug_on THEN

Line 1067: WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_IN_PROCESS,

1063: -- calculate the interface flag to be updated
1064: IF old_delivery_detail_rec.tms_interface_flag IN
1065: (WSH_NEW_DELIVERIES_PVT.C_TMS_ANSWER_RECEIVED,
1066: WSH_NEW_DELIVERIES_PVT.C_TMS_AWAITING_ANSWER,
1067: WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_IN_PROCESS,
1068: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_IN_PROCESS) THEN
1069: l_interface_flag_tab(1) := WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED;
1070: IF l_debug_on THEN
1071: WSH_DEBUG_SV.log(l_module_name, 'l_delivery_id_tab', l_delivery_id_tab(1));

Line 1068: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_IN_PROCESS) THEN

1064: IF old_delivery_detail_rec.tms_interface_flag IN
1065: (WSH_NEW_DELIVERIES_PVT.C_TMS_ANSWER_RECEIVED,
1066: WSH_NEW_DELIVERIES_PVT.C_TMS_AWAITING_ANSWER,
1067: WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_IN_PROCESS,
1068: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_IN_PROCESS) THEN
1069: l_interface_flag_tab(1) := WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED;
1070: IF l_debug_on THEN
1071: WSH_DEBUG_SV.log(l_module_name, 'l_delivery_id_tab', l_delivery_id_tab(1));
1072: WSH_DEBUG_SV.log(l_module_name, 'l_interface_flag_tab', l_interface_flag_tab(1));

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

1065: (WSH_NEW_DELIVERIES_PVT.C_TMS_ANSWER_RECEIVED,
1066: WSH_NEW_DELIVERIES_PVT.C_TMS_AWAITING_ANSWER,
1067: WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_IN_PROCESS,
1068: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_IN_PROCESS) THEN
1069: l_interface_flag_tab(1) := WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED;
1070: IF l_debug_on THEN
1071: WSH_DEBUG_SV.log(l_module_name, 'l_delivery_id_tab', l_delivery_id_tab(1));
1072: WSH_DEBUG_SV.log(l_module_name, 'l_interface_flag_tab', l_interface_flag_tab(1));
1073: END IF;

Line 1080: WSH_NEW_DELIVERIES_PVT.UPDATE_TMS_INTERFACE_FLAG(

1076: END IF;
1077:
1078:
1079: IF (l_call_update = 'Y') THEN
1080: WSH_NEW_DELIVERIES_PVT.UPDATE_TMS_INTERFACE_FLAG(
1081: p_delivery_id_tab => l_delivery_id_tab,
1082: p_tms_interface_flag_tab => l_interface_flag_tab,
1083: x_return_status => l_return_status);
1084:

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

1084:
1085: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
1086: x_return_status := l_return_status;
1087: IF l_debug_on THEN
1088: WSH_DEBUG_SV.logmsg(l_module_name,'Error in WSH_NEW_DELIVERIES_PVT.UPDATE_TMS_INTERFACE_FLAG');
1089: WSH_DEBUG_SV.pop(l_module_name);
1090: END IF;
1091: RETURN;
1092: END IF;

Line 2707: wsh_new_deliveries wnd

2703: SELECT wda.delivery_id, wnd.planned_flag,
2704: wnd.ignore_for_planning, -- OTM R12 : cancel quantity
2705: wnd.tms_interface_flag -- OTM R12 : cancel quantity
2706: FROM wsh_delivery_assignments_v wda,
2707: wsh_new_deliveries wnd
2708: WHERE wda.delivery_id is not null
2709: AND wda.delivery_detail_id = p_del_det
2710: AND wda.delivery_id = wnd.delivery_id;
2711:

Line 2747: l_ignore WSH_NEW_DELIVERIES.IGNORE_FOR_PLANNING%TYPE;

2743:
2744: l_planned_flag VARCHAR2(1); -- Bug fix 2864546
2745:
2746: -- OTM R12 : cancel quantity
2747: l_ignore WSH_NEW_DELIVERIES.IGNORE_FOR_PLANNING%TYPE;
2748: l_tms_interface_flag WSH_NEW_DELIVERIES.TMS_INTERFACE_FLAG%TYPE;
2749: l_delivery_id_tab WSH_UTIL_CORE.ID_TAB_TYPE;
2750: l_interface_flag_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE;
2751: l_call_update VARCHAR2(1);

Line 2748: l_tms_interface_flag WSH_NEW_DELIVERIES.TMS_INTERFACE_FLAG%TYPE;

2744: l_planned_flag VARCHAR2(1); -- Bug fix 2864546
2745:
2746: -- OTM R12 : cancel quantity
2747: l_ignore WSH_NEW_DELIVERIES.IGNORE_FOR_PLANNING%TYPE;
2748: l_tms_interface_flag WSH_NEW_DELIVERIES.TMS_INTERFACE_FLAG%TYPE;
2749: l_delivery_id_tab WSH_UTIL_CORE.ID_TAB_TYPE;
2750: l_interface_flag_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE;
2751: l_call_update VARCHAR2(1);
2752: l_del_assigned VARCHAR2(1);

Line 3052: (WSH_NEW_DELIVERIES_PVT.C_TMS_ANSWER_RECEIVED,

3048: l_delivery_id_tab(1) := l_delivery_id;
3049:
3050: --calculate the interface flag to be updated
3051: IF l_tms_interface_flag IN
3052: (WSH_NEW_DELIVERIES_PVT.C_TMS_ANSWER_RECEIVED,
3053: WSH_NEW_DELIVERIES_PVT.C_TMS_AWAITING_ANSWER,
3054: WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_IN_PROCESS,
3055: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_IN_PROCESS) THEN
3056: l_interface_flag_tab(1) := WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED;

Line 3053: WSH_NEW_DELIVERIES_PVT.C_TMS_AWAITING_ANSWER,

3049:
3050: --calculate the interface flag to be updated
3051: IF l_tms_interface_flag IN
3052: (WSH_NEW_DELIVERIES_PVT.C_TMS_ANSWER_RECEIVED,
3053: WSH_NEW_DELIVERIES_PVT.C_TMS_AWAITING_ANSWER,
3054: WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_IN_PROCESS,
3055: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_IN_PROCESS) THEN
3056: l_interface_flag_tab(1) := WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED;
3057: ELSE

Line 3054: WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_IN_PROCESS,

3050: --calculate the interface flag to be updated
3051: IF l_tms_interface_flag IN
3052: (WSH_NEW_DELIVERIES_PVT.C_TMS_ANSWER_RECEIVED,
3053: WSH_NEW_DELIVERIES_PVT.C_TMS_AWAITING_ANSWER,
3054: WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_IN_PROCESS,
3055: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_IN_PROCESS) THEN
3056: l_interface_flag_tab(1) := WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED;
3057: ELSE
3058: l_call_update := 'N';

Line 3055: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_IN_PROCESS) THEN

3051: IF l_tms_interface_flag IN
3052: (WSH_NEW_DELIVERIES_PVT.C_TMS_ANSWER_RECEIVED,
3053: WSH_NEW_DELIVERIES_PVT.C_TMS_AWAITING_ANSWER,
3054: WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_IN_PROCESS,
3055: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_IN_PROCESS) THEN
3056: l_interface_flag_tab(1) := WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED;
3057: ELSE
3058: l_call_update := 'N';
3059: END IF;

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

3052: (WSH_NEW_DELIVERIES_PVT.C_TMS_ANSWER_RECEIVED,
3053: WSH_NEW_DELIVERIES_PVT.C_TMS_AWAITING_ANSWER,
3054: WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_IN_PROCESS,
3055: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_IN_PROCESS) THEN
3056: l_interface_flag_tab(1) := WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED;
3057: ELSE
3058: l_call_update := 'N';
3059: END IF;
3060:

Line 3062: WSH_NEW_DELIVERIES_PVT.UPDATE_TMS_INTERFACE_FLAG(

3058: l_call_update := 'N';
3059: END IF;
3060:
3061: IF (l_call_update = 'Y') THEN
3062: WSH_NEW_DELIVERIES_PVT.UPDATE_TMS_INTERFACE_FLAG(
3063: p_delivery_id_tab => l_delivery_id_tab,
3064: p_tms_interface_flag_tab => l_interface_flag_tab,
3065: x_return_status => l_return_status);
3066: