APPS.ICX_CLEAN SQL Statements

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

Line: 8

/* Delete rows older than 4 hours */

	delete	icx_text
	where   to_number(to_char(TIMESTAMP,'SSSSS'))
                < to_number(to_char(SYSDATE,'SSSSS')) - (4 * 60 * 60);

Line: 15

/* Delete rows older than 12 hours */

        delete  icx_session_attributes
        where   session_id in
                (select session_id
                 from   icx_sessions
                 where  to_number(to_char(CREATION_DATE,'SSSSS'))
                 < to_number(to_char(SYSDATE,'SSSSS')) - (12 * 60 * 60));

Line: 25

	delete	icx_sessions
	where	to_number(to_char(CREATION_DATE,'SSSSS'))
		< to_number(to_char(SYSDATE,'SSSSS')) - (12 * 60 * 60);

Line: 30

        delete  icx_session_attributes
        where   session_id not in
                (select session_id
                 from   icx_sessions);

Line: 36

/* Delete rows older than 12 hours */

        delete  icx_transactions
        where   to_number(to_char(CREATION_DATE,'SSSSS'))
                < to_number(to_char(SYSDATE,'SSSSS')) - (12 * 60 * 60);

Line: 42

/* Delete rows older than 30 days */

        delete  icx_failures
        where   to_number(to_char(CREATION_DATE,'J'))
                < to_number(to_char(SYSDATE,'J')) - 30;

Line: 49

/* Delete rows older than 4 hours */

        delete  icx_context_results_temp
        where   to_number(to_char(DATESTAMP,'SSSSS'))
                < to_number(to_char(SYSDATE,'SSSSS')) - (1 * 60 * 60);

Line: 56

/* Delete rows older than 12 hours.  FND_SESSION_VALUES table should be
   purged when ICX_SESSIONS table is purged. */

        delete  fnd_session_values
        where   to_number(to_char(TIMESTAMP,'SSSSS'))
                < to_number(to_char(SYSDATE,'SSSSS')) - (12 * 60 * 60);

Line: 65

        delete  cs_incidents_ctx_results
        where   to_number(to_char(DATESTAMP,'SSSSS'))
                < to_number(to_char(SYSDATE,'SSSSS')) - (1 * 60 * 60);