APPS.ONT_ACTIVITY_SUM_ORDER_PURGE SQL Statements

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

Line: 12

	SELECT  count(*) total
	  FROM fnd_concurrent_requests
	 WHERE phase_code = 'C'
	   AND program_application_id = 660
	   AND concurrent_program_id = (SELECT concurrent_program_id
					  FROM fnd_concurrent_programs
					 WHERE concurrent_program_name = 'ORDPUR'
					   AND application_id = 660)
	   AND requested_by = FND_GLOBAL.USER_ID;

Line: 34

	SELECT count(*)
	  INTO l_count
	  FROM fnd_concurrent_requests
	 WHERE phase_code = 'C'
	   AND program_application_id = 660
	   AND concurrent_program_id = (SELECT concurrent_program_id
					  FROM fnd_concurrent_programs
					 WHERE concurrent_program_name = 'ORDPUR'
					   AND application_id = 660);

Line: 46

   fnd_conc_summarizer.insert_row(l_temp_name, to_char(l_count));

Line: 60

      fnd_conc_summarizer.insert_row(l_temp_name, to_char(l_count_logged_user));

Line: 72

	SELECT COUNT (*)
	  INTO l_count
	  FROM fnd_concurrent_processes
	 WHERE process_status_code NOT IN ('A', 'C', 'T', 'M')
	   AND concurrent_process_id IN
		     (SELECT controlling_manager
			FROM fnd_concurrent_requests
		       WHERE phase_code = 'C'
			 AND program_application_id = 660
			 AND concurrent_program_id =
				   (SELECT concurrent_program_id
				      FROM fnd_concurrent_programs
				     WHERE concurrent_program_name = 'ORDPUR'
				       AND application_id = 660));

Line: 90

     fnd_conc_summarizer.insert_row(l_temp_name, to_char(l_count));

Line: 99

  	SELECT count(*)
	INTO l_count
	FROM fnd_crm_history
	WHERE work_start < sysdate -1 ;

Line: 104

     fnd_conc_summarizer.insert_row(l_temp_name, to_char(l_count));

Line: 113

	SELECT COUNT (*)
	  INTO l_count
	  FROM fnd_tm_events
	 WHERE TIMESTAMP <   SYSDATE - 1
	   AND (program_application_id, concurrent_program_id) IN
		     (SELECT application_id, concurrent_program_id
			FROM fnd_concurrent_programs
		       WHERE concurrent_program_name = 'ORDPUR'
			 AND application_id = 660);

Line: 124

    fnd_conc_summarizer.insert_row(l_temp_name, to_char(l_count));