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_LEAD_FACTS_PKG dependencies on BIM_R_LEAD_WEEKLY_FACTS

Line 441: EXECUTE IMMEDIATE 'ALTER TABLE '||l_schema||'.bim_r_lead_weekly_facts nologging ';

437: EXECUTE IMMEDIATE 'ALTER SESSION ENABLE PARALLEL dml ';
438:
439: EXECUTE IMMEDIATE 'ALTER TABLE '||l_schema||'.bim_r_lead_daily_facts nologging ';
440:
441: EXECUTE IMMEDIATE 'ALTER TABLE '||l_schema||'.bim_r_lead_weekly_facts nologging ';
442:
443: EXECUTE IMMEDIATE 'ALTER sequence '||l_schema||'.bim_r_lead_daily_facts_s CACHE 1000 ';
444:
445: EXECUTE IMMEDIATE 'ALTER sequence '||l_schema||'.bim_r_lead_weekly_facts_s CACHE 1000 ';

Line 445: EXECUTE IMMEDIATE 'ALTER sequence '||l_schema||'.bim_r_lead_weekly_facts_s CACHE 1000 ';

441: EXECUTE IMMEDIATE 'ALTER TABLE '||l_schema||'.bim_r_lead_weekly_facts nologging ';
442:
443: EXECUTE IMMEDIATE 'ALTER sequence '||l_schema||'.bim_r_lead_daily_facts_s CACHE 1000 ';
444:
445: EXECUTE IMMEDIATE 'ALTER sequence '||l_schema||'.bim_r_lead_weekly_facts_s CACHE 1000 ';
446:
447: /* Dropping INdexes */
448: BIM_UTL_PKG.DROP_INDEX('BIM_R_LEAD_DAILY_FACTS');
449: BIM_UTL_PKG.DROP_INDEX('BIM_R_LEAD_WEEKLY_FACTS');

Line 449: BIM_UTL_PKG.DROP_INDEX('BIM_R_LEAD_WEEKLY_FACTS');

445: EXECUTE IMMEDIATE 'ALTER sequence '||l_schema||'.bim_r_lead_weekly_facts_s CACHE 1000 ';
446:
447: /* Dropping INdexes */
448: BIM_UTL_PKG.DROP_INDEX('BIM_R_LEAD_DAILY_FACTS');
449: BIM_UTL_PKG.DROP_INDEX('BIM_R_LEAD_WEEKLY_FACTS');
450:
451:
452:
453: l_table_name := 'BIM_R_LEAD_DAILY_FACTS';

Line 860: l_table_name := 'BIM_R_LEAD_WEEKLY_FACTS';

856:
857: /* Here we are inserting the summarized data into the weekly facts by taking it from the daily facts.
858: For every week we have a record since we group by that weekend date which is nothing but the Load date. */
859:
860: l_table_name := 'BIM_R_LEAD_WEEKLY_FACTS';
861: fnd_message.set_name('BIM','BIM_R_POPULATE_TABLE');
862: fnd_message.set_token('TABLE_NAME',l_table_name,FALSE);
863: fnd_file.put_line(fnd_file.log,fnd_message.get);
864:

Line 865: EXECUTE IMMEDIATE 'truncate table '||l_schema||'.bim_r_lead_weekly_facts';

861: fnd_message.set_name('BIM','BIM_R_POPULATE_TABLE');
862: fnd_message.set_token('TABLE_NAME',l_table_name,FALSE);
863: fnd_file.put_line(fnd_file.log,fnd_message.get);
864:
865: EXECUTE IMMEDIATE 'truncate table '||l_schema||'.bim_r_lead_weekly_facts';
866:
867: /*BEGIN BLOCK FOR THE WEEKLY INSERT */
868:
869: l_table_name := 'bim_r_lead_weekly_facts';

Line 869: l_table_name := 'bim_r_lead_weekly_facts';

