APPS.IBW_PURGE_PVT SQL Statements

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

Line: 55

		SELECT COUNT(distinct(visit_id)) into visit_count FROM ibw_site_visits
		WHERE visit_start_time BETWEEN start_date AND end_date;

Line: 59

		DELETE FROM ibw_site_visits
		WHERE visit_start_time between start_date AND end_date;

Line: 64

		SELECT count(page_view_id)into page_view_count FROM ibw_page_views pv
		WHERE 0 = (SELECT COUNT(visit_id)
 			       FROM ibw_site_visits v
	  		      WHERE v.visit_id=pv.visit_id);

Line: 70

		DELETE 	FROM ibw_page_views pv
		WHERE 0 = (SELECT COUNT(visit_id)
 			       FROM ibw_site_visits v
	  		      WHERE v.visit_id=pv.visit_id);

Line: 76

		DELETE 	FROM ibw_page_views_tmp pv
		WHERE 0 = (SELECT COUNT(visit_id)
			       FROM ibw_site_visits v
	  		      WHERE v.visit_id=pv.visit_id);

Line: 82

		SELECT count(visitor_id) into visitor_count FROM ibw_visitors visitors
		WHERE 0 = (SELECT COUNT(visitor_id)
					FROM  ibw_site_visits visit
					WHERE visit.visitor_id=visitors.visitor_id);

Line: 88

		DELETE FROM ibw_visitors visitors
		WHERE 0 = (SELECT COUNT(visitor_id)
					FROM  ibw_site_visits visit
					WHERE visit.visitor_id=visitors.visitor_id);

Line: 94

		DELETE FROM ibw_page_instances pi
		WHERE 0 = (SELECT COUNT(page_instance_id)
		        	FROM ibw_page_views pv
					WHERE pv.page_instance_id=pi.page_instance_id);

Line: 126

		SELECT COUNT(distinct(site_visit_id)) cnt INTO visit_count
		FROM  ibw_site_visits
		WHERE visit_start_time between start_date AND end_date;

Line: 131

		SELECT COUNT(page_view_id) INTO page_view_count
		FROM ibw_page_views pv
		WHERE visit_id IN (SELECT visit_id
 			       FROM ibw_site_visits v
				     WHERE visit_start_time BETWEEN start_date AND end_date);

Line: 138

		SELECT COUNT(visitor_id) INTO visitor_count
		FROM ibw_visitors visitors
		WHERE 0= (SELECT count(visitor_id)
					FROM  ibw_site_visits visit
					WHERE visit_start_time NOT BETWEEN start_date AND end_date);

Line: 296

		SELECT COUNT(site_visit_id) INTO cnt
		FROM  ibw_site_visits
		WHERE visit_start_time between startDate AND end_date;

Line: 301

		fnd_conc_summarizer.insert_row(temp_name, to_char(cnt));

Line: 304

		SELECT COUNT(page_view_id) INTO cnt
		FROM ibw_page_views pv
		WHERE 0 = (SELECT COUNT(visit_id)
 			       FROM ibw_site_visits v
				     WHERE v.visit_id=pv.visit_id);

Line: 311

		fnd_conc_summarizer.insert_row(temp_name, to_char(cnt));

Line: 315

		SELECT COUNT(visitor_id) INTO cnt
		FROM ibw_visitors visitors
		WHERE 0 = (SELECT COUNT(visitor_id)
					FROM  ibw_site_visits visit
					WHERE visit.visitor_id=visitors.visitor_id);

Line: 322

		fnd_conc_summarizer.insert_row(temp_name, to_char(cnt));