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_ITEM_ORDERS_F

Line 57: delete from msc_item_orders_f

53: l_rowcount1 := l_rowcount1 + sql%rowcount;
54: msc_phub_util.log('msc_item_inventory_f, delete='||sql%rowcount||', l_rowcount1='||l_rowcount1);
55: commit;
56:
57: delete from msc_item_orders_f
58: where plan_id=p_plan_id
59: and plan_run_id=p_plan_run_id
60: and (p_plan_id, sr_instance_id, organization_id, inventory_item_id) in
61: (select number1, number2, number3, number4 from msc_hub_query q where q.query_id=l_item_rn_qid);

Line 64: msc_phub_util.log('msc_item_orders_f, delete='||sql%rowcount||', l_rowcount2='||l_rowcount2);

60: and (p_plan_id, sr_instance_id, organization_id, inventory_item_id) in
61: (select number1, number2, number3, number4 from msc_hub_query q where q.query_id=l_item_rn_qid);
62:
63: l_rowcount2 := l_rowcount2 + sql%rowcount;
64: msc_phub_util.log('msc_item_orders_f, delete='||sql%rowcount||', l_rowcount2='||l_rowcount2);
65: commit;
66: end if;
67: end if;
68:

Line 571: -- msc_item_orders_f:final

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);
573: insert into msc_item_orders_f (
574: plan_id,
575: plan_run_id,

Line 573: insert into msc_item_orders_f (

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,
577: organization_id,

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

793: and fnd_profile.value('MSC_HUB_CUR_CODE_RPT')=mcc.to_currency(+)
794: and f.order_date=mcc.calendar_date(+);
795:
796: l_rowcount1 := l_rowcount1 + sql%rowcount;
797: msc_phub_util.log('insert into msc_item_orders_f:final: '||sql%rowcount);
798: commit;
799: msc_phub_util.gather_table_stats(msc_phub_util.stats_fact, 'MSC_ITEM_ORDERS_F', p_plan_run_id);
800:
801: -- msc_st_item_inventory_f:pab

Line 799: msc_phub_util.gather_table_stats(msc_phub_util.stats_fact, 'MSC_ITEM_ORDERS_F', p_plan_run_id);

795:
796: l_rowcount1 := l_rowcount1 + sql%rowcount;
797: msc_phub_util.log('insert into msc_item_orders_f:final: '||sql%rowcount);
798: commit;
799: msc_phub_util.gather_table_stats(msc_phub_util.stats_fact, 'MSC_ITEM_ORDERS_F', p_plan_run_id);
800:
801: -- msc_st_item_inventory_f:pab
802: insert /*+ append nologging */ into msc_st_item_inventory_f (
803: st_transaction_id,

Line 842: msc_item_orders_f f,

838: sysdate, fnd_global.user_id, fnd_global.login_id,
839: fnd_global.conc_program_id, fnd_global.conc_login_id,
840: fnd_global.prog_appl_id, fnd_global.conc_request_id
841: from
842: msc_item_orders_f f,
843: msc_apcc_item_d i,
844: msc_hub_query d
845: where f.plan_run_id=p_plan_run_id
846: and f.aggr_type=0

Line 1691: delete from msc_item_orders_f

1687: msc_phub_util.log('msc_item_pkg.summarize_item_orders_f');
1688: retcode := 0;
1689: errbuf := '';
1690:
1691: delete from msc_item_orders_f
1692: where plan_id=p_plan_id and plan_run_id=p_plan_run_id and aggr_type>0;
1693: msc_phub_util.log('msc_item_pkg.summarize_item_orders_f, delete='||sql%rowcount);
1694: commit;
1695:

Line 1697: insert into msc_item_orders_f (

1693: msc_phub_util.log('msc_item_pkg.summarize_item_orders_f, delete='||sql%rowcount);
1694: commit;
1695:
1696: -- level 1
1697: insert into msc_item_orders_f (
1698: plan_id, plan_run_id, io_plan_flag,
1699: sr_instance_id, organization_id, subinventory_code,
1700: owning_inst_id, owning_org_id,
1701: inventory_item_id,

Line 1827: msc_item_orders_f f,

1823: sysdate, fnd_global.user_id, fnd_global.login_id,
1824: fnd_global.conc_program_id, fnd_global.conc_login_id,
1825: fnd_global.prog_appl_id, fnd_global.conc_request_id
1826: from
1827: msc_item_orders_f f,
1828: msc_phub_item_categories_mv q
1829: where f.plan_id=p_plan_id and f.plan_run_id=p_plan_run_id
1830: and f.aggr_type=0
1831: and f.owning_inst_id=q.sr_instance_id(+)

Line 2172: ' '||l_apps_schema||'.msc_item_orders_f'||l_suffix||' f,'||

2168: l_sql := l_sql||
2169: ' fnd_global.user_id, sysdate,'||
2170: ' fnd_global.user_id, sysdate, fnd_global.login_id'||
2171: ' from'||
2172: ' '||l_apps_schema||'.msc_item_orders_f'||l_suffix||' f,'||
2173: ' '||l_apps_schema||'.msc_trading_partners'||l_suffix||' mtp,'||
2174: ' '||l_apps_schema||'.msc_trading_partners'||l_suffix||' mtp2,'||
2175: ' '||l_apps_schema||'.msc_items'||l_suffix||' mi'||
2176: ' where f.plan_run_id=:p_plan_run_id'||

Line 2364: l_fact_table varchar2(30) := 'msc_item_orders_f';

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');
2368: retcode := 0;

Line 2392: insert into msc_item_orders_f (

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,
2396: organization_id,