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_RESPONSE_FACTS_PKG dependencies on BIM_R_RRSN_DAILY_FACTS

Line 408: EXECUTE IMMEDIATE 'ALTER TABLE '||l_schema||'.bim_r_rrsn_daily_facts nologging ';

404:
405:
406:
407: EXECUTE IMMEDIATE 'ALTER TABLE '||l_schema||'.bim_r_rgrd_daily_facts nologging ';
408: EXECUTE IMMEDIATE 'ALTER TABLE '||l_schema||'.bim_r_rrsn_daily_facts nologging ';
409:
410: EXECUTE IMMEDIATE 'ALTER TABLE '||l_schema||'.bim_r_rgrd_weekly_facts nologging ';
411: EXECUTE IMMEDIATE 'ALTER TABLE '||l_schema||'.bim_r_rrsn_weekly_facts nologging ';
412:

Line 414: EXECUTE IMMEDIATE 'ALTER sequence '||l_schema||'.bim_r_rrsn_daily_facts_s CACHE 1000 ';

410: EXECUTE IMMEDIATE 'ALTER TABLE '||l_schema||'.bim_r_rgrd_weekly_facts nologging ';
411: EXECUTE IMMEDIATE 'ALTER TABLE '||l_schema||'.bim_r_rrsn_weekly_facts nologging ';
412:
413: EXECUTE IMMEDIATE 'ALTER sequence '||l_schema||'.bim_r_rgrd_daily_facts_s CACHE 1000 ';
414: EXECUTE IMMEDIATE 'ALTER sequence '||l_schema||'.bim_r_rrsn_daily_facts_s CACHE 1000 ';
415:
416: EXECUTE IMMEDIATE 'ALTER sequence '||l_schema||'.bim_r_rgrd_weekly_facts_s CACHE 1000 ';
417: EXECUTE IMMEDIATE 'ALTER sequence '||l_schema||'.bim_r_rrsn_weekly_facts_s CACHE 1000 ';
418:

Line 422: BIM_UTL_PKG.DROP_INDEX('BIM_R_RRSN_DAILY_FACTS');

418:
419:
420: /* Dropping INdexes */
421: BIM_UTL_PKG.DROP_INDEX('BIM_R_RGRD_DAILY_FACTS');
422: BIM_UTL_PKG.DROP_INDEX('BIM_R_RRSN_DAILY_FACTS');
423: BIM_UTL_PKG.DROP_INDEX('BIM_R_RGRD_WEEKLY_FACTS');
424: BIM_UTL_PKG.DROP_INDEX('BIM_R_RRSN_WEEKLY_FACTS');
425:
426:

Line 506: l_table_name := 'BIM_R_RRSN_DAILY_FACTS';

502: fnd_message.set_token('TABLE_NAME',l_table_name,FALSE);
503: fnd_file.put_line(fnd_file.log,fnd_message.get);
504: -----------
505:
506: l_table_name := 'BIM_R_RRSN_DAILY_FACTS';
507: fnd_message.set_name('BIM','BIM_R_BEFORE_POPULATE');
508: fnd_message.set_token('TABLE_NAME',l_table_name,FALSE);
509: fnd_file.put_line(fnd_file.log,fnd_message.get);
510:

Line 512: INTO bim_r_rrsn_daily_facts RDF

508: fnd_message.set_token('TABLE_NAME',l_table_name,FALSE);
509: fnd_file.put_line(fnd_file.log,fnd_message.get);
510:
511: INSERT /*+ append parallel(RDF,1) */
512: INTO bim_r_rrsn_daily_facts RDF
513: (
514: Reason_daily_transaction_id
515: ,creation_date
516: ,last_update_date

Line 536: bim_r_rrsn_daily_facts_s.nextval

532: ,transaction_Create_Date
533: ,weekend_date
534: )
535: SELECT
536: bim_r_rrsn_daily_facts_s.nextval
537: ,sysdate
538: ,sysdate
539: ,-1
540: ,-1

Line 578: l_table_name := 'BIM_R_RRSN_DAILY_FACTS';

574: 'CSCH',d.object_id,'EVEO',d.object_id)
575: AND a.interface_header_id = b.interface_header_id;
576:
577: ------------
578: l_table_name := 'BIM_R_RRSN_DAILY_FACTS';
579: fnd_message.set_name('BIM','BIM_R_AFTER_POPULATE');
580: fnd_message.set_token('TABLE_NAME',l_table_name,FALSE);
581: fnd_file.put_line(fnd_file.log,fnd_message.get);
582:

Line 598: l_table_name := 'BIM_R_RRSN_DAILY_FACTS';

594: -- Analyze the daily facts table
595: DBMS_STATS.gather_table_stats('BIM','BIM_R_RGRD_DAILY_FACTS', estimate_percent => 5,
596: degree => 8, granularity => 'GLOBAL', cascade =>TRUE);
597:
598: l_table_name := 'BIM_R_RRSN_DAILY_FACTS';
599: fnd_message.set_name('BIM','BIM_R_ANALYZE_TABLE');
600: fnd_message.set_token('TABLE_NAME',l_table_name,FALSE);
601: fnd_file.put_line(fnd_file.log,fnd_message.get);
602:

Line 604: DBMS_STATS.gather_table_stats('BIM','BIM_R_RRSN_DAILY_FACTS', estimate_percent => 5,

600: fnd_message.set_token('TABLE_NAME',l_table_name,FALSE);
601: fnd_file.put_line(fnd_file.log,fnd_message.get);
602:
603: -- Analyze the daily facts table
604: DBMS_STATS.gather_table_stats('BIM','BIM_R_RRSN_DAILY_FACTS', estimate_percent => 5,
605: degree => 8, granularity => 'GLOBAL', cascade =>TRUE);
606:
607: /***************************************************************/
608:

Line 765: FROM bim_r_rrsn_daily_facts

761: ,weekend_date
762: ,sum(Invalid_Responses) Invalid_Responses
763: ,sum(landing_pad_hits) Landing_Pad_hits
764: ,sum(survey_completed) Survey_Completed
765: FROM bim_r_rrsn_daily_facts
766: GROUP BY
767: Object_Id
768: ,Object_type
769: ,Object_status

Line 813: BIM_UTL_PKG.CREATE_INDEX('BIM_R_RRSN_DAILY_FACTS');

809: fnd_file.put_line(fnd_file.log,fnd_message.get);
810:
811: /* Recreating Indexes */
812: BIM_UTL_PKG.CREATE_INDEX('BIM_R_RGRD_DAILY_FACTS');
813: BIM_UTL_PKG.CREATE_INDEX('BIM_R_RRSN_DAILY_FACTS');
814: BIM_UTL_PKG.CREATE_INDEX('BIM_R_RGRD_WEEKLY_FACTS');
815: BIM_UTL_PKG.CREATE_INDEX('BIM_R_RRSN_WEEKLY_FACTS');
816:
817: EXECUTE IMMEDIATE 'ALTER sequence '||l_schema||'.bim_r_rgrd_weekly_facts_s CACHE 20';