APPS.INV_MO_PURGE dependencies on MTL_TXN_REQUEST_HEADERS

Line 26: l_prev_header_id mtl_txn_request_headers.header_id%TYPE;

22: oel_exists VARCHAR2(1); -- Added for bug # 6469970
23: l_total_loop NUMBER := 0;
24: l_date_from DATE := fnd_date.canonical_to_date(p_date_from);
25: l_date_to DATE := fnd_date.canonical_to_date(p_date_to);
26: l_prev_header_id mtl_txn_request_headers.header_id%TYPE;
27:
28: -- Bug 4237808
29: -- Rewriting the cursor below to pick up an index (instead of
30: -- full table scan) to improve the SQL performance

Line 41: FROM mtl_txn_request_headers mtrh

37: , NVL(mtrl.quantity_detailed, 0) quantity_detailed
38: , NVL(mtrl.quantity_delivered, 0) quantity_delivered
39: , NVL(required_quantity, 0) required_quantity
40: , txn_source_line_id
41: FROM mtl_txn_request_headers mtrh
42: , mtl_txn_request_lines mtrl
43: WHERE mtrh.header_id = mtrl.header_id
44: AND mtrl.line_status IN (5, 6, 9)
45: AND ( p_organization_id IS NULL

Line 290: DELETE FROM mtl_txn_request_headers

286: END IF;
287:
288: -- For deleting headers
289: IF (l_prev_header_id <> mo_line.header_id) THEN
290: DELETE FROM mtl_txn_request_headers
291: WHERE header_id = l_prev_header_id
292: AND NOT EXISTS( SELECT 1
293: FROM mtl_txn_request_lines
294: WHERE header_id = l_prev_header_id);

Line 312: DELETE FROM mtl_txn_request_headers

308:
309: l_prev_header_id := mo_line.header_id;
310: END LOOP;
311:
312: DELETE FROM mtl_txn_request_headers
313: WHERE header_id = mo_line.header_id
314: AND NOT EXISTS( SELECT 1
315: FROM mtl_txn_request_lines
316: WHERE header_id = mo_line.header_id);