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
46: OR mtrh.organization_id = p_organization_id )
277: END IF;
278:
279: IF (can_delete = 1) THEN
280: -- inv_trx_util_pub.TRACE('DELETED lines---mo_line.line_id= ' ||mo_line.line_id ,'INVMOPG',9);
281: DELETE FROM mtl_txn_request_lines
282: WHERE line_id = mo_line.line_id;
283:
284: can_delete := 0;
285: l_count := l_count + 1;
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);
295:
296: IF (SQL%FOUND) THEN
297: l_count := l_count + 1;
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);
317:
318: IF (SQL%FOUND) THEN
319: l_count := l_count + 1;