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: -- Bug 7421347 Added l_entity_type
28: l_entity_type NUMBER;
29:
30: -- Bug 4237808

Line 45: FROM mtl_txn_request_headers mtrh

41: , NVL(required_quantity, 0) required_quantity
42: , mtrl.txn_source_line_id
43: , mtrl.txn_source_id
44: , mtrl.organization_id
45: FROM mtl_txn_request_headers mtrh
46: , mtl_txn_request_lines mtrl
47: WHERE mtrh.header_id = mtrl.header_id
48: AND mtrl.line_status IN (5, 6, 9)
49: AND ( p_organization_id IS NULL

Line 389: DELETE FROM mtl_txn_request_headers

385: END IF;
386:
387: -- For deleting headers
388: IF (l_prev_header_id <> mo_line.header_id) THEN
389: DELETE FROM mtl_txn_request_headers
390: WHERE header_id = l_prev_header_id
391: AND NOT EXISTS( SELECT 1
392: FROM mtl_txn_request_lines
393: WHERE header_id = l_prev_header_id);

Line 411: DELETE FROM mtl_txn_request_headers

407:
408: l_prev_header_id := mo_line.header_id;
409: END LOOP;
410:
411: DELETE FROM mtl_txn_request_headers
412: WHERE header_id = mo_line.header_id
413: AND NOT EXISTS( SELECT 1
414: FROM mtl_txn_request_lines
415: WHERE header_id = mo_line.header_id);