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_ITEM_PKG dependencies on MSC_ST_ITEM_ORDERS_F

Line 89: -- msc_st_item_orders_f:demands

85: l_sr_instance_id||','||l_plan_start_date||','||l_plan_cutoff_date||','||
86: l_transfer_id||','||l_refresh_mode||','||l_item_rn_qid||','||
87: l_enforce_wh_cpty);
88:
89: -- msc_st_item_orders_f:demands
90: insert /*+ append nologging */ into msc_st_item_orders_f (
91: st_transaction_id,
92: error_code,
93: sr_instance_id,

Line 90: insert /+ append nologging / into msc_st_item_orders_f (

86: l_transfer_id||','||l_refresh_mode||','||l_item_rn_qid||','||
87: l_enforce_wh_cpty);
88:
89: -- msc_st_item_orders_f:demands
90: insert /*+ append nologging */ into msc_st_item_orders_f (
91: st_transaction_id,
92: error_code,
93: sr_instance_id,
94: organization_id,

Line 202: msc_phub_util.log('insert into msc_st_item_orders_f:demands: '||sql%rowcount);

198: f.owning_org_id,
199: f.inventory_item_id,
200: d.date2;
201:
202: msc_phub_util.log('insert into msc_st_item_orders_f:demands: '||sql%rowcount);
203: commit;
204:
205: -- msc_st_item_orders_f:supplies
206: insert /*+ append nologging */ into msc_st_item_orders_f (

Line 205: -- msc_st_item_orders_f:supplies

201:
202: msc_phub_util.log('insert into msc_st_item_orders_f:demands: '||sql%rowcount);
203: commit;
204:
205: -- msc_st_item_orders_f:supplies
206: insert /*+ append nologging */ into msc_st_item_orders_f (
207: st_transaction_id,
208: error_code,
209: sr_instance_id,

Line 206: insert /+ append nologging / into msc_st_item_orders_f (

202: msc_phub_util.log('insert into msc_st_item_orders_f:demands: '||sql%rowcount);
203: commit;
204:
205: -- msc_st_item_orders_f:supplies
206: insert /*+ append nologging */ into msc_st_item_orders_f (
207: st_transaction_id,
208: error_code,
209: sr_instance_id,
210: organization_id,

Line 359: msc_phub_util.log('insert into msc_st_item_orders_f:supplies: '||sql%rowcount);

355: f.owning_org_id,
356: f.inventory_item_id,
357: d.date2;
358:
359: msc_phub_util.log('insert into msc_st_item_orders_f:supplies: '||sql%rowcount);
360: commit;
361:
362: if l_plan_type not in (5) and p_plan_id <> -1 then
363: -- msc_st_item_orders_f:supply end-pegged

Line 363: -- msc_st_item_orders_f:supply end-pegged

359: msc_phub_util.log('insert into msc_st_item_orders_f:supplies: '||sql%rowcount);
360: commit;
361:
362: if l_plan_type not in (5) and p_plan_id <> -1 then
363: -- msc_st_item_orders_f:supply end-pegged
364: insert /*+ append nologging */ into msc_st_item_orders_f (
365: st_transaction_id,
366: error_code,
367: sr_instance_id,

Line 364: insert /+ append nologging / into msc_st_item_orders_f (

360: commit;
361:
362: if l_plan_type not in (5) and p_plan_id <> -1 then
363: -- msc_st_item_orders_f:supply end-pegged
364: insert /*+ append nologging */ into msc_st_item_orders_f (
365: st_transaction_id,
366: error_code,
367: sr_instance_id,
368: organization_id,

Line 438: msc_phub_util.log('insert into msc_st_item_orders_f:supply end-pegged: '||sql%rowcount);

434: mfp.organization_id,
435: mfp.inventory_item_id,
436: trunc(nvl(ms.firm_date, ms.new_schedule_date));
437:
438: msc_phub_util.log('insert into msc_st_item_orders_f:supply end-pegged: '||sql%rowcount);
439: commit;
440: end if;
441:
442: -- msc_st_item_orders_f:demand pegged

Line 442: -- msc_st_item_orders_f:demand pegged

438: msc_phub_util.log('insert into msc_st_item_orders_f:supply end-pegged: '||sql%rowcount);
439: commit;
440: end if;
441:
442: -- msc_st_item_orders_f:demand pegged
443: -- bnaghi : these facts are not available for DRP plan
444: insert /*+ append nologging */ into msc_st_item_orders_f (
445: st_transaction_id,
446: error_code,

Line 444: insert /+ append nologging / into msc_st_item_orders_f (

440: end if;
441:
442: -- msc_st_item_orders_f:demand pegged
443: -- bnaghi : these facts are not available for DRP plan
444: insert /*+ append nologging */ into msc_st_item_orders_f (
445: st_transaction_id,
446: error_code,
447: sr_instance_id,
448: organization_id,

Line 511: msc_phub_util.log('insert into msc_st_item_orders_f:demand pegged: '||sql%rowcount);

507: mfp.organization_id,
508: mfp.inventory_item_id,
509: trunc(mfp.demand_date);
510:
511: msc_phub_util.log('insert into msc_st_item_orders_f:demand pegged: '||sql%rowcount);
512: commit;
513:
514: -- msc_st_item_orders_f:exception
515: -- bnaghi - not available for DRP plans

Line 514: -- msc_st_item_orders_f:exception

510:
511: msc_phub_util.log('insert into msc_st_item_orders_f:demand pegged: '||sql%rowcount);
512: commit;
513:
514: -- msc_st_item_orders_f:exception
515: -- bnaghi - not available for DRP plans
516: insert /*+ append nologging */ into msc_st_item_orders_f (
517: st_transaction_id,
518: error_code,

Line 516: insert /+ append nologging / into msc_st_item_orders_f (

512: commit;
513:
514: -- msc_st_item_orders_f:exception
515: -- bnaghi - not available for DRP plans
516: insert /*+ append nologging */ into msc_st_item_orders_f (
517: st_transaction_id,
518: error_code,
519: sr_instance_id,
520: organization_id,

Line 568: msc_phub_util.log('insert into msc_st_item_orders_f:exception: '||sql%rowcount);

564: me.owning_org_id,
565: me.inventory_item_id,
566: me.analysis_date;
567:
568: msc_phub_util.log('insert into msc_st_item_orders_f:exception: '||sql%rowcount);
569: commit;
570:
571: -- msc_item_orders_f:final
572: msc_phub_util.gather_table_stats(msc_phub_util.stats_st, 'MSC_ST_ITEM_ORDERS_F', l_transfer_id);

Line 572: msc_phub_util.gather_table_stats(msc_phub_util.stats_st, 'MSC_ST_ITEM_ORDERS_F', l_transfer_id);

568: msc_phub_util.log('insert into msc_st_item_orders_f:exception: '||sql%rowcount);
569: commit;
570:
571: -- msc_item_orders_f:final
572: msc_phub_util.gather_table_stats(msc_phub_util.stats_st, 'MSC_ST_ITEM_ORDERS_F', l_transfer_id);
573: insert into msc_item_orders_f (
574: plan_id,
575: plan_run_id,
576: sr_instance_id,

Line 775: msc_st_item_orders_f f,

771: sum(f.supply_qty_defective) supply_qty_defective,
772: sum(f.onhand_value) onhand_value,
773: sum(f.scheduled_rept_value) scheduled_rept_value
774: from
775: msc_st_item_orders_f f,
776: msc_trading_partners mtp
777: where f.st_transaction_id=l_transfer_id
778: and mtp.partner_type(+)=3
779: and f.owning_inst_id=mtp.sr_instance_id(+)

Line 2020: delete from msc_st_item_orders_f where st_transaction_id=p_st_transaction_id;

2016: msc_phub_util.log('msc_item_pkg.export_item_orders_f');
2017: retcode := 0;
2018: errbuf := null;
2019:
2020: delete from msc_st_item_orders_f where st_transaction_id=p_st_transaction_id;
2021: commit;
2022:
2023: l_sql :=
2024: ' insert into msc_st_item_orders_f('||

Line 2024: ' insert into msc_st_item_orders_f('||

2020: delete from msc_st_item_orders_f where st_transaction_id=p_st_transaction_id;
2021: commit;
2022:
2023: l_sql :=
2024: ' insert into msc_st_item_orders_f('||
2025: ' st_transaction_id,'||
2026: ' error_code,'||
2027: ' sr_instance_id,'||
2028: ' organization_id,'||

Line 2363: l_staging_table varchar2(30) := 'msc_st_item_orders_f';

2359: p_st_transaction_id number, p_plan_id number, p_plan_run_id number,
2360: p_plan_type number, p_plan_start_date date, p_plan_cutoff_date date,
2361: p_upload_mode number, p_overwrite_after_date date, p_def_instance_code varchar2)
2362: is
2363: l_staging_table varchar2(30) := 'msc_st_item_orders_f';
2364: l_fact_table varchar2(30) := 'msc_item_orders_f';
2365: l_result number := 0;
2366: begin
2367: msc_phub_util.log('msc_item_pkg.import_item_orders_f');

Line 2391: msc_phub_util.log('msc_item_pkg.import_item_orders_f: insert into msc_st_item_orders_f');

2387:
2388: l_result := l_result + msc_phub_util.decode_item_key(
2389: l_staging_table, p_st_transaction_id, 'inventory_item_id', 'item_name');
2390:
2391: msc_phub_util.log('msc_item_pkg.import_item_orders_f: insert into msc_st_item_orders_f');
2392: insert into msc_item_orders_f (
2393: plan_id,
2394: plan_run_id,
2395: sr_instance_id,

Line 2525: from msc_st_item_orders_f

2521: scheduled_rept_value2,
2522: 0, -23453, -23453,
2523: fnd_global.user_id, sysdate,
2524: fnd_global.user_id, sysdate, fnd_global.login_id
2525: from msc_st_item_orders_f
2526: where st_transaction_id=p_st_transaction_id and error_code=0;
2527:
2528: msc_phub_util.log('msc_item_pkg.import_item_orders_f: inserted='||sql%rowcount);
2529: commit;