865: EXECUTE IMMEDIATE 'truncate table '||l_schema||'.bim_r_lead_weekly_facts';
866:
867: /*BEGIN BLOCK FOR THE WEEKLY INSERT */
868:
869: l_table_name := 'bim_r_lead_weekly_facts';
870: l_seq_name := 'bim_r_lead_weekly_facts_s';
871:
872: INSERT /*+ append parallel(LWF,1) */
873: INTO bim_r_lead_weekly_facts LWF

Line 870: l_seq_name := 'bim_r_lead_weekly_facts_s';

866:
867: /*BEGIN BLOCK FOR THE WEEKLY INSERT */
868:
869: l_table_name := 'bim_r_lead_weekly_facts';
870: l_seq_name := 'bim_r_lead_weekly_facts_s';
871:
872: INSERT /*+ append parallel(LWF,1) */
873: INTO bim_r_lead_weekly_facts LWF
874: (

Line 873: INTO bim_r_lead_weekly_facts LWF

869: l_table_name := 'bim_r_lead_weekly_facts';
870: l_seq_name := 'bim_r_lead_weekly_facts_s';
871:
872: INSERT /*+ append parallel(LWF,1) */
873: INTO bim_r_lead_weekly_facts LWF
874: (
875: lead_weekly_transaction_id
876: ,creation_date
877: ,last_update_date

Line 908: bim_r_lead_weekly_facts_s.nextval

904: ,quotes_open
905: ,orders
906: )
907: SELECT /*+ parallel(INNER,1) */
908: bim_r_lead_weekly_facts_s.nextval
909: ,sysdate
910: ,sysdate
911: ,l_user_id
912: ,l_user_id

Line 992: l_table_name := 'BIM_R_LEAD_WEEKLY_FACTS';

988:
989:
990: COMMIT;
991:
992: l_table_name := 'BIM_R_LEAD_WEEKLY_FACTS';
993: fnd_message.set_name('BIM','BIM_R_ANALYZE_TABLE');
994: fnd_message.set_token('TABLE_NAME',l_table_name,FALSE);
995: fnd_file.put_line(fnd_file.log,fnd_message.get);
996:

Line 998: DBMS_STATS.gather_table_stats('BIM','BIM_R_LEAD_WEEKLY_FACTS', estimate_percent => 5,

994: fnd_message.set_token('TABLE_NAME',l_table_name,FALSE);
995: fnd_file.put_line(fnd_file.log,fnd_message.get);
996:
997: -- Analyze the daily facts table
998: DBMS_STATS.gather_table_stats('BIM','BIM_R_LEAD_WEEKLY_FACTS', estimate_percent => 5,
999: degree => 8, granularity => 'GLOBAL', cascade =>TRUE);
1000:
1001:
1002: /* Recreating Indexes */

Line 1004: BIM_UTL_PKG.CREATE_INDEX('BIM_R_LEAD_WEEKLY_FACTS');

1000:
1001:
1002: /* Recreating Indexes */
1003: BIM_UTL_PKG.CREATE_INDEX('BIM_R_LEAD_DAILY_FACTS');
1004: BIM_UTL_PKG.CREATE_INDEX('BIM_R_LEAD_WEEKLY_FACTS');
1005:
1006:
1007:
1008: EXECUTE IMMEDIATE 'ALTER sequence '||l_schema||'.bim_r_lead_weekly_facts_s CACHE 20';

Line 1008: EXECUTE IMMEDIATE 'ALTER sequence '||l_schema||'.bim_r_lead_weekly_facts_s CACHE 20';

1004: BIM_UTL_PKG.CREATE_INDEX('BIM_R_LEAD_WEEKLY_FACTS');
1005:
1006:
1007:
1008: EXECUTE IMMEDIATE 'ALTER sequence '||l_schema||'.bim_r_lead_weekly_facts_s CACHE 20';
1009:
1010:
1011:
1012: EXCEPTION