eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BIM_ACQ_PKG SQL Statements

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

Line: 25


v_num_rows_inserted  integer;

Line: 26


v_num_rows_updated   integer;

Line: 35


l_sql_insert_stm 	varchar2(5000);

Line: 39


l_sql_update_stm 	varchar2(5000);

Line: 44


l_sql_insert_stm := 'INSERT INTO bim_camp_acqu_summ_temp (measure1, measure3, subject_name, view_by_name)';

Line: 46


l_sql_insert_stm := l_sql_insert_stm
                 || ' SELECT ' ;

Line: 49


l_sql_insert_stm := l_sql_insert_stm
                 || ' count(distinct a.cust_account_id) , ';

Line: 52


l_sql_insert_stm := l_sql_insert_stm
                 || ' nvl(sum(a.initiated_revenue), 0 ) , ';

Line: 74


	l_sql_where:= l_sql_where|| ' and b.parent_campaign_id in (select campaign_id from bim_dimv_campaigns where parent_campaign_id is null  and :p_campaign_id is null ) ';

Line: 76


	l_sql_where:= l_sql_where|| ' and b.parent_campaign_id in (select campaign_id from bim_dimv_campaigns where parent_campaign_id = :p_campaign_id ) ';

Line: 145


	l_sql_insert_stm 	:= l_sql_insert_stm || ' d.campaign_name , med.media_name ';

Line: 154


	l_sql_insert_stm  := l_sql_insert_stm || ' d.campaign_name , chn.channel_name ';

Line: 163


	l_sql_insert_stm 	:= l_sql_insert_stm || ' d.campaign_name , sch.sales_channel_name ';

Line: 172


	l_sql_insert_stm 	:= l_sql_insert_stm || ' d.campaign_name , mkt.market_segment_name ';

Line: 180


	l_sql_insert_stm := l_sql_insert_stm || ' d.campaign_name, per.period_name ';

Line: 194


l_sql_stmt := l_sql_insert_stm ||l_sql_from || l_sql_where || l_sql_group_by || l_sql_order_by;

Line: 217


		utl_file.put_line(fp,l_sql_insert_stm);

Line: 273


   v_num_rows_inserted := SQL%ROWCOUNT;

Line: 278


