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.MSC_RESOURCE_PKG dependencies on MSC_RESOURCES_F

Line 43: delete from msc_resources_f

39: if l_refresh_mode = 2 -- targeted refesh
40: then
41: l_res_rn_qid := msc_phub_util.get_resource_rn_qid(p_plan_id, p_plan_run_id);
42:
43: delete from msc_resources_f
44: where plan_id = p_plan_id
45: and plan_run_id = p_plan_run_id
46: and (p_plan_id, sr_instance_id, organization_id, department_id, resource_id) in
47: (select number1, number2, number3, number4, number5 from msc_hub_query q where q.query_id = l_res_rn_qid);

Line 50: msc_phub_util.log('msc_resources_f, delete='||sql%rowcount||', l_rowcount1='||l_rowcount1);

46: and (p_plan_id, sr_instance_id, organization_id, department_id, resource_id) in
47: (select number1, number2, number3, number4, number5 from msc_hub_query q where q.query_id = l_res_rn_qid);
48:
49: l_rowcount1 := l_rowcount1 + sql%rowcount;
50: msc_phub_util.log('msc_resources_f, delete='||sql%rowcount||', l_rowcount1='||l_rowcount1);
51:
52: if (l_enable_num not in (2)) then
53: delete from msc_resources_cum_f
54: where plan_id = p_plan_id

Line 362: -- msc_resources_f:final

