APPS.INV_TXN_PURGE_WORKER SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 46

       SELECT ROWID, TRANSACTION_ID
       FROM     MTL_MATERIAL_TRANSACTIONS
       WHERE    transaction_date >= l_min_date and transaction_date <= l_max_date + 1-(1/(24*3600))
                AND organization_id = p_organization_id;

Line: 52

       SELECT ROWID
       FROM     MTL_MATERIAL_TXN_ALLOCATIONS
       WHERE    transaction_date >= l_min_date and transaction_date <= l_max_date + 1-(1/(24*3600))
                AND organization_id = p_organization_id;

Line: 58

       SELECT ROWID
       FROM     MTL_TRANSACTION_LOT_NUMBERS
       WHERE    transaction_date >= l_min_date and transaction_date <= l_max_date + 1-(1/(24*3600))
                AND organization_id = p_organization_id;

Line: 64

       SELECT ROWID
       FROM     MTL_UNIT_TRANSACTIONS
       WHERE    transaction_date >= l_min_date and transaction_date <= l_max_date + 1-(1/(24*3600))
                AND organization_id = p_organization_id;

Line: 71

       SELECT ROWID
       FROM     MTL_TRANSACTION_ACCOUNTS
       WHERE    transaction_date >= l_min_date and transaction_date <= l_max_date + 1-(1/(24*3600))
                AND organization_id = p_organization_id;

Line: 95

          SELECT 1
              into l_tempvar
            FROM ORG_ACCT_PERIODS
           WHERE ORGANIZATION_ID = p_organization_id
             AND SCHEDULE_CLOSE_DATE >= l_max_date
             AND OPEN_FLAG = 'N' AND ROWNUM < 2;

Line: 123

    		 inv_log_util.trace('Purge Worker : No more Records to delete from MMTA','TXN_PURGE_WORKER', 9);

Line: 129

		DELETE FROM MTL_MATERIAL_TXN_ALLOCATIONS
		WHERE ROWID = rowid_list(i);

Line: 140

       inv_log_util.trace('Deleted :'||l_total_count||' rows from MMTA', 'TXN_PURGE_WORKER', 9);

Line: 153

    		 inv_log_util.trace('Purge Worker : No more Records to delete from MTLN','TXN_PURGE_WORKER', 9);

Line: 159

		DELETE FROM MTL_TRANSACTION_LOT_NUMBERS
		WHERE ROWID = rowid_list(i);

Line: 170

       inv_log_util.trace('Deleted :'||l_total_count||' rows from MTLN', 'TXN_PURGE_WORKER', 9);

Line: 183

    		 inv_log_util.trace('Purge Worker : No more Records to delete from MUT','TXN_PURGE_WORKER', 9);

Line: 189

		DELETE FROM MTL_UNIT_TRANSACTIONS
		WHERE ROWID = rowid_list(i);

Line: 200

       inv_log_util.trace('Deleted :'||l_total_count||' rows from MUT', 'TXN_PURGE_WORKER', 9);

Line: 213

    		 inv_log_util.trace('Purge Worker : No more Records to delete from MTA','TXN_PURGE_WORKER', 9);

Line: 219

		DELETE FROM MTL_TRANSACTION_ACCOUNTS
		WHERE ROWID = rowid_list(i);

Line: 230

       inv_log_util.trace('Deleted :'||l_total_count||' rows from MTA', 'TXN_PURGE_WORKER', 9);

Line: 248

    		 inv_log_util.trace('Purge Worker : No more Records to delete from MMT for dependant tables','TXN_PURGE_WORKER', 9);

Line: 257

		DELETE FROM WIP_SCRAP_VALUES
		WHERE TRANSACTION_ID = tranid_list(i);

Line: 268

		DELETE FROM MTL_CST_ACTUAL_COST_DETAILS
		WHERE TRANSACTION_ID = tranid_list(i);

Line: 279

		DELETE FROM MTL_CST_TXN_COST_DETAILS
		WHERE TRANSACTION_ID = tranid_list(i);

Line: 290

		DELETE FROM MTL_ACTUAL_COST_SUBELEMENT
		WHERE TRANSACTION_ID = tranid_list(i);

Line: 301

		DELETE FROM MTL_MATERIAL_TRANSACTIONS
		WHERE ROWID = rowid_list(i);

Line: 313

	inv_log_util.trace('Deleted :'||l_total_count1||' rows from WSV', 'TXN_PURGE_WORKER', 9);

Line: 314

	inv_log_util.trace('Deleted :'||l_total_count2||' rows from MCACD', 'TXN_PURGE_WORKER', 9);

Line: 315

	inv_log_util.trace('Deleted :'||l_total_count3||' rows from MCTCD', 'TXN_PURGE_WORKER', 9);

Line: 316

	inv_log_util.trace('Deleted :'||l_total_count4||' rows from MACS', 'TXN_PURGE_WORKER', 9);

Line: 317

	inv_log_util.trace('Deleted :'||l_total_count ||' rows from MMT', 'TXN_PURGE_WORKER', 9);