l_sql_update_stm := 'UPDATE bim_camp_acqu_summ_temp tmp
set tmp.measure4 = (select nvl(sum(a.initiated_revenue),0)
from bim_customer_rev_summ a, bim_campaigns_denorm b, bim_dimv_campaigns d ' ;

Line: 286


l_sql_upd_stmt := l_sql_update_stm || from_clause || l_sql_where ;

Line: 369


  UPDATE bim_camp_acqu_summ_temp SET measure2 = measure4*100/measure3;

Line: 371


  v_num_rows_updated := SQL%ROWCOUNT;

Line: 400


v_num_rows_inserted  integer;

Line: 401


v_num_rows_updated   integer;

Line: 410


l_sql_insert_stm 	varchar2(5000);

Line: 414


l_sql_update_stm 	varchar2(5000);

Line: 419


l_sql_insert_stm := 'INSERT INTO bim_camp_acqu_summ_temp (measure1, measure3, subject_name, view_by_name)';

Line: 421


l_sql_insert_stm := l_sql_insert_stm
                 || ' SELECT ' ;

Line: 424


l_sql_insert_stm := l_sql_insert_stm
                 || ' count(distinct a.cust_account_id) , ';

Line: 427


l_sql_insert_stm := l_sql_insert_stm
                 || ' nvl(sum(a.initiated_revenue), 0 ) , ';

Line: 513


	l_sql_insert_stm 	:= l_sql_insert_stm || ' :p_all_value , med.media_name ';

Line: 522


	l_sql_insert_stm  := l_sql_insert_stm || ' :p_all_value , chn.channel_name ';

Line: 531


	l_sql_insert_stm 	:= l_sql_insert_stm || ' :p_all_value , sch.sales_channel_name ';

Line: 540


	l_sql_insert_stm 	:= l_sql_insert_stm || ' :p_all_value , mkt.market_segment_name ';

Line: 548


	l_sql_insert_stm := l_sql_insert_stm || ' :p_all_value , per.period_name ';

Line: 563


l_sql_stmt := l_sql_insert_stm ||l_sql_from || l_sql_where || l_sql_group_by || l_sql_order_by;

Line: 574


		utl_file.put_line(fp,l_sql_insert_stm);

Line: 634


   v_num_rows_inserted := SQL%ROWCOUNT;

Line: 639


l_sql_update_stm := 'UPDATE bim_camp_acqu_summ_temp tmp set tmp.measure4 = (select nvl(sum(a.initiated_revenue),0) from bim_customer_rev_summ a, bim_campaigns_denorm b ' ;

Line: 645


l_sql_upd_stmt := l_sql_update_stm || from_clause || l_sql_where ;

Line: 722


UPDATE bim_camp_acqu_summ_temp SET measure2 = measure4*100/measure3;

Line: 725


  v_num_rows_updated := SQL%ROWCOUNT;

Line: 754


v_num_rows_inserted  integer;

Line: 755


v_num_rows_updated   integer;

Line: 764


l_sql_insert_stm 	varchar2(5000);

Line: 768


l_sql_update_stm 	varchar2(5000);

Line: 773


l_sql_insert_stm := 'INSERT INTO bim_camp_acqu_summ_temp (measure1, measure3, subject_name, view_by_name)';

Line: 775


l_sql_insert_stm := l_sql_insert_stm
                 || ' SELECT ' ;

Line: 778


l_sql_insert_stm := l_sql_insert_stm
                 || ' count(distinct a.cust_account_id) , ';

Line: 781


l_sql_insert_stm := l_sql_insert_stm
                 || ' nvl(sum(a.initiated_revenue), 0 ) , ';

Line: 859


	l_sql_insert_stm 	:= l_sql_insert_stm || ' :p_all_value , cmp.campaign_name ';

Line: 868


	l_sql_insert_stm  := l_sql_insert_stm || ' :p_all_value , chn.channel_name ';

Line: 877


	l_sql_insert_stm 	:= l_sql_insert_stm || ' :p_all_value , sch.sales_channel_name ';

Line: 886


	l_sql_insert_stm 	:= l_sql_insert_stm || ' :p_all_value , mkt.market_segment_name ';

Line: 894


	l_sql_insert_stm := l_sql_insert_stm || ' :p_all_value , per.period_name ';

Line: 908


l_sql_stmt := l_sql_insert_stm ||l_sql_from || l_sql_where || l_sql_group_by || l_sql_order_by;

Line: 920


		utl_file.put_line(fp,l_sql_insert_stm);

Line: 979


   v_num_rows_inserted := SQL%ROWCOUNT;

Line: 984


l_sql_update_stm := 'UPDATE bim_camp_acqu_summ_temp tmp set tmp.measure4 = (select nvl(sum(a.initiated_revenue),0) from bim_customer_rev_summ a ' ;

Line: 990


l_sql_upd_stmt := l_sql_update_stm || from_clause || l_sql_where ;

Line: 1065


UPDATE bim_camp_acqu_summ_temp SET measure2 = measure4*100/measure3;

Line: 1067


  v_num_rows_updated := SQL%ROWCOUNT;

Line: 1094


v_num_rows_inserted  integer;

Line: 1095


v_num_rows_updated   integer;

Line: 1104


l_sql_insert_stm 	varchar2(5000);

Line: 1108


l_sql_update_stm 	varchar2(5000);

Line: 1115


l_sql_insert_stm := 'INSERT INTO bim_camp_acqu_summ_temp (measure1, measure3, subject_name, view_by_name)';

Line: 1117


l_sql_insert_stm := l_sql_insert_stm
                 || ' SELECT ' ;

Line: 1120


l_sql_insert_stm := l_sql_insert_stm
                 || ' count(distinct a.cust_account_id) , ';

Line: 1123


l_sql_insert_stm := l_sql_insert_stm
                 || ' nvl(sum(a.initiated_revenue), 0 ) , ';

Line: 1132


l_sql_where:= l_sql_where|| ' and a.campaign_id in (select parent_campaign_id from bim_campaigns_denorm';

Line: 1219


	l_sql_insert_stm 	:= l_sql_insert_stm || ' med.media_name , cmp.campaign_name ';

Line: 1228


	l_sql_insert_stm  := l_sql_insert_stm || ' med.media_name , chn.channel_name ';

Line: 1237


	l_sql_insert_stm 	:= l_sql_insert_stm || ' med.media_name , sch.sales_channel_name ';

Line: 1246


	l_sql_insert_stm 	:= l_sql_insert_stm || ' med.media_name , mkt.market_segment_name ';

Line: 1254


	l_sql_insert_stm := l_sql_insert_stm || ' med.media_name , per.period_name ';

Line: 1266


l_sql_stmt := l_sql_insert_stm ||l_sql_from || l_sql_where || l_sql_group_by || l_sql_order_by;

Line: 1278


		utl_file.put_line(fp,l_sql_insert_stm);

Line: 1330


   v_num_rows_inserted := SQL%ROWCOUNT;

Line: 1335


l_sql_update_stm := 'UPDATE bim_camp_acqu_summ_temp tmp set tmp.measure4 = (select nvl(sum(a.initiated_revenue),0) from bim_customer_rev_summ a, bim_dimv_media med ' ;

Line: 1341


l_sql_upd_stmt := l_sql_update_stm || from_clause || l_sql_where ;

Line: 1424


UPDATE bim_camp_acqu_summ_temp SET measure2 = measure4*100/measure3;

Line: 1426


v_num_rows_updated := SQL%ROWCOUNT;

Line: 1458


v_num_rows_inserted  integer;

Line: 1459


v_num_rows_updated   integer;

Line: 1468


l_sql_insert_stm 	varchar2(5000);

Line: 1472


l_sql_update_stm 	varchar2(5000);

Line: 1477


l_sql_insert_stm := 'INSERT INTO bim_camp_acqu_summ_temp (measure1, measure3, subject_name, view_by_name)';

Line: 1479


l_sql_insert_stm := l_sql_insert_stm
                 || ' SELECT ' ;

Line: 1482


l_sql_insert_stm := l_sql_insert_stm
                 || ' count(distinct a.cust_account_id) , ';

Line: 1485


l_sql_insert_stm := l_sql_insert_stm
                 || ' nvl(sum(a.initiated_revenue), 0 ) , ';

Line: 1563


	l_sql_insert_stm 	:= l_sql_insert_stm || ' :p_all_value , cmp.campaign_name ';

Line: 1572


	l_sql_insert_stm  := l_sql_insert_stm || ' :p_all_value ,med.media_name ';

Line: 1581


	l_sql_insert_stm 	:= l_sql_insert_stm || ' :p_all_value , sch.sales_channel_name ';

Line: 1590


	l_sql_insert_stm 	:= l_sql_insert_stm || ' :p_all_value , mkt.market_segment_name ';

Line: 1598


	l_sql_insert_stm := l_sql_insert_stm || ' :p_all_value , per.period_name ';

Line: 1612


l_sql_stmt := l_sql_insert_stm ||l_sql_from || l_sql_where || l_sql_group_by || l_sql_order_by;

Line: 1624


		utl_file.put_line(fp,l_sql_insert_stm);

Line: 1682


   v_num_rows_inserted := SQL%ROWCOUNT;

Line: 1687


l_sql_update_stm := 'UPDATE bim_camp_acqu_summ_temp tmp set tmp.measure4 = (select nvl(sum(a.initiated_revenue),0) from bim_customer_rev_summ a ' ;

Line: 1693


l_sql_upd_stmt := l_sql_update_stm || from_clause || l_sql_where ;

Line: 1767


UPDATE bim_camp_acqu_summ_temp SET measure2 = measure4*100/measure3;

Line: 1769


v_num_rows_updated := SQL%ROWCOUNT;

Line: 1796


v_num_rows_inserted  integer;

Line: 1797


v_num_rows_updated   integer;

Line: 1806


l_sql_insert_stm 	varchar2(5000);

Line: 1810


l_sql_update_stm 	varchar2(5000);

Line: 1817


l_sql_insert_stm := 'INSERT INTO bim_camp_acqu_summ_temp (measure1, measure3, subject_name, view_by_name)';

Line: 1819


l_sql_insert_stm := l_sql_insert_stm
                 || ' SELECT ' ;

Line: 1822


l_sql_insert_stm := l_sql_insert_stm
                 || ' count(distinct a.cust_account_id) , ';

Line: 1825


l_sql_insert_stm := l_sql_insert_stm
                 || ' nvl(sum(a.initiated_revenue), 0 ) , ';

Line: 1834


l_sql_where:= l_sql_where|| ' and a.campaign_id in (select parent_campaign_id from bim_campaigns_denorm';

Line: 1921


	l_sql_insert_stm 	:= l_sql_insert_stm || ' chn.channel_name , cmp.campaign_name ';

Line: 1930


	l_sql_insert_stm  := l_sql_insert_stm || ' chn.channel_name , med.media_name ';

Line: 1939


	l_sql_insert_stm 	:= l_sql_insert_stm || ' chn.channel_name, sch.sales_channel_name ';

Line: 1948


	l_sql_insert_stm 	:= l_sql_insert_stm || ' chn.channel_name , mkt.market_segment_name ';

Line: 1956


	l_sql_insert_stm := l_sql_insert_stm || ' chn.channel_name, per.period_name ';

Line: 1968


l_sql_stmt := l_sql_insert_stm ||l_sql_from || l_sql_where || l_sql_group_by || l_sql_order_by;

Line: 1979


		utl_file.put_line(fp,l_sql_insert_stm);

Line: 2032


   v_num_rows_inserted := SQL%ROWCOUNT;

Line: 2037


l_sql_update_stm := 'UPDATE bim_camp_acqu_summ_temp tmp set tmp.measure4 = (select nvl(sum(a.initiated_revenue),0) from bim_customer_rev_summ a, bim_dimv_channels chn ' ;

Line: 2043


l_sql_upd_stmt := l_sql_update_stm || from_clause || l_sql_where ;

Line: 2125


UPDATE bim_camp_acqu_summ_temp SET measure2 = measure4*100/measure3;

Line: 2127


v_num_rows_updated := SQL%ROWCOUNT;