358:
359: msc_phub_util.log('insert into msc_st_resources_f:resource_cost: '||sql%rowcount);
360: commit;
361:
362: -- msc_resources_f:final
363: msc_phub_util.gather_table_stats(msc_phub_util.stats_st, 'MSC_ST_RESOURCES_F', l_transfer_id);
364: insert into msc_resources_f (
365: plan_id,
366: plan_run_id,

Line 364: insert into msc_resources_f (

360: commit;
361:
362: -- msc_resources_f:final
363: msc_phub_util.gather_table_stats(msc_phub_util.stats_st, 'MSC_ST_RESOURCES_F', l_transfer_id);
364: insert into msc_resources_f (
365: plan_id,
366: plan_run_id,
367: sr_instance_id,
368: organization_id,

Line 423: msc_phub_util.gather_table_stats(msc_phub_util.stats_fact, 'MSC_RESOURCES_F', p_plan_run_id);

419:
420: l_rowcount1 := l_rowcount1 + sql%rowcount;
421: msc_phub_util.log('insert into msc_st_resources_f:final: '||sql%rowcount);
422: commit;
423: msc_phub_util.gather_table_stats(msc_phub_util.stats_fact, 'MSC_RESOURCES_F', p_plan_run_id);
424:
425: if (l_enable_num not in (2)) then
426: -- msc_resources_cum_f
427: insert into msc_resources_cum_f (

Line 460: msc_resources_f f,

456: sysdate, fnd_global.user_id, fnd_global.login_id,
457: fnd_global.conc_program_id, fnd_global.conc_login_id,
458: fnd_global.prog_appl_id, fnd_global.conc_request_id
459: from
460: msc_resources_f f,
461: msc_phub_dates_mv d
462: where f.plan_id=p_plan_id
463: and f.plan_run_id=p_plan_run_id
464: and f.aggr_type=0

Line 519: delete from msc_resources_f

515: msc_phub_util.log('msc_resource_pkg.summarize_resources_f');
516: retcode := 0;
517: errbuf := '';
518:
519: delete from msc_resources_f
520: where plan_id=p_plan_id and plan_run_id=p_plan_run_id and aggr_type>0;
521: msc_phub_util.log('msc_resource_pkg.summarize_resources_f, delete='||sql%rowcount);
522: commit;
523:

Line 525: insert into msc_resources_f (

521: msc_phub_util.log('msc_resource_pkg.summarize_resources_f, delete='||sql%rowcount);
522: commit;
523:
524: -- level 1
525: insert into msc_resources_f (
526: plan_id, plan_run_id,
527: sr_instance_id, organization_id,
528: department_id, resource_id,
529: inventory_item_id, analysis_date,

Line 565: msc_resources_f f

561: sysdate, fnd_global.user_id, fnd_global.login_id,
562: fnd_global.conc_program_id, fnd_global.conc_login_id,
563: fnd_global.prog_appl_id, fnd_global.conc_request_id
564: from
565: msc_resources_f f
566: where f.plan_id = p_plan_id and f.plan_run_id = p_plan_run_id
567: and f.aggr_type=0
568: group by
569: f.plan_id, f.plan_run_id,

Line 596: msc_resources_f f,

592: sysdate, fnd_global.user_id, fnd_global.login_id,
593: fnd_global.conc_program_id, fnd_global.conc_login_id,
594: fnd_global.prog_appl_id, fnd_global.conc_request_id
595: from
596: msc_resources_f f,
597: msc_phub_resources_mv r
598: where f.plan_id = p_plan_id and f.plan_run_id = p_plan_run_id
599: and f.aggr_type=0
600: and r.sr_instance_id(+) = f.sr_instance_id

Line 614: insert into msc_resources_f (

610: msc_phub_util.log('msc_resource_pkg.summarize_resources_f, level1='||sql%rowcount);
611: commit;
612:
613: -- level 2
614: insert into msc_resources_f (
615: plan_id, plan_run_id,
616: sr_instance_id, organization_id,
617: department_id, resource_id,
618: inventory_item_id, analysis_date,

Line 653: msc_resources_f f,

649: sysdate, fnd_global.user_id, fnd_global.login_id,
650: fnd_global.conc_program_id, fnd_global.conc_login_id,
651: fnd_global.prog_appl_id, fnd_global.conc_request_id
652: from
653: msc_resources_f f,
654: msc_phub_dates_mv d
655: where f.plan_id = p_plan_id and f.plan_run_id = p_plan_run_id
656: and f.aggr_type = 82
657: and f.analysis_date = d.calendar_date

Line 687: msc_resources_f f,

683: sysdate, fnd_global.user_id, fnd_global.login_id,
684: fnd_global.conc_program_id, fnd_global.conc_login_id,
685: fnd_global.prog_appl_id, fnd_global.conc_request_id
686: from
687: msc_resources_f f,
688: msc_phub_dates_mv d
689: where f.plan_id = p_plan_id and f.plan_run_id = p_plan_run_id
690: and f.aggr_type = 82
691: and f.analysis_date = d.calendar_date

Line 868: ' '||l_apps_schema||'.msc_resources_f'||l_suffix||' f,'||

864: ' f.resource_cost2,'||
865: ' fnd_global.user_id, sysdate,'||
866: ' fnd_global.user_id, sysdate, fnd_global.login_id'||
867: ' from'||
868: ' '||l_apps_schema||'.msc_resources_f'||l_suffix||' f,'||
869: ' '||l_apps_schema||'.msc_trading_partners'||l_suffix||' mtp,'||
870: ' '||l_apps_schema||'.msc_items'||l_suffix||' mi,'||
871: ' '||l_apps_schema||'.msc_department_resources'||l_suffix||' mdr'||
872: ' where f.plan_run_id=:p_plan_run_id'||

Line 990: l_fact_table varchar2(30) := 'msc_resources_f';

986: p_plan_type number, p_plan_start_date date, p_plan_cutoff_date date,
987: p_upload_mode number, p_overwrite_after_date date, p_def_instance_code varchar2)
988: is
989: l_staging_table varchar2(30) := 'msc_st_resources_f';
990: l_fact_table varchar2(30) := 'msc_resources_f';
991: l_result number := 0;
992: begin
993: msc_phub_util.log('msc_resource_pkg.import_resources_f');
994: retcode := 0;

Line 1016: msc_phub_util.log('msc_resource_pkg.import_resources_f: insert into msc_resources_f');

1012:
1013: l_result := l_result + msc_phub_util.decode_resource_key(
1014: l_staging_table, p_st_transaction_id);
1015:
1016: msc_phub_util.log('msc_resource_pkg.import_resources_f: insert into msc_resources_f');
1017: insert into msc_resources_f (
1018: plan_id,
1019: plan_run_id,
1020: sr_instance_id,

Line 1017: insert into msc_resources_f (

1013: l_result := l_result + msc_phub_util.decode_resource_key(
1014: l_staging_table, p_st_transaction_id);
1015:
1016: msc_phub_util.log('msc_resource_pkg.import_resources_f: insert into msc_resources_f');
1017: insert into msc_resources_f (
1018: plan_id,
1019: plan_run_id,
1020: sr_instance_id,
1021: organization_id,