APPS.BIM_PERIODIC_FACTS SQL Statements

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

Line: 17

SELECT  TRUNC(MIN(start_date))
FROM    bim_rep_history ;

Line: 21

select TRUNC(max(object_last_updated_date))
from bim_rep_history
where object='DATES';

Line: 43

SELECT 	'TRUNCATE TABLE '|| owner ||'.' || table_name  sqlstmt
FROM	all_tables
WHERE	table_name like  'BIM_R_CAMP_%LY%_FACTS'
AND	owner = p_owner
AND	table_name not like '%_MV%';

Line: 50

SELECT 	'TRUNCATE TABLE '|| owner ||'.' || table_name  sqlstmt
FROM	all_tables
WHERE	table_name like  'BIM_R_EVEN_%LY%_FACTS'
AND	owner = p_owner
AND	table_name not like '%_MV%';

Line: 57

SELECT 	'TRUNCATE TABLE '|| owner ||'.' || table_name  sqlstmt
FROM	all_tables
WHERE   (table_name like  'BIM_R_FUND_%LY%_FACTS' or table_name like 'BIM_R_FDSP_%LY%_FACTS')
AND	owner = p_owner
AND	table_name not like '%_MV%';

Line: 64

SELECT 'TRUNCATE TABLE ' || owner ||'.'||table_name sqlstmt
FROM   all_tables
WHERE  table_name like 'BIM_R_LEAD_%_FACTS'
AND    owner = p_owner
AND    table_name not like '%_MV%';

Line: 71

SELECT 'TRUNCATE TABLE ' || owner ||'.'||table_name sqlstmt
FROM   all_tables
WHERE  table_name like 'BIM_R_LIMP_%LY%_FACTS'
AND    owner = p_owner
AND    table_name not like '%_MV%';

Line: 78

SELECT 'TRUNCATE TABLE ' || owner ||'.'||table_name sqlstmt
FROM    all_tables
WHERE   (table_name like 'BIM_R_RRSN_%LY%_FACTS' OR table_name like 'BIM_R_RGRD_%LY%_FACTS')
AND     owner = p_owner
AND     table_name not like '%_MV%';

Line: 113

DELETE bim_rep_history
WHERE  object = 'CAMPAIGN';

Line: 134

DELETE bim_rep_history
WHERE  object = 'EVENT';

Line: 155

DELETE BIM_REP_HISTORY
WHERE  object = 'FUND';

Line: 176

DELETE BIM_REP_HISTORY
WHERE object = 'LEADS';

Line: 197

DELETE BIM_REP_HISTORY
WHERE object = 'LEAD_IMPORT';

Line: 218

DELETE BIM_REP_HISTORY
WHERE object = 'RESPONSE';

Line: 237

   DELETE bim_rep_history
   WHERE  object = 'CAMPAIGN';

Line: 248

   DELETE bim_rep_history
   WHERE  object = 'EVENT';

Line: 259

   DELETE bim_rep_history
   WHERE  object = 'FUND';

Line: 271

   DELETE BIM_REP_HISTORY
   WHERE object = 'LEADS';

Line: 282

   DELETE BIM_REP_HISTORY
   WHERE object = 'LEAD_IMPORT';

Line: 293

   DELETE BIM_REP_HISTORY
   WHERE object = 'RESPONSE';

Line: 300

DELETE bim_rep_history
WHERE  object = 'DATES';