APPS.INV_MO_PURGE dependencies on MTL_TXN_REQUEST_LINES

Line 46: , mtl_txn_request_lines mtrl

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
50: OR mtrh.organization_id = p_organization_id )

Line 380: DELETE FROM mtl_txn_request_lines

376: END IF;
377:
378: IF (can_delete = 1) THEN
379: -- inv_trx_util_pub.TRACE('DELETED lines---mo_line.line_id= ' ||mo_line.line_id ,'INVMOPG',9);
380: DELETE FROM mtl_txn_request_lines
381: WHERE line_id = mo_line.line_id;
382:
383: can_delete := 0;
384: l_count := l_count + 1;

Line 392: FROM mtl_txn_request_lines

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);
394:
395: IF (SQL%FOUND) THEN
396: l_count := l_count + 1;

Line 414: FROM mtl_txn_request_lines

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);
416:
417: IF (SQL%FOUND) THEN
418: -- Bug 7421347 l_count to be used to count the number of lines deleted, not for header