APPS.INV_TXN_PURGE_WORKER dependencies on MTL_UNIT_TRANSACTIONS

Line 65: FROM MTL_UNIT_TRANSACTIONS

61: AND organization_id = p_organization_id;
62:
63: CURSOR c_mut IS
64: SELECT ROWID
65: FROM MTL_UNIT_TRANSACTIONS
66: WHERE transaction_date >= l_min_date and transaction_date <= l_max_date + 1-(1/(24*3600))
67: AND organization_id = p_organization_id;
68:
69: -- bug 4951747 : removed trunc to leverage MTL_TRANSACTION_ACCOUNTS_N5 index

Line 173: -- *************** Purge from MTL_UNIT_TRANSACTIONS ******************

169: IF (l_debug = 1) THEN
170: inv_log_util.trace('Deleted :'||l_total_count||' rows from MTLN', 'TXN_PURGE_WORKER', 9);
171: END IF;
172:
173: -- *************** Purge from MTL_UNIT_TRANSACTIONS ******************
174: l_total_count := 0;
175: OPEN c_mut;
176: LOOP
177: l_count := 0;

Line 189: DELETE FROM MTL_UNIT_TRANSACTIONS

185: EXIT;
186: END IF;
187:
188: FORALL i IN rowid_list.first .. rowid_list.last
189: DELETE FROM MTL_UNIT_TRANSACTIONS
190: WHERE ROWID = rowid_list(i);
191:
192: l_count := SQL%ROWCOUNT;
193: COMMIT;