APPS.WSH_INBOUND_SHIP_ADVICE_PKG dependencies on WSH_DELIVERY_ASSIGNMENTS_V

Line 66: FROM wsh_delivery_assignments_v wda,

62: AND INTERFACE_ACTION_CODE ='94X_INBOUND';
63:
64: CURSOR cont_not_recv_cur(l_delivery_id NUMBER, l_delivery_interface_id NUMBER) IS
65: SELECT wda.delivery_detail_id
66: FROM wsh_delivery_assignments_v wda,
67: wsh_delivery_details wdd
68: where wdd.delivery_detail_id = wda.delivery_detail_id
69: and wdd.container_flag = 'Y'
70: and wda.parent_delivery_detail_id IS NULL

Line 87: FROM wsh_delivery_assignments_v wda

83: AND WDDI.INTERFACE_ACTION_CODE = '94X_INBOUND';
84:
85: CURSOR cont_contents_cur(l_del_detail_id NUMBER) IS
86: SELECT wda.delivery_detail_id
87: FROM wsh_delivery_assignments_v wda
88: WHERE parent_delivery_detail_id IS NOT NULL
89: START WITH wda.delivery_detail_id = l_del_detail_id
90: CONNECT BY PRIOR delivery_detail_id = parent_delivery_detail_id;
91:

Line 280: FROM wsh_delivery_assignments_v

276: UPDATE wsh_delivery_details
277: SET released_status = 'Y'
278: WHERE delivery_detail_id IN (
279: SELECT delivery_detail_id
280: FROM wsh_delivery_assignments_v
281: WHERE delivery_id = l_delivery_id)
282: AND released_status IN ('R', 'B', 'X')
283: AND container_flag = 'N'
284: RETURNING delivery_detail_id BULK COLLECT INTO l_detail_tab; -- Added for DBI Project;