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_DEMAND_PKG dependencies on MSC_DEMANDS_CUM_F

Line 58: delete from msc_demands_cum_f

54: msc_phub_util.log('msc_demands_f, delete='||sql%rowcount||', l_rowcount1='||l_rowcount1);
55: commit;
56:
57: if (l_enable_num not in (2)) then
58: delete from msc_demands_cum_f
59: where plan_id = p_plan_id
60: and plan_run_id = p_plan_run_id
61: and (p_plan_id, sr_instance_id, organization_id, inventory_item_id) in
62: (select number1, number2, number3, number4 from msc_hub_query q where q.query_id = l_item_rn_qid);

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

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

Line 1460: msc_phub_util.unusuable_local_index('MSC_DEMANDS_CUM_F', p_plan_run_id, 1);

1456:
1457: msc_phub_util.gather_table_stats(msc_phub_util.stats_fact, 'MSC_DEMANDS_F', p_plan_run_id);
1458:
1459: if (l_enable_num not in (2)) then
1460: msc_phub_util.unusuable_local_index('MSC_DEMANDS_CUM_F', p_plan_run_id, 1);
1461: -- msc_demands_cum_f
1462: insert into msc_demands_cum_f (
1463: plan_id,
1464: plan_run_id,

Line 1461: -- msc_demands_cum_f

1457: msc_phub_util.gather_table_stats(msc_phub_util.stats_fact, 'MSC_DEMANDS_F', p_plan_run_id);
1458:
1459: if (l_enable_num not in (2)) then
1460: msc_phub_util.unusuable_local_index('MSC_DEMANDS_CUM_F', p_plan_run_id, 1);
1461: -- msc_demands_cum_f
1462: insert into msc_demands_cum_f (
1463: plan_id,
1464: plan_run_id,
1465: sr_instance_id,

Line 1462: insert into msc_demands_cum_f (

1458:
1459: if (l_enable_num not in (2)) then
1460: msc_phub_util.unusuable_local_index('MSC_DEMANDS_CUM_F', p_plan_run_id, 1);
1461: -- msc_demands_cum_f
1462: insert into msc_demands_cum_f (
1463: plan_id,
1464: plan_run_id,
1465: sr_instance_id,
1466: organization_id,

Line 1538: msc_phub_util.log('msc_demands_cum_f, insert='||sql%rowcount||', l_rowcount2='||l_rowcount2);

1534: f.io_plan_flag,
1535: d.calendar_date;
1536:
1537: l_rowcount2 := l_rowcount2 + sql%rowcount;
1538: msc_phub_util.log('msc_demands_cum_f, insert='||sql%rowcount||', l_rowcount2='||l_rowcount2);
1539: commit;
1540: msc_phub_util.unusuable_local_index('MSC_DEMANDS_CUM_F', p_plan_run_id, 2);
1541: msc_phub_util.gather_table_stats(msc_phub_util.stats_fact, 'MSC_DEMANDS_CUM_F', p_plan_run_id);
1542: end if;

Line 1540: msc_phub_util.unusuable_local_index('MSC_DEMANDS_CUM_F', p_plan_run_id, 2);

1536:
1537: l_rowcount2 := l_rowcount2 + sql%rowcount;
1538: msc_phub_util.log('msc_demands_cum_f, insert='||sql%rowcount||', l_rowcount2='||l_rowcount2);
1539: commit;
1540: msc_phub_util.unusuable_local_index('MSC_DEMANDS_CUM_F', p_plan_run_id, 2);
1541: msc_phub_util.gather_table_stats(msc_phub_util.stats_fact, 'MSC_DEMANDS_CUM_F', p_plan_run_id);
1542: end if;
1543:
1544: if (l_rowcount1 > 0) then

Line 1541: msc_phub_util.gather_table_stats(msc_phub_util.stats_fact, 'MSC_DEMANDS_CUM_F', p_plan_run_id);

1537: l_rowcount2 := l_rowcount2 + sql%rowcount;
1538: msc_phub_util.log('msc_demands_cum_f, insert='||sql%rowcount||', l_rowcount2='||l_rowcount2);
1539: commit;
1540: msc_phub_util.unusuable_local_index('MSC_DEMANDS_CUM_F', p_plan_run_id, 2);
1541: msc_phub_util.gather_table_stats(msc_phub_util.stats_fact, 'MSC_DEMANDS_CUM_F', p_plan_run_id);
1542: end if;
1543:
1544: if (l_rowcount1 > 0) then
1545: summarize_demands_f(errbuf, retcode, p_plan_id, p_plan_run_id);

Line 1944: delete from msc_demands_cum_f

1940: msc_phub_util.log('msc_demand_pkg.summarize_demands_cum_f');
1941: retcode := 0;
1942: errbuf := '';
1943:
1944: delete from msc_demands_cum_f
1945: where plan_id=p_plan_id and plan_run_id=p_plan_run_id and aggr_type>0;
1946: msc_phub_util.log('msc_demand_pkg.summarize_demands_cum_f, delete='||sql%rowcount);
1947: commit;
1948:

Line 1950: insert into msc_demands_cum_f (

1946: msc_phub_util.log('msc_demand_pkg.summarize_demands_cum_f, delete='||sql%rowcount);
1947: commit;
1948:
1949: -- level 1
1950: insert into msc_demands_cum_f (
1951: plan_id, plan_run_id,
1952: io_plan_flag,
1953: sr_instance_id, organization_id, inventory_item_id,
1954: original_item_id,

Line 1991: msc_demands_cum_f f,

1987: sysdate, fnd_global.user_id, fnd_global.login_id,
1988: fnd_global.conc_program_id, fnd_global.conc_login_id,
1989: fnd_global.prog_appl_id, fnd_global.conc_request_id
1990: from
1991: msc_demands_cum_f f,
1992: msc_phub_item_categories_mv q
1993: where f.plan_id = p_plan_id and f.plan_run_id = p_plan_run_id
1994: and f.aggr_type=0
1995: and f.owning_inst_id=q.sr_instance_id(+)

Line 2316: ' '||l_apps_schema||'.msc_demands_cum_f'||l_suffix||' f,'||

2312: ' f.cum_constrained_fcst_value2,'||
2313: ' fnd_global.user_id, sysdate,'||
2314: ' fnd_global.user_id, sysdate, fnd_global.login_id'||
2315: ' from'||
2316: ' '||l_apps_schema||'.msc_demands_cum_f'||l_suffix||' f,'||
2317: ' '||l_apps_schema||'.msc_trading_partners'||l_suffix||' mtp,'||
2318: ' '||l_apps_schema||'.msc_trading_partners'||l_suffix||' mtp2,'||
2319: ' '||l_apps_schema||'.msc_items'||l_suffix||' mi,'||
2320: ' '||l_apps_schema||'.msc_phub_customers_mv'||l_suffix||' cmv'||

Line 2547: l_fact_table varchar2(30) := 'msc_demands_cum_f';

2543: p_plan_type number, p_plan_start_date date, p_plan_cutoff_date date,
2544: p_upload_mode number, p_overwrite_after_date date, p_def_instance_code varchar2)
2545: is
2546: l_staging_table varchar2(30) := 'msc_st_demands_cum_f';
2547: l_fact_table varchar2(30) := 'msc_demands_cum_f';
2548: l_result number := 0;
2549: begin
2550: msc_phub_util.log('msc_demand_pkg.import_demands_cum_f');
2551: retcode := 0;

Line 2582: msc_phub_util.log('msc_demand_pkg.import_demands_cum_f: insert into msc_demands_cum_f');

2578: l_staging_table, p_st_transaction_id,
2579: 'customer_id', 'customer_site_id', 'owning_inst_id', 'region_id',
2580: 'customer_name', 'customer_site_code', 'zone');
2581:
2582: msc_phub_util.log('msc_demand_pkg.import_demands_cum_f: insert into msc_demands_cum_f');
2583: insert into msc_demands_cum_f (
2584: plan_id,
2585: plan_run_id,
2586: sr_instance_id,

Line 2583: insert into msc_demands_cum_f (

2579: 'customer_id', 'customer_site_id', 'owning_inst_id', 'region_id',
2580: 'customer_name', 'customer_site_code', 'zone');
2581:
2582: msc_phub_util.log('msc_demand_pkg.import_demands_cum_f: insert into msc_demands_cum_f');
2583: insert into msc_demands_cum_f (
2584: plan_id,
2585: plan_run_id,
2586: sr_instance_id,
2587: organization_id,