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_EXCEPTION_PKG dependencies on MSC_EXCEPTIONS_F

Line 24: insert into msc_exceptions_f

20: from msc_plan_runs
21: where plan_id=p_plan_id
22: and plan_run_id=p_plan_run_id;
23:
24: insert into msc_exceptions_f
25: (plan_id,
26: plan_run_id,
27: organization_id,
28: sr_instance_id,

Line 593: msc_phub_util.log('msc_exceptions_f, insert='||sql%rowcount);

589: where mcc.from_currency(+) = exception_tbl.currency_code
590: and mcc.to_currency(+) = fnd_profile.value('MSC_HUB_CUR_CODE_RPT')
591: and mcc.calendar_date(+) = exception_tbl.analysis_date;
592:
593: msc_phub_util.log('msc_exceptions_f, insert='||sql%rowcount);
594: commit;
595:
596: msc_phub_util.gather_table_stats(msc_phub_util.stats_fact, 'MSC_EXCEPTIONS_F', p_plan_run_id);
597:

Line 596: msc_phub_util.gather_table_stats(msc_phub_util.stats_fact, 'MSC_EXCEPTIONS_F', p_plan_run_id);

592:
593: msc_phub_util.log('msc_exceptions_f, insert='||sql%rowcount);
594: commit;
595:
596: msc_phub_util.gather_table_stats(msc_phub_util.stats_fact, 'MSC_EXCEPTIONS_F', p_plan_run_id);
597:
598: summarize_exceptions_f(errbuf, retcode, p_plan_id, p_plan_run_id);
599: msc_phub_util.log('msc_exception_pkg.populate_details.complete, duration='||(systimestamp-l_start_time));
600:

Line 617: delete from msc_exceptions_f

613: msc_phub_util.log('msc_exception_pkg.summarize_exceptions_f');
614: retcode := 0;
615: errbuf := '';
616:
617: delete from msc_exceptions_f
618: where plan_id=p_plan_id and plan_run_id=p_plan_run_id and aggr_type>0;
619: msc_phub_util.log('msc_exception_pkg.summarize_exceptions_f, delete='||sql%rowcount);
620: commit;
621:

Line 623: insert into msc_exceptions_f (

619: msc_phub_util.log('msc_exception_pkg.summarize_exceptions_f, delete='||sql%rowcount);
620: commit;
621:
622: -- level 1
623: insert into msc_exceptions_f (
624: plan_id, plan_run_id,
625: organization_id, sr_instance_id, inventory_item_id,
626: department_id, resource_id,
627: supplier_id, supplier_site_id,

Line 674: msc_exceptions_f f,

670: sysdate, fnd_global.user_id, fnd_global.login_id,
671: fnd_global.conc_program_id, fnd_global.conc_login_id,
672: fnd_global.prog_appl_id, fnd_global.conc_request_id
673: from
674: msc_exceptions_f f,
675: msc_phub_item_categories_mv q
676: where f.plan_id = p_plan_id and f.plan_run_id = p_plan_run_id
677: and f.aggr_type=0
678: and f.owning_inst_id=q.sr_instance_id(+)

Line 699: insert into msc_exceptions_f (

695: msc_phub_util.log('msc_exception_pkg.summarize_exceptions_f, level1='||sql%rowcount);
696: commit;
697:
698: -- level 2
699: insert into msc_exceptions_f (
700: plan_id, plan_run_id,
701: organization_id, sr_instance_id, inventory_item_id,
702: department_id, resource_id,
703: supplier_id, supplier_site_id,

Line 749: msc_exceptions_f f,

745: sysdate, fnd_global.user_id, fnd_global.login_id,
746: fnd_global.conc_program_id, fnd_global.conc_login_id,
747: fnd_global.prog_appl_id, fnd_global.conc_request_id
748: from
749: msc_exceptions_f f,
750: msc_phub_dates_mv d
751: where f.plan_id = p_plan_id and f.plan_run_id = p_plan_run_id
752: and f.aggr_type between 42 and 44
753: and f.analysis_date = d.calendar_date

Line 895: ' '||l_apps_schema||'.msc_exceptions_f'||l_suffix||' f,'||

891: ' f.exception_ratio,'||
892: ' fnd_global.user_id, sysdate,'||
893: ' fnd_global.user_id, sysdate, fnd_global.login_id'||
894: ' from'||
895: ' '||l_apps_schema||'.msc_exceptions_f'||l_suffix||' f,'||
896: ' '||l_apps_schema||'.msc_trading_partners'||l_suffix||' mtp,'||
897: ' '||l_apps_schema||'.msc_trading_partners'||l_suffix||' mtp2,'||
898: ' '||l_apps_schema||'.msc_items'||l_suffix||' mi,'||
899: ' '||l_apps_schema||'.msc_phub_customers_mv'||l_suffix||' cmv,'||

Line 961: l_fact_table varchar2(30) := 'msc_exceptions_f';

957: p_plan_type number, p_plan_start_date date, p_plan_cutoff_date date,
958: p_upload_mode number, p_overwrite_after_date date, p_def_instance_code varchar2)
959: is
960: l_staging_table varchar2(30) := 'msc_st_exceptions_f';
961: l_fact_table varchar2(30) := 'msc_exceptions_f';
962: l_result number := 0;
963: begin
964: msc_phub_util.log('msc_exception_pkg.import_exceptions_f');
965: retcode := 0;

Line 1004: msc_phub_util.log('msc_exception_pkg.import_exceptions_f: insert into msc_exceptions_f');

1000:
1001: l_result := l_result + msc_phub_util.decode_project_key(
1002: l_staging_table, p_st_transaction_id);
1003:
1004: msc_phub_util.log('msc_exception_pkg.import_exceptions_f: insert into msc_exceptions_f');
1005: insert into msc_exceptions_f (
1006: plan_id,
1007: plan_run_id,
1008: sr_instance_id,

Line 1005: insert into msc_exceptions_f (

1001: l_result := l_result + msc_phub_util.decode_project_key(
1002: l_staging_table, p_st_transaction_id);
1003:
1004: msc_phub_util.log('msc_exception_pkg.import_exceptions_f: insert into msc_exceptions_f');
1005: insert into msc_exceptions_f (
1006: plan_id,
1007: plan_run_id,
1008: sr_instance_id,
1009: organization_id,