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_PHUB_EXCESS_PKG dependencies on MSC_ITEMS_F

Line 156: -- msc_items_f:eo

152: end if;
153:
154:
155: if l_item_simulation_set_id is not null then
156: -- msc_items_f:eo
157: insert /*+ append nologging */ into msc_st_items_f (
158: st_transaction_id,
159: error_code,
160: sr_instance_id,

Line 350: -- msc_items_f:wh_available_capacity

346: end if;
347:
348: if (l_enforce_wh_cpty = 1 and l_plan_type = 4) then
349: if (nvl(fnd_profile.value('MSR_ORGANIZATION_WAREHOUSE_CAPACITY'),1) = 1) then
350: -- msc_items_f:wh_available_capacity
351: insert /*+ append nologging */ into msc_st_items_f (
352: st_transaction_id,
353: error_code,
354: sr_instance_id,

Line 392: -- msc_items_f:wh_available_capacity_cat

388: and uc.inventory_item_id=0;
389: msc_phub_util.log('insert into msc_st_items_f:wh_available_capacity: '||sql%rowcount);
390: commit;
391: else
392: -- msc_items_f:wh_available_capacity_cat
393: insert /*+ append nologging */ into msc_st_items_f (
394: st_transaction_id,
395: error_code,
396: sr_instance_id,

Line 434: -- msc_items_f:final

430: commit;
431: end if;
432: end if;
433:
434: -- msc_items_f:final
435: insert into msc_items_f (
436: plan_id,
437: plan_run_id,
438: sr_instance_id,

Line 435: insert into msc_items_f (

431: end if;
432: end if;
433:
434: -- msc_items_f:final
435: insert into msc_items_f (
436: plan_id,
437: plan_run_id,
438: sr_instance_id,
439: organization_id,

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

511: organization_id,
512: owning_inst_id,
513: owning_org_id,
514: inventory_item_id;
515: msc_phub_util.log('insert into msc_items_f:final: '||sql%rowcount);
516: commit;
517:
518: msc_phub_util.gather_table_stats(msc_phub_util.stats_fact, 'MSC_ITEMS_F', p_plan_run_id);
519: summarize_items_f(errbuf, retcode, p_plan_id, p_plan_run_id);

Line 518: msc_phub_util.gather_table_stats(msc_phub_util.stats_fact, 'MSC_ITEMS_F', p_plan_run_id);

514: inventory_item_id;
515: msc_phub_util.log('insert into msc_items_f:final: '||sql%rowcount);
516: commit;
517:
518: msc_phub_util.gather_table_stats(msc_phub_util.stats_fact, 'MSC_ITEMS_F', p_plan_run_id);
519: summarize_items_f(errbuf, retcode, p_plan_id, p_plan_run_id);
520: msc_phub_util.log('msc_phub_excess_pkg.populate_details.complete, duration='||(systimestamp-l_start_time));
521:
522: exception

Line 538: delete from msc_items_f

534: msc_phub_util.log('msc_phub_excess_pkg.summarize_items_f');
535: retcode := 0;
536: errbuf := '';
537:
538: delete from msc_items_f
539: where plan_id=p_plan_id and plan_run_id=p_plan_run_id and aggr_type>0;
540: msc_phub_util.log('msc_phub_excess_pkg.summarize_items_f, delete='||sql%rowcount);
541: commit;
542:

Line 544: insert into msc_items_f (

540: msc_phub_util.log('msc_phub_excess_pkg.summarize_items_f, delete='||sql%rowcount);
541: commit;
542:
543: -- level 1
544: insert into msc_items_f (
545: plan_id, plan_run_id,
546: sr_instance_id, organization_id,
547: owning_inst_id, owning_org_id, inventory_item_id,
548: aggr_type, category_set_id, sr_category_id,

Line 609: msc_items_f f,

605: sysdate, fnd_global.user_id, fnd_global.login_id,
606: fnd_global.conc_program_id, fnd_global.conc_login_id,
607: fnd_global.prog_appl_id, fnd_global.conc_request_id
608: from
609: msc_items_f f,
610: msc_phub_item_categories_mv q
611: where f.plan_id=p_plan_id and f.plan_run_id=p_plan_run_id
612: and f.aggr_type=0
613: and f.sr_instance_id=q.sr_instance_id(+)

Line 766: ' '||l_apps_schema||'.msc_items_f'||l_suffix||' f,'||

762: ' f.wh_available_capacity,'||
763: ' fnd_global.user_id, sysdate,'||
764: ' fnd_global.user_id, sysdate, fnd_global.login_id'||
765: ' from'||
766: ' '||l_apps_schema||'.msc_items_f'||l_suffix||' f,'||
767: ' '||l_apps_schema||'.msc_trading_partners'||l_suffix||' mtp,'||
768: ' '||l_apps_schema||'.msc_trading_partners'||l_suffix||' mtp2,'||
769: ' '||l_apps_schema||'.msc_items'||l_suffix||' mi,'||
770: ' '||l_apps_schema||'.msc_apps_instances'||l_suffix||' mai'||

Line 802: l_fact_table varchar2(30) := 'msc_items_f';

798: p_plan_type number, p_plan_start_date date, p_plan_cutoff_date date,
799: p_upload_mode number, p_overwrite_after_date date, p_def_instance_code varchar2)
800: is
801: l_staging_table varchar2(30) := 'msc_st_items_f';
802: l_fact_table varchar2(30) := 'msc_items_f';
803: l_result number := 0;
804: begin
805: msc_phub_util.log('msc_phub_excess_pkg.import_items_f');
806: retcode := 0;

Line 827: msc_phub_util.log('msc_phub_excess_pkg.import_items_f: insert into msc_items_f');

823:
824: l_result := l_result + msc_phub_util.decode_item_key2(
825: l_staging_table, p_st_transaction_id, 'inventory_item_id', 'owning_inst_id', 'category_instance_code', 'category_name', 'item_name');
826:
827: msc_phub_util.log('msc_phub_excess_pkg.import_items_f: insert into msc_items_f');
828: insert into msc_items_f (
829: plan_id,
830: plan_run_id,
831: sr_instance_id,

Line 828: insert into msc_items_f (

824: l_result := l_result + msc_phub_util.decode_item_key2(
825: l_staging_table, p_st_transaction_id, 'inventory_item_id', 'owning_inst_id', 'category_instance_code', 'category_name', 'item_name');
826:
827: msc_phub_util.log('msc_phub_excess_pkg.import_items_f: insert into msc_items_f');
828: insert into msc_items_f (
829: plan_id,
830: plan_run_id,
831: sr_instance_id,
832: organization_id,