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_DAILY_FACTS

Line 439: EXECUTE IMMEDIATE 'ALTER TABLE '||l_schema||'.bim_r_lead_daily_facts nologging ';

435: --COMMIT;
436:
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 ';

Line 443: EXECUTE IMMEDIATE 'ALTER sequence '||l_schema||'.bim_r_lead_daily_facts_s CACHE 1000 ';

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 ';
446:
447: /* Dropping INdexes */

Line 448: BIM_UTL_PKG.DROP_INDEX('BIM_R_LEAD_DAILY_FACTS');

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');
450:
451:
452:

Line 453: l_table_name := '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';
454: fnd_message.set_name('BIM','BIM_R_POPULATE_TABLE');
455: fnd_message.set_token('TABLE_NAME',l_table_name,FALSE);
456: fnd_file.put_line(fnd_file.log,fnd_message.get);
457:

Line 464: INTO bim_r_lead_daily_facts LDF

460:
461:
462:
463: INSERT /*+ append parallel(LDF,1) */
464: INTO bim_r_lead_daily_facts LDF
465: (
466: lead_daily_transaction_id
467: ,creation_date
468: ,last_update_date

Line 501: bim_r_lead_daily_facts_s.nextval

497: ,orders
498: ,weekend_date
499: )
500: SELECT /*+ parallel(OUTER,1) */
501: bim_r_lead_daily_facts_s.nextval
502: ,sysdate
503: ,sysdate
504: ,-1
505: ,-1

Line 841: l_table_name := 'BIM_R_LEAD_DAILY_FACTS';

837:
838: /***************************************************************/
839:
840:
841: l_table_name := 'BIM_R_LEAD_DAILY_FACTS';
842: fnd_message.set_name('BIM','BIM_R_ANALYZE_TABLE');
843: fnd_message.set_token('TABLE_NAME',l_table_name,FALSE);
844: fnd_file.put_line(fnd_file.log,fnd_message.get);
845:

Line 847: DBMS_STATS.gather_table_stats('BIM','BIM_R_LEAD_DAILY_FACTS', estimate_percent => 5,

843: fnd_message.set_token('TABLE_NAME',l_table_name,FALSE);
844: fnd_file.put_line(fnd_file.log,fnd_message.get);
845:
846: -- Analyze the daily facts table
847: DBMS_STATS.gather_table_stats('BIM','BIM_R_LEAD_DAILY_FACTS', estimate_percent => 5,
848: degree => 8, granularity => 'GLOBAL', cascade =>TRUE);
849:
850:
851: EXECUTE IMMEDIATE 'ALTER sequence '||l_schema||'.bim_r_lead_daily_facts_s CACHE 20';

Line 851: EXECUTE IMMEDIATE 'ALTER sequence '||l_schema||'.bim_r_lead_daily_facts_s CACHE 20';

847: DBMS_STATS.gather_table_stats('BIM','BIM_R_LEAD_DAILY_FACTS', estimate_percent => 5,
848: degree => 8, granularity => 'GLOBAL', cascade =>TRUE);
849:
850:
851: EXECUTE IMMEDIATE 'ALTER sequence '||l_schema||'.bim_r_lead_daily_facts_s CACHE 20';
852:
853: /***************************************************************/
854:
855: /* INSERT INTO WEEKLY SUMMARY TABLE */

Line 968: FROM bim_r_lead_daily_facts

964: ,sum(opportunities_open) opportunities_open
965: ,sum(quotes) quotes
966: ,sum(quotes_open) quotes_open
967: ,sum(orders) orders
968: FROM bim_r_lead_daily_facts
969: -- WHERE transaction_create_date between trunc(p_start_date) and trunc(p_end_date) + 0.99999
970: GROUP BY
971: weekend_date
972: ,year

Line 1003: BIM_UTL_PKG.CREATE_INDEX('BIM_R_LEAD_DAILY_FACTS');

999: degree => 8, granularity => 'GLOBAL', cascade =>TRUE);
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: