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_SUPPLIER_PKG dependencies on MSC_SUPPLIERS_F

Line 479: msc_phub_util.unusuable_local_index('MSC_SUPPLIERS_F', p_plan_run_id, 1);

475: commit;
476: end if;
477:
478: -- msc_st_suppliers_f:final
479: msc_phub_util.unusuable_local_index('MSC_SUPPLIERS_F', p_plan_run_id, 1);
480: insert into msc_suppliers_f (
481: plan_id,
482: plan_run_id,
483: sr_instance_id,

Line 480: insert into msc_suppliers_f (

476: end if;
477:
478: -- msc_st_suppliers_f:final
479: msc_phub_util.unusuable_local_index('MSC_SUPPLIERS_F', p_plan_run_id, 1);
480: insert into msc_suppliers_f (
481: plan_id,
482: plan_run_id,
483: sr_instance_id,
484: organization_id,

Line 538: msc_phub_util.log('insert into msc_suppliers_f:final: '||sql%rowcount);

534: f.supplier_id,
535: f.supplier_site_id,
536: f.analysis_date;
537:
538: msc_phub_util.log('insert into msc_suppliers_f:final: '||sql%rowcount);
539: commit;
540:
541: msc_phub_util.unusuable_local_index('MSC_SUPPLIERS_F', p_plan_run_id, 2);
542: msc_phub_util.gather_table_stats(msc_phub_util.stats_fact, 'MSC_SUPPLIERS_F', p_plan_run_id);

Line 541: msc_phub_util.unusuable_local_index('MSC_SUPPLIERS_F', p_plan_run_id, 2);

537:
538: msc_phub_util.log('insert into msc_suppliers_f:final: '||sql%rowcount);
539: commit;
540:
541: msc_phub_util.unusuable_local_index('MSC_SUPPLIERS_F', p_plan_run_id, 2);
542: msc_phub_util.gather_table_stats(msc_phub_util.stats_fact, 'MSC_SUPPLIERS_F', p_plan_run_id);
543:
544:
545: summarize_suppliers_f(errbuf, retcode, p_plan_id, p_plan_run_id);

Line 542: msc_phub_util.gather_table_stats(msc_phub_util.stats_fact, 'MSC_SUPPLIERS_F', p_plan_run_id);

538: msc_phub_util.log('insert into msc_suppliers_f:final: '||sql%rowcount);
539: commit;
540:
541: msc_phub_util.unusuable_local_index('MSC_SUPPLIERS_F', p_plan_run_id, 2);
542: msc_phub_util.gather_table_stats(msc_phub_util.stats_fact, 'MSC_SUPPLIERS_F', p_plan_run_id);
543:
544:
545: summarize_suppliers_f(errbuf, retcode, p_plan_id, p_plan_run_id);
546: msc_phub_util.log('msc_supplier_pkg.populate_details.complete, duration='||(systimestamp-l_start_time));

Line 564: delete from msc_suppliers_f

560: msc_phub_util.log('msc_supplier_pkg.summarize_suppliers_f');
561: retcode := 0;
562: errbuf := '';
563:
564: delete from msc_suppliers_f
565: where plan_id=p_plan_id and plan_run_id=p_plan_run_id and aggr_type>0;
566: msc_phub_util.log('msc_supplier_pkg.summarize_suppliers_f, delete='||sql%rowcount);
567: commit;
568:

Line 570: insert into msc_suppliers_f (

566: msc_phub_util.log('msc_supplier_pkg.summarize_suppliers_f, delete='||sql%rowcount);
567: commit;
568:
569: -- level 1
570: insert into msc_suppliers_f (
571: plan_id, plan_run_id,
572: sr_instance_id, organization_id,
573: owning_inst_id, owning_org_id, inventory_item_id,
574: supplier_id, supplier_site_id,

Line 604: msc_suppliers_f f,

600: sysdate, fnd_global.user_id, fnd_global.login_id,
601: fnd_global.conc_program_id, fnd_global.conc_login_id,
602: fnd_global.prog_appl_id, fnd_global.conc_request_id
603: from
604: msc_suppliers_f f,
605: msc_phub_item_categories_mv q
606: where f.plan_id=p_plan_id and f.plan_run_id=p_plan_run_id
607: and f.aggr_type=0
608: and f.owning_inst_id=q.sr_instance_id(+)

Line 694: ' '||l_apps_schema||'.msc_suppliers_f'||l_suffix||' f,'||

690: ' f.net_avail_qty_cum,'||
691: ' fnd_global.user_id, sysdate,'||
692: ' fnd_global.user_id, sysdate, fnd_global.login_id'||
693: ' from'||
694: ' '||l_apps_schema||'.msc_suppliers_f'||l_suffix||' f,'||
695: ' '||l_apps_schema||'.msc_trading_partners'||l_suffix||' mtp,'||
696: ' '||l_apps_schema||'.msc_trading_partners'||l_suffix||' mtp2,'||
697: ' '||l_apps_schema||'.msc_items'||l_suffix||' mi,'||
698: ' '||l_apps_schema||'.msc_phub_suppliers_mv'||l_suffix||' smv'||

Line 729: l_fact_table varchar2(30) := 'msc_suppliers_f';

725: p_plan_type number, p_plan_start_date date, p_plan_cutoff_date date,
726: p_upload_mode number, p_overwrite_after_date date, p_def_instance_code varchar2)
727: is
728: l_staging_table varchar2(30) := 'msc_st_suppliers_f';
729: l_fact_table varchar2(30) := 'msc_suppliers_f';
730: l_result number := 0;
731: begin
732: msc_phub_util.log('msc_supplier_pkg.import_suppliers_f');
733: retcode := 0;

Line 761: msc_phub_util.log('msc_supplier_pkg.import_suppliers_f: insert into msc_suppliers_f');

757: l_staging_table, p_st_transaction_id,
758: 'supplier_id', 'supplier_site_id',
759: 'supplier_name', 'supplier_site_code');
760:
761: msc_phub_util.log('msc_supplier_pkg.import_suppliers_f: insert into msc_suppliers_f');
762: insert into msc_suppliers_f (
763: plan_id,
764: plan_run_id,
765: sr_instance_id,

Line 762: insert into msc_suppliers_f (

758: 'supplier_id', 'supplier_site_id',
759: 'supplier_name', 'supplier_site_code');
760:
761: msc_phub_util.log('msc_supplier_pkg.import_suppliers_f: insert into msc_suppliers_f');
762: insert into msc_suppliers_f (
763: plan_id,
764: plan_run_id,
765: sr_instance_id,
766: organization_id,