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_LPN_SYNC_COMM_PKG dependencies on WSH_WMS_SYNC_TMP

Line 33: wsh_wms_sync_tmp wlst

29: wddp.lpn_id old_parent_lpn_id
30: from wsh_delivery_details wddc,
31: wsh_delivery_details wddp,
32: wsh_delivery_assignments_v wda,
33: wsh_wms_sync_tmp wlst
34: where wlst.delivery_detail_id = wda.delivery_detail_id
35: and wddc.delivery_detail_id = wda.delivery_detail_id
36: and wlst.parent_delivery_detail_id = wddp.delivery_detail_id
37: and nvl(wda.parent_delivery_detail_id, -1) <> nvl(wlst.parent_delivery_detail_id,-1)

Line 56: wsh_wms_sync_tmp wlst

52: wddp.lpn_id parent_lpn_id
53: from wsh_delivery_details wddc,
54: wsh_delivery_details wddp,
55: wsh_delivery_assignments_v wda,
56: wsh_wms_sync_tmp wlst
57: where wlst.delivery_detail_id = wda.delivery_detail_id
58: and wddc.delivery_detail_id = wda.delivery_detail_id
59: and wda.parent_delivery_detail_id = wddp.delivery_detail_id
60: and nvl(wda.parent_delivery_detail_id, -1) <> nvl(wlst.parent_delivery_detail_id,-1)

Line 78: wsh_wms_sync_tmp wlst

74: select wdd.lpn_id,
75: wlst.delivery_id old_delivery_id
76: from wsh_delivery_details wdd,
77: wsh_delivery_assignments_v wda,
78: wsh_wms_sync_tmp wlst
79: where wlst.delivery_detail_id = wda.delivery_detail_id
80: and wdd.delivery_detail_id = wda.delivery_detail_id
81: and nvl(wda.delivery_id, -1) <> nvl(wlst.delivery_id,-1)
82: and wlst.delivery_id is not null

Line 99: wsh_wms_sync_tmp wlst

95: select wdd.lpn_id,
96: wda.delivery_id new_delivery_id
97: from wsh_delivery_details wdd,
98: wsh_delivery_assignments_v wda,
99: wsh_wms_sync_tmp wlst
100: where wlst.delivery_detail_id = wda.delivery_detail_id
101: and wdd.delivery_detail_id = wda.delivery_detail_id
102: and nvl(wda.delivery_id, -1) <> nvl(wlst.delivery_id,-1)
103: and wda.delivery_id is not null

Line 129: wsh_wms_sync_tmp wlst

125: wdd.volume,
126: wdd.weight_uom_code,
127: wdd.net_weight
128: from wsh_delivery_details wdd,
129: wsh_wms_sync_tmp wlst
130: where wlst.delivery_detail_id = wdd.delivery_detail_id
131: and wdd.lpn_id is not null
132: and wlst.operation_type = 'UPDATE'
133: and wlst.creation_date = p_hw_time_stamp;

Line 193: select count(*) into l_tmp_tbl_size from wsh_wms_sync_tmp

189: WSH_DEBUG_SV.log(l_module_name,'l_current_hw_time_stamp', l_current_hw_time_stamp);
190: END IF;
191: --
192: IF l_debug_on THEN
193: select count(*) into l_tmp_tbl_size from wsh_wms_sync_tmp
194: where creation_date = l_current_hw_time_stamp;
195: WSH_DEBUG_SV.log(l_module_name,'Count of wsh_wms_sync_tmp table is', l_tmp_tbl_size);
196: END IF;
197:

Line 195: WSH_DEBUG_SV.log(l_module_name,'Count of wsh_wms_sync_tmp table is', l_tmp_tbl_size);

191: --
192: IF l_debug_on THEN
193: select count(*) into l_tmp_tbl_size from wsh_wms_sync_tmp
194: where creation_date = l_current_hw_time_stamp;
195: WSH_DEBUG_SV.log(l_module_name,'Count of wsh_wms_sync_tmp table is', l_tmp_tbl_size);
196: END IF;
197:
198: -- We are doing the following update because, if a particular went through various
199: -- steps of for example, update, assign, unassign, and was finally deleted, then

Line 201: update wsh_wms_sync_tmp

197:
198: -- We are doing the following update because, if a particular went through various
199: -- steps of for example, update, assign, unassign, and was finally deleted, then
200: -- we do not want to call WMS for these operations
201: update wsh_wms_sync_tmp
202: set operation_type = 'DELETE'
203: where delivery_detail_id in (select delivery_detail_id
204: from wsh_wms_sync_tmp
205: where operation_type = 'DELETE'

Line 204: from wsh_wms_sync_tmp

200: -- we do not want to call WMS for these operations
201: update wsh_wms_sync_tmp
202: set operation_type = 'DELETE'
203: where delivery_detail_id in (select delivery_detail_id
204: from wsh_wms_sync_tmp
205: where operation_type = 'DELETE'
206: and creation_date = l_current_hw_time_stamp)
207: and operation_type = 'UPDATE'
208: and creation_date = l_current_hw_time_stamp;

Line 435: p_caller => 'WSH_WMS_SYNC_TMP_PKG',

431: p_commit => FND_API.G_FALSE,
432: x_return_status => l_return_status,
433: x_msg_count => l_msg_count,
434: x_msg_data => l_msg_data,
435: p_caller => 'WSH_WMS_SYNC_TMP_PKG',
436: p_lpn_table => l_wms_lpn_tbl
437: );
438: -- resetting the values back to the original values
439: WSH_WMS_LPN_GRP.g_call_group_api := l_original_call_grp_api;

Line 557: wsh_wms_sync_tmp wlst

553: wdd.weight_uom_code,
554: wdd.net_weight,
555: wlst.call_level
556: from wsh_delivery_details wdd,
557: wsh_wms_sync_tmp wlst
558: where wlst.delivery_detail_id = wdd.delivery_detail_id
559: and wdd.lpn_id is not null
560: and wlst.operation_type = 'UPDATE'
561: and wlst.creation_date = p_hw_time_stamp

Line 647: p_caller => 'WSH_WMS_SYNC_TMP_PKG',

643: p_commit => FND_API.G_FALSE,
644: x_return_status => l_return_status,
645: x_msg_count => l_msg_count,
646: x_msg_data => l_msg_data,
647: p_caller => 'WSH_WMS_SYNC_TMP_PKG',
648: p_lpn_table => l_wms_lpn_tbl
649: );
650: -- resetting the values back to the original values
651: WSH_WMS_LPN_GRP.g_call_group_api := l_original_call_grp_api;

Line 725: p_caller => 'WSH_WMS_SYNC_TMP_PKG',

721: p_commit => FND_API.G_FALSE,
722: x_return_status => l_return_status,
723: x_msg_count => l_msg_count,
724: x_msg_data => l_msg_data,
725: p_caller => 'WSH_WMS_SYNC_TMP_PKG',
726: p_lpn_table => l_wms_lpn_tbl
727: );
728: -- resetting the values back to the original values
729: WSH_WMS_LPN_GRP.g_call_group_api := l_original_call_grp_api;