APPS.GMI_UPDATE_ORDER dependencies on WSH_DELIVERY_DETAILS

Line 55: FROM wsh_delivery_details dd, wsh_delivery_assignments da

51: -- Bug 3779795 Added NOT EXISTS to the cursor below so that wdd which is already synchronized to PO
52: -- side is not inserted again in rcv_transactions_interface.
53: CURSOR c_detail_in_delivery is
54: SELECT dd.delivery_detail_id, dd.source_line_id
55: FROM wsh_delivery_details dd, wsh_delivery_assignments da
56: WHERE dd.delivery_detail_id = da.delivery_detail_id
57: AND da.delivery_id = l_delivery_id
58: AND NVL(dd.inv_interfaced_flag , 'N') = 'Y'
59: AND dd.container_flag = 'N'

Line 82: SELECT * from wsh_delivery_details

78:
79: l_group_id NUMBER := 0;
80:
81: CURSOR c_details_for_interface(p_del_detail_id number) is
82: SELECT * from wsh_delivery_details
83: where delivery_detail_id = p_del_detail_id
84: and container_flag = 'N';
85:
86: l_detail_rec c_details_for_interface%ROWTYPE;