APPS.WSH_LPN_SYNC_COMM_PKG dependencies on WSH_DELIVERY_ASSIGNMENTS_V

Line 32: wsh_delivery_assignments_v wda,

28: select wddc.lpn_id,
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

Line 55: wsh_delivery_assignments_v wda,

51: select wddc.lpn_id,
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

Line 77: wsh_delivery_assignments_v wda,

73: cursor l_unassign_csr (p_hw_time_stamp IN DATE) is
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)

Line 98: wsh_delivery_assignments_v wda,

94: cursor l_assign_csr (p_hw_time_stamp IN DATE) is
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)