APPS.INV_MO_PURGE dependencies on WSH_DELIVERY_DETAILS

Line 96: FROM wsh_delivery_details wsd

92: oel_exists := 'Y'; -- Added for bug # 6469970
93: BEGIN
94: SELECT 1
95: INTO can_delete
96: FROM wsh_delivery_details wsd
97: WHERE wsd.move_order_line_id = mo_line.line_id
98: AND wsd.inv_interfaced_flag = 'Y'
99: AND ROWNUM < 2;
100:

Line 127: FROM wsh_delivery_details wdd

123: WHERE oola.line_id = mo_line.txn_source_line_id
124: AND ( (NVL(open_flag, 'Y') = 'N') OR cancelled_flag = 'Y')
125: AND NOT EXISTS (
126: SELECT 1
127: FROM wsh_delivery_details wdd
128: WHERE wdd.source_line_id = oola.line_id
129: AND wdd.inv_interfaced_flag IN ('N', 'P')
130: AND wdd.released_status <> 'D')
131: AND ROWNUM =1;

Line 160: FROM wsh_delivery_details wdd

156: FROM mtl_material_transactions_temp mmtt
157: WHERE mmtt.move_order_line_id = mo_line.line_id)
158: AND NOT EXISTS (
159: SELECT 1
160: FROM wsh_delivery_details wdd
161: WHERE wdd.source_line_id = oola.line_id
162: AND wdd.source_code = 'OE'
163: AND wdd.move_order_line_id = mo_line.line_id)
164: AND ROWNUM = 1;

Line 175: FROM wsh_delivery_details wdd

171: -- Start of Bug #6469970
172: IF (can_delete = 0) THEN
173: BEGIN
174: SELECT distinct wdd.inv_interfaced_flag into inv_int_flag
175: FROM wsh_delivery_details wdd
176: WHERE wdd.move_order_line_id = mo_line.line_id;
177:
178: IF inv_int_flag = 'Y' THEN
179: can_delete := 1;