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.

[Home] [Help]

APPS.MSC_DEMANTRA_PKG dependencies on MSC_APCC_MEASURE_MAP_T

Line 580: function seeded_measure_mapping return msc_apcc_measure_map_table

576: msc_phub_util.log('msc_demantra_pkg.register_custom_measures: '||sqlerrm);
577: raise;
578: end register_custom_measures;
579:
580: function seeded_measure_mapping return msc_apcc_measure_map_table
581: is
582: t msc_apcc_measure_map_table := msc_apcc_measure_map_table();
583:
584: l_value varchar2(20) := ' * t.price';

Line 582: t msc_apcc_measure_map_table := msc_apcc_measure_map_table();

578: end register_custom_measures;
579:
580: function seeded_measure_mapping return msc_apcc_measure_map_table
581: is
582: t msc_apcc_measure_map_table := msc_apcc_measure_map_table();
583:
584: l_value varchar2(20) := ' * t.price';
585: l_rpt_cur varchar2(120) := ' * decode(t.currency_code, fnd_profile.value(''MSC_HUB_CUR_CODE_RPT''), 1, nvl(mcc.conv_rate, 0))';
586: l_value2 varchar2(120) := l_value||l_rpt_cur;

Line 597: t(1) := msc_apcc_measure_map_t(5, 'prty_demand', 'priority', 't.prty_demand', 'min');

593: l_production_history varchar2(60) := 'decode(t.record_type, 1, t.actual_prod, null)';
594:
595: begin
596: t.extend(56);
597: t(1) := msc_apcc_measure_map_t(5, 'prty_demand', 'priority', 't.prty_demand', 'min');
598: t(2) := msc_apcc_measure_map_t(5, 'fcst_consensus', 'consensus_fcst', 't.fcst_consensus', 'sum');
599: t(3) := msc_apcc_measure_map_t(5, 'fcst_consensus', 'consensus_fcst_value', 't.fcst_consensus'||l_value, 'sum');
600: t(4) := msc_apcc_measure_map_t(5, 'fcst_consensus', 'consensus_fcst_value2', 't.fcst_consensus'||l_value2, 'sum');
601: t(5) := msc_apcc_measure_map_t(5, 'fcst_consensus', 'consensus_fcst_cum', 'sum(t.fcst_consensus)'||l_over, 'sum');

Line 598: t(2) := msc_apcc_measure_map_t(5, 'fcst_consensus', 'consensus_fcst', 't.fcst_consensus', 'sum');

594:
595: begin
596: t.extend(56);
597: t(1) := msc_apcc_measure_map_t(5, 'prty_demand', 'priority', 't.prty_demand', 'min');
598: t(2) := msc_apcc_measure_map_t(5, 'fcst_consensus', 'consensus_fcst', 't.fcst_consensus', 'sum');
599: t(3) := msc_apcc_measure_map_t(5, 'fcst_consensus', 'consensus_fcst_value', 't.fcst_consensus'||l_value, 'sum');
600: t(4) := msc_apcc_measure_map_t(5, 'fcst_consensus', 'consensus_fcst_value2', 't.fcst_consensus'||l_value2, 'sum');
601: t(5) := msc_apcc_measure_map_t(5, 'fcst_consensus', 'consensus_fcst_cum', 'sum(t.fcst_consensus)'||l_over, 'sum');
602: t(6) := msc_apcc_measure_map_t(5, 'fcst_hyp_annual_plan', 'annual_plan_value', 't.fcst_hyp_annual_plan', 'sum');

Line 599: t(3) := msc_apcc_measure_map_t(5, 'fcst_consensus', 'consensus_fcst_value', 't.fcst_consensus'||l_value, 'sum');

595: begin
596: t.extend(56);
597: t(1) := msc_apcc_measure_map_t(5, 'prty_demand', 'priority', 't.prty_demand', 'min');
598: t(2) := msc_apcc_measure_map_t(5, 'fcst_consensus', 'consensus_fcst', 't.fcst_consensus', 'sum');
599: t(3) := msc_apcc_measure_map_t(5, 'fcst_consensus', 'consensus_fcst_value', 't.fcst_consensus'||l_value, 'sum');
600: t(4) := msc_apcc_measure_map_t(5, 'fcst_consensus', 'consensus_fcst_value2', 't.fcst_consensus'||l_value2, 'sum');
601: t(5) := msc_apcc_measure_map_t(5, 'fcst_consensus', 'consensus_fcst_cum', 'sum(t.fcst_consensus)'||l_over, 'sum');
602: t(6) := msc_apcc_measure_map_t(5, 'fcst_hyp_annual_plan', 'annual_plan_value', 't.fcst_hyp_annual_plan', 'sum');
603: t(7) := msc_apcc_measure_map_t(5, 'fcst_hyp_annual_plan', 'annual_plan_value2', 't.fcst_hyp_annual_plan'||l_rpt_cur, 'sum');

Line 600: t(4) := msc_apcc_measure_map_t(5, 'fcst_consensus', 'consensus_fcst_value2', 't.fcst_consensus'||l_value2, 'sum');

596: t.extend(56);
597: t(1) := msc_apcc_measure_map_t(5, 'prty_demand', 'priority', 't.prty_demand', 'min');
598: t(2) := msc_apcc_measure_map_t(5, 'fcst_consensus', 'consensus_fcst', 't.fcst_consensus', 'sum');
599: t(3) := msc_apcc_measure_map_t(5, 'fcst_consensus', 'consensus_fcst_value', 't.fcst_consensus'||l_value, 'sum');
600: t(4) := msc_apcc_measure_map_t(5, 'fcst_consensus', 'consensus_fcst_value2', 't.fcst_consensus'||l_value2, 'sum');
601: t(5) := msc_apcc_measure_map_t(5, 'fcst_consensus', 'consensus_fcst_cum', 'sum(t.fcst_consensus)'||l_over, 'sum');
602: t(6) := msc_apcc_measure_map_t(5, 'fcst_hyp_annual_plan', 'annual_plan_value', 't.fcst_hyp_annual_plan', 'sum');
603: t(7) := msc_apcc_measure_map_t(5, 'fcst_hyp_annual_plan', 'annual_plan_value2', 't.fcst_hyp_annual_plan'||l_rpt_cur, 'sum');
604: t(8) := msc_apcc_measure_map_t(5, 'fcst_booking', 'booking_fcst', 't.fcst_booking', 'sum');

Line 601: t(5) := msc_apcc_measure_map_t(5, 'fcst_consensus', 'consensus_fcst_cum', 'sum(t.fcst_consensus)'||l_over, 'sum');

597: t(1) := msc_apcc_measure_map_t(5, 'prty_demand', 'priority', 't.prty_demand', 'min');
598: t(2) := msc_apcc_measure_map_t(5, 'fcst_consensus', 'consensus_fcst', 't.fcst_consensus', 'sum');
599: t(3) := msc_apcc_measure_map_t(5, 'fcst_consensus', 'consensus_fcst_value', 't.fcst_consensus'||l_value, 'sum');
600: t(4) := msc_apcc_measure_map_t(5, 'fcst_consensus', 'consensus_fcst_value2', 't.fcst_consensus'||l_value2, 'sum');
601: t(5) := msc_apcc_measure_map_t(5, 'fcst_consensus', 'consensus_fcst_cum', 'sum(t.fcst_consensus)'||l_over, 'sum');
602: t(6) := msc_apcc_measure_map_t(5, 'fcst_hyp_annual_plan', 'annual_plan_value', 't.fcst_hyp_annual_plan', 'sum');
603: t(7) := msc_apcc_measure_map_t(5, 'fcst_hyp_annual_plan', 'annual_plan_value2', 't.fcst_hyp_annual_plan'||l_rpt_cur, 'sum');
604: t(8) := msc_apcc_measure_map_t(5, 'fcst_booking', 'booking_fcst', 't.fcst_booking', 'sum');
605: t(9) := msc_apcc_measure_map_t(5, 'fcst_booking', 'booking_fcst_value', 't.fcst_booking'||l_value, 'sum');

Line 602: t(6) := msc_apcc_measure_map_t(5, 'fcst_hyp_annual_plan', 'annual_plan_value', 't.fcst_hyp_annual_plan', 'sum');

598: t(2) := msc_apcc_measure_map_t(5, 'fcst_consensus', 'consensus_fcst', 't.fcst_consensus', 'sum');
599: t(3) := msc_apcc_measure_map_t(5, 'fcst_consensus', 'consensus_fcst_value', 't.fcst_consensus'||l_value, 'sum');
600: t(4) := msc_apcc_measure_map_t(5, 'fcst_consensus', 'consensus_fcst_value2', 't.fcst_consensus'||l_value2, 'sum');
601: t(5) := msc_apcc_measure_map_t(5, 'fcst_consensus', 'consensus_fcst_cum', 'sum(t.fcst_consensus)'||l_over, 'sum');
602: t(6) := msc_apcc_measure_map_t(5, 'fcst_hyp_annual_plan', 'annual_plan_value', 't.fcst_hyp_annual_plan', 'sum');
603: t(7) := msc_apcc_measure_map_t(5, 'fcst_hyp_annual_plan', 'annual_plan_value2', 't.fcst_hyp_annual_plan'||l_rpt_cur, 'sum');
604: t(8) := msc_apcc_measure_map_t(5, 'fcst_booking', 'booking_fcst', 't.fcst_booking', 'sum');
605: t(9) := msc_apcc_measure_map_t(5, 'fcst_booking', 'booking_fcst_value', 't.fcst_booking'||l_value, 'sum');
606: t(10) := msc_apcc_measure_map_t(5, 'fcst_booking', 'booking_fcst_value2', 't.fcst_booking'||l_value2, 'sum');

Line 603: t(7) := msc_apcc_measure_map_t(5, 'fcst_hyp_annual_plan', 'annual_plan_value2', 't.fcst_hyp_annual_plan'||l_rpt_cur, 'sum');

599: t(3) := msc_apcc_measure_map_t(5, 'fcst_consensus', 'consensus_fcst_value', 't.fcst_consensus'||l_value, 'sum');
600: t(4) := msc_apcc_measure_map_t(5, 'fcst_consensus', 'consensus_fcst_value2', 't.fcst_consensus'||l_value2, 'sum');
601: t(5) := msc_apcc_measure_map_t(5, 'fcst_consensus', 'consensus_fcst_cum', 'sum(t.fcst_consensus)'||l_over, 'sum');
602: t(6) := msc_apcc_measure_map_t(5, 'fcst_hyp_annual_plan', 'annual_plan_value', 't.fcst_hyp_annual_plan', 'sum');
603: t(7) := msc_apcc_measure_map_t(5, 'fcst_hyp_annual_plan', 'annual_plan_value2', 't.fcst_hyp_annual_plan'||l_rpt_cur, 'sum');
604: t(8) := msc_apcc_measure_map_t(5, 'fcst_booking', 'booking_fcst', 't.fcst_booking', 'sum');
605: t(9) := msc_apcc_measure_map_t(5, 'fcst_booking', 'booking_fcst_value', 't.fcst_booking'||l_value, 'sum');
606: t(10) := msc_apcc_measure_map_t(5, 'fcst_booking', 'booking_fcst_value2', 't.fcst_booking'||l_value2, 'sum');
607: t(11) := msc_apcc_measure_map_t(5, 'fcst_booking', 'booking_fcst_cum', 'sum(t.fcst_booking)'||l_over, 'sum');

Line 604: t(8) := msc_apcc_measure_map_t(5, 'fcst_booking', 'booking_fcst', 't.fcst_booking', 'sum');

600: t(4) := msc_apcc_measure_map_t(5, 'fcst_consensus', 'consensus_fcst_value2', 't.fcst_consensus'||l_value2, 'sum');
601: t(5) := msc_apcc_measure_map_t(5, 'fcst_consensus', 'consensus_fcst_cum', 'sum(t.fcst_consensus)'||l_over, 'sum');
602: t(6) := msc_apcc_measure_map_t(5, 'fcst_hyp_annual_plan', 'annual_plan_value', 't.fcst_hyp_annual_plan', 'sum');
603: t(7) := msc_apcc_measure_map_t(5, 'fcst_hyp_annual_plan', 'annual_plan_value2', 't.fcst_hyp_annual_plan'||l_rpt_cur, 'sum');
604: t(8) := msc_apcc_measure_map_t(5, 'fcst_booking', 'booking_fcst', 't.fcst_booking', 'sum');
605: t(9) := msc_apcc_measure_map_t(5, 'fcst_booking', 'booking_fcst_value', 't.fcst_booking'||l_value, 'sum');
606: t(10) := msc_apcc_measure_map_t(5, 'fcst_booking', 'booking_fcst_value2', 't.fcst_booking'||l_value2, 'sum');
607: t(11) := msc_apcc_measure_map_t(5, 'fcst_booking', 'booking_fcst_cum', 'sum(t.fcst_booking)'||l_over, 'sum');
608: t(12) := msc_apcc_measure_map_t(5, 'budget', 'budget', 't.budget', 'sum');

Line 605: t(9) := msc_apcc_measure_map_t(5, 'fcst_booking', 'booking_fcst_value', 't.fcst_booking'||l_value, 'sum');

601: t(5) := msc_apcc_measure_map_t(5, 'fcst_consensus', 'consensus_fcst_cum', 'sum(t.fcst_consensus)'||l_over, 'sum');
602: t(6) := msc_apcc_measure_map_t(5, 'fcst_hyp_annual_plan', 'annual_plan_value', 't.fcst_hyp_annual_plan', 'sum');
603: t(7) := msc_apcc_measure_map_t(5, 'fcst_hyp_annual_plan', 'annual_plan_value2', 't.fcst_hyp_annual_plan'||l_rpt_cur, 'sum');
604: t(8) := msc_apcc_measure_map_t(5, 'fcst_booking', 'booking_fcst', 't.fcst_booking', 'sum');
605: t(9) := msc_apcc_measure_map_t(5, 'fcst_booking', 'booking_fcst_value', 't.fcst_booking'||l_value, 'sum');
606: t(10) := msc_apcc_measure_map_t(5, 'fcst_booking', 'booking_fcst_value2', 't.fcst_booking'||l_value2, 'sum');
607: t(11) := msc_apcc_measure_map_t(5, 'fcst_booking', 'booking_fcst_cum', 'sum(t.fcst_booking)'||l_over, 'sum');
608: t(12) := msc_apcc_measure_map_t(5, 'budget', 'budget', 't.budget', 'sum');
609: t(13) := msc_apcc_measure_map_t(5, 'budget', 'budget2', 't.budget'||l_rpt_cur, 'sum');

Line 606: t(10) := msc_apcc_measure_map_t(5, 'fcst_booking', 'booking_fcst_value2', 't.fcst_booking'||l_value2, 'sum');

602: t(6) := msc_apcc_measure_map_t(5, 'fcst_hyp_annual_plan', 'annual_plan_value', 't.fcst_hyp_annual_plan', 'sum');
603: t(7) := msc_apcc_measure_map_t(5, 'fcst_hyp_annual_plan', 'annual_plan_value2', 't.fcst_hyp_annual_plan'||l_rpt_cur, 'sum');
604: t(8) := msc_apcc_measure_map_t(5, 'fcst_booking', 'booking_fcst', 't.fcst_booking', 'sum');
605: t(9) := msc_apcc_measure_map_t(5, 'fcst_booking', 'booking_fcst_value', 't.fcst_booking'||l_value, 'sum');
606: t(10) := msc_apcc_measure_map_t(5, 'fcst_booking', 'booking_fcst_value2', 't.fcst_booking'||l_value2, 'sum');
607: t(11) := msc_apcc_measure_map_t(5, 'fcst_booking', 'booking_fcst_cum', 'sum(t.fcst_booking)'||l_over, 'sum');
608: t(12) := msc_apcc_measure_map_t(5, 'budget', 'budget', 't.budget', 'sum');
609: t(13) := msc_apcc_measure_map_t(5, 'budget', 'budget2', 't.budget'||l_rpt_cur, 'sum');
610: t(14) := msc_apcc_measure_map_t(5, 'budget', 'budget_cum', 'sum(t.budget)'||l_over, 'sum');

Line 607: t(11) := msc_apcc_measure_map_t(5, 'fcst_booking', 'booking_fcst_cum', 'sum(t.fcst_booking)'||l_over, 'sum');

603: t(7) := msc_apcc_measure_map_t(5, 'fcst_hyp_annual_plan', 'annual_plan_value2', 't.fcst_hyp_annual_plan'||l_rpt_cur, 'sum');
604: t(8) := msc_apcc_measure_map_t(5, 'fcst_booking', 'booking_fcst', 't.fcst_booking', 'sum');
605: t(9) := msc_apcc_measure_map_t(5, 'fcst_booking', 'booking_fcst_value', 't.fcst_booking'||l_value, 'sum');
606: t(10) := msc_apcc_measure_map_t(5, 'fcst_booking', 'booking_fcst_value2', 't.fcst_booking'||l_value2, 'sum');
607: t(11) := msc_apcc_measure_map_t(5, 'fcst_booking', 'booking_fcst_cum', 'sum(t.fcst_booking)'||l_over, 'sum');
608: t(12) := msc_apcc_measure_map_t(5, 'budget', 'budget', 't.budget', 'sum');
609: t(13) := msc_apcc_measure_map_t(5, 'budget', 'budget2', 't.budget'||l_rpt_cur, 'sum');
610: t(14) := msc_apcc_measure_map_t(5, 'budget', 'budget_cum', 'sum(t.budget)'||l_over, 'sum');
611: t(15) := msc_apcc_measure_map_t(5, 'budget', 'budget2_cum', 'sum(t.budget'||l_rpt_cur||')'||l_over, 'sum');

Line 608: t(12) := msc_apcc_measure_map_t(5, 'budget', 'budget', 't.budget', 'sum');

604: t(8) := msc_apcc_measure_map_t(5, 'fcst_booking', 'booking_fcst', 't.fcst_booking', 'sum');
605: t(9) := msc_apcc_measure_map_t(5, 'fcst_booking', 'booking_fcst_value', 't.fcst_booking'||l_value, 'sum');
606: t(10) := msc_apcc_measure_map_t(5, 'fcst_booking', 'booking_fcst_value2', 't.fcst_booking'||l_value2, 'sum');
607: t(11) := msc_apcc_measure_map_t(5, 'fcst_booking', 'booking_fcst_cum', 'sum(t.fcst_booking)'||l_over, 'sum');
608: t(12) := msc_apcc_measure_map_t(5, 'budget', 'budget', 't.budget', 'sum');
609: t(13) := msc_apcc_measure_map_t(5, 'budget', 'budget2', 't.budget'||l_rpt_cur, 'sum');
610: t(14) := msc_apcc_measure_map_t(5, 'budget', 'budget_cum', 'sum(t.budget)'||l_over, 'sum');
611: t(15) := msc_apcc_measure_map_t(5, 'budget', 'budget2_cum', 'sum(t.budget'||l_rpt_cur||')'||l_over, 'sum');
612: t(16) := msc_apcc_measure_map_t(5, 'c_pred', 'final_fcst', 't.c_pred', 'sum');

Line 609: t(13) := msc_apcc_measure_map_t(5, 'budget', 'budget2', 't.budget'||l_rpt_cur, 'sum');

605: t(9) := msc_apcc_measure_map_t(5, 'fcst_booking', 'booking_fcst_value', 't.fcst_booking'||l_value, 'sum');
606: t(10) := msc_apcc_measure_map_t(5, 'fcst_booking', 'booking_fcst_value2', 't.fcst_booking'||l_value2, 'sum');
607: t(11) := msc_apcc_measure_map_t(5, 'fcst_booking', 'booking_fcst_cum', 'sum(t.fcst_booking)'||l_over, 'sum');
608: t(12) := msc_apcc_measure_map_t(5, 'budget', 'budget', 't.budget', 'sum');
609: t(13) := msc_apcc_measure_map_t(5, 'budget', 'budget2', 't.budget'||l_rpt_cur, 'sum');
610: t(14) := msc_apcc_measure_map_t(5, 'budget', 'budget_cum', 'sum(t.budget)'||l_over, 'sum');
611: t(15) := msc_apcc_measure_map_t(5, 'budget', 'budget2_cum', 'sum(t.budget'||l_rpt_cur||')'||l_over, 'sum');
612: t(16) := msc_apcc_measure_map_t(5, 'c_pred', 'final_fcst', 't.c_pred', 'sum');
613: t(17) := msc_apcc_measure_map_t(5, 'c_pred', 'final_fcst_value', 't.c_pred'||l_value, 'sum');

Line 610: t(14) := msc_apcc_measure_map_t(5, 'budget', 'budget_cum', 'sum(t.budget)'||l_over, 'sum');

606: t(10) := msc_apcc_measure_map_t(5, 'fcst_booking', 'booking_fcst_value2', 't.fcst_booking'||l_value2, 'sum');
607: t(11) := msc_apcc_measure_map_t(5, 'fcst_booking', 'booking_fcst_cum', 'sum(t.fcst_booking)'||l_over, 'sum');
608: t(12) := msc_apcc_measure_map_t(5, 'budget', 'budget', 't.budget', 'sum');
609: t(13) := msc_apcc_measure_map_t(5, 'budget', 'budget2', 't.budget'||l_rpt_cur, 'sum');
610: t(14) := msc_apcc_measure_map_t(5, 'budget', 'budget_cum', 'sum(t.budget)'||l_over, 'sum');
611: t(15) := msc_apcc_measure_map_t(5, 'budget', 'budget2_cum', 'sum(t.budget'||l_rpt_cur||')'||l_over, 'sum');
612: t(16) := msc_apcc_measure_map_t(5, 'c_pred', 'final_fcst', 't.c_pred', 'sum');
613: t(17) := msc_apcc_measure_map_t(5, 'c_pred', 'final_fcst_value', 't.c_pred'||l_value, 'sum');
614: t(18) := msc_apcc_measure_map_t(5, 'c_pred', 'final_fcst_value2', 't.c_pred'||l_value2, 'sum');

Line 611: t(15) := msc_apcc_measure_map_t(5, 'budget', 'budget2_cum', 'sum(t.budget'||l_rpt_cur||')'||l_over, 'sum');

607: t(11) := msc_apcc_measure_map_t(5, 'fcst_booking', 'booking_fcst_cum', 'sum(t.fcst_booking)'||l_over, 'sum');
608: t(12) := msc_apcc_measure_map_t(5, 'budget', 'budget', 't.budget', 'sum');
609: t(13) := msc_apcc_measure_map_t(5, 'budget', 'budget2', 't.budget'||l_rpt_cur, 'sum');
610: t(14) := msc_apcc_measure_map_t(5, 'budget', 'budget_cum', 'sum(t.budget)'||l_over, 'sum');
611: t(15) := msc_apcc_measure_map_t(5, 'budget', 'budget2_cum', 'sum(t.budget'||l_rpt_cur||')'||l_over, 'sum');
612: t(16) := msc_apcc_measure_map_t(5, 'c_pred', 'final_fcst', 't.c_pred', 'sum');
613: t(17) := msc_apcc_measure_map_t(5, 'c_pred', 'final_fcst_value', 't.c_pred'||l_value, 'sum');
614: t(18) := msc_apcc_measure_map_t(5, 'c_pred', 'final_fcst_value2', 't.c_pred'||l_value2, 'sum');
615: t(19) := msc_apcc_measure_map_t(5, 'c_pred', 'final_fcst_cum', 'sum(t.c_pred)'||l_over, 'sum');

Line 612: t(16) := msc_apcc_measure_map_t(5, 'c_pred', 'final_fcst', 't.c_pred', 'sum');

608: t(12) := msc_apcc_measure_map_t(5, 'budget', 'budget', 't.budget', 'sum');
609: t(13) := msc_apcc_measure_map_t(5, 'budget', 'budget2', 't.budget'||l_rpt_cur, 'sum');
610: t(14) := msc_apcc_measure_map_t(5, 'budget', 'budget_cum', 'sum(t.budget)'||l_over, 'sum');
611: t(15) := msc_apcc_measure_map_t(5, 'budget', 'budget2_cum', 'sum(t.budget'||l_rpt_cur||')'||l_over, 'sum');
612: t(16) := msc_apcc_measure_map_t(5, 'c_pred', 'final_fcst', 't.c_pred', 'sum');
613: t(17) := msc_apcc_measure_map_t(5, 'c_pred', 'final_fcst_value', 't.c_pred'||l_value, 'sum');
614: t(18) := msc_apcc_measure_map_t(5, 'c_pred', 'final_fcst_value2', 't.c_pred'||l_value2, 'sum');
615: t(19) := msc_apcc_measure_map_t(5, 'c_pred', 'final_fcst_cum', 'sum(t.c_pred)'||l_over, 'sum');
616: t(20) := msc_apcc_measure_map_t(5, 'fcst_hyp_financial', 'financial_fcst_value', 't.fcst_hyp_financial', 'sum');

Line 613: t(17) := msc_apcc_measure_map_t(5, 'c_pred', 'final_fcst_value', 't.c_pred'||l_value, 'sum');

609: t(13) := msc_apcc_measure_map_t(5, 'budget', 'budget2', 't.budget'||l_rpt_cur, 'sum');
610: t(14) := msc_apcc_measure_map_t(5, 'budget', 'budget_cum', 'sum(t.budget)'||l_over, 'sum');
611: t(15) := msc_apcc_measure_map_t(5, 'budget', 'budget2_cum', 'sum(t.budget'||l_rpt_cur||')'||l_over, 'sum');
612: t(16) := msc_apcc_measure_map_t(5, 'c_pred', 'final_fcst', 't.c_pred', 'sum');
613: t(17) := msc_apcc_measure_map_t(5, 'c_pred', 'final_fcst_value', 't.c_pred'||l_value, 'sum');
614: t(18) := msc_apcc_measure_map_t(5, 'c_pred', 'final_fcst_value2', 't.c_pred'||l_value2, 'sum');
615: t(19) := msc_apcc_measure_map_t(5, 'c_pred', 'final_fcst_cum', 'sum(t.c_pred)'||l_over, 'sum');
616: t(20) := msc_apcc_measure_map_t(5, 'fcst_hyp_financial', 'financial_fcst_value', 't.fcst_hyp_financial', 'sum');
617: t(21) := msc_apcc_measure_map_t(5, 'fcst_hyp_financial', 'financial_fcst_value2', 't.fcst_hyp_financial'||l_rpt_cur, 'sum');

Line 614: t(18) := msc_apcc_measure_map_t(5, 'c_pred', 'final_fcst_value2', 't.c_pred'||l_value2, 'sum');

610: t(14) := msc_apcc_measure_map_t(5, 'budget', 'budget_cum', 'sum(t.budget)'||l_over, 'sum');
611: t(15) := msc_apcc_measure_map_t(5, 'budget', 'budget2_cum', 'sum(t.budget'||l_rpt_cur||')'||l_over, 'sum');
612: t(16) := msc_apcc_measure_map_t(5, 'c_pred', 'final_fcst', 't.c_pred', 'sum');
613: t(17) := msc_apcc_measure_map_t(5, 'c_pred', 'final_fcst_value', 't.c_pred'||l_value, 'sum');
614: t(18) := msc_apcc_measure_map_t(5, 'c_pred', 'final_fcst_value2', 't.c_pred'||l_value2, 'sum');
615: t(19) := msc_apcc_measure_map_t(5, 'c_pred', 'final_fcst_cum', 'sum(t.c_pred)'||l_over, 'sum');
616: t(20) := msc_apcc_measure_map_t(5, 'fcst_hyp_financial', 'financial_fcst_value', 't.fcst_hyp_financial', 'sum');
617: t(21) := msc_apcc_measure_map_t(5, 'fcst_hyp_financial', 'financial_fcst_value2', 't.fcst_hyp_financial'||l_rpt_cur, 'sum');
618: t(22) := msc_apcc_measure_map_t(5, 'mktg_fcst', 'mktg_fcst', 't.mktg_fcst', 'sum');

Line 615: t(19) := msc_apcc_measure_map_t(5, 'c_pred', 'final_fcst_cum', 'sum(t.c_pred)'||l_over, 'sum');

611: t(15) := msc_apcc_measure_map_t(5, 'budget', 'budget2_cum', 'sum(t.budget'||l_rpt_cur||')'||l_over, 'sum');
612: t(16) := msc_apcc_measure_map_t(5, 'c_pred', 'final_fcst', 't.c_pred', 'sum');
613: t(17) := msc_apcc_measure_map_t(5, 'c_pred', 'final_fcst_value', 't.c_pred'||l_value, 'sum');
614: t(18) := msc_apcc_measure_map_t(5, 'c_pred', 'final_fcst_value2', 't.c_pred'||l_value2, 'sum');
615: t(19) := msc_apcc_measure_map_t(5, 'c_pred', 'final_fcst_cum', 'sum(t.c_pred)'||l_over, 'sum');
616: t(20) := msc_apcc_measure_map_t(5, 'fcst_hyp_financial', 'financial_fcst_value', 't.fcst_hyp_financial', 'sum');
617: t(21) := msc_apcc_measure_map_t(5, 'fcst_hyp_financial', 'financial_fcst_value2', 't.fcst_hyp_financial'||l_rpt_cur, 'sum');
618: t(22) := msc_apcc_measure_map_t(5, 'mktg_fcst', 'mktg_fcst', 't.mktg_fcst', 'sum');
619: t(23) := msc_apcc_measure_map_t(5, 'mktg_fcst', 'mktg_fcst_value', 't.mktg_fcst'||l_value, 'sum');

Line 616: t(20) := msc_apcc_measure_map_t(5, 'fcst_hyp_financial', 'financial_fcst_value', 't.fcst_hyp_financial', 'sum');

612: t(16) := msc_apcc_measure_map_t(5, 'c_pred', 'final_fcst', 't.c_pred', 'sum');
613: t(17) := msc_apcc_measure_map_t(5, 'c_pred', 'final_fcst_value', 't.c_pred'||l_value, 'sum');
614: t(18) := msc_apcc_measure_map_t(5, 'c_pred', 'final_fcst_value2', 't.c_pred'||l_value2, 'sum');
615: t(19) := msc_apcc_measure_map_t(5, 'c_pred', 'final_fcst_cum', 'sum(t.c_pred)'||l_over, 'sum');
616: t(20) := msc_apcc_measure_map_t(5, 'fcst_hyp_financial', 'financial_fcst_value', 't.fcst_hyp_financial', 'sum');
617: t(21) := msc_apcc_measure_map_t(5, 'fcst_hyp_financial', 'financial_fcst_value2', 't.fcst_hyp_financial'||l_rpt_cur, 'sum');
618: t(22) := msc_apcc_measure_map_t(5, 'mktg_fcst', 'mktg_fcst', 't.mktg_fcst', 'sum');
619: t(23) := msc_apcc_measure_map_t(5, 'mktg_fcst', 'mktg_fcst_value', 't.mktg_fcst'||l_value, 'sum');
620: t(24) := msc_apcc_measure_map_t(5, 'mktg_fcst', 'mktg_fcst_value2', 't.mktg_fcst'||l_value2, 'sum');

Line 617: t(21) := msc_apcc_measure_map_t(5, 'fcst_hyp_financial', 'financial_fcst_value2', 't.fcst_hyp_financial'||l_rpt_cur, 'sum');

613: t(17) := msc_apcc_measure_map_t(5, 'c_pred', 'final_fcst_value', 't.c_pred'||l_value, 'sum');
614: t(18) := msc_apcc_measure_map_t(5, 'c_pred', 'final_fcst_value2', 't.c_pred'||l_value2, 'sum');
615: t(19) := msc_apcc_measure_map_t(5, 'c_pred', 'final_fcst_cum', 'sum(t.c_pred)'||l_over, 'sum');
616: t(20) := msc_apcc_measure_map_t(5, 'fcst_hyp_financial', 'financial_fcst_value', 't.fcst_hyp_financial', 'sum');
617: t(21) := msc_apcc_measure_map_t(5, 'fcst_hyp_financial', 'financial_fcst_value2', 't.fcst_hyp_financial'||l_rpt_cur, 'sum');
618: t(22) := msc_apcc_measure_map_t(5, 'mktg_fcst', 'mktg_fcst', 't.mktg_fcst', 'sum');
619: t(23) := msc_apcc_measure_map_t(5, 'mktg_fcst', 'mktg_fcst_value', 't.mktg_fcst'||l_value, 'sum');
620: t(24) := msc_apcc_measure_map_t(5, 'mktg_fcst', 'mktg_fcst_value2', 't.mktg_fcst'||l_value2, 'sum');
621: t(25) := msc_apcc_measure_map_t(5, 'mktg_fcst', 'mktg_fcst_cum', 'sum(t.mktg_fcst)'||l_over, 'sum');

Line 618: t(22) := msc_apcc_measure_map_t(5, 'mktg_fcst', 'mktg_fcst', 't.mktg_fcst', 'sum');

614: t(18) := msc_apcc_measure_map_t(5, 'c_pred', 'final_fcst_value2', 't.c_pred'||l_value2, 'sum');
615: t(19) := msc_apcc_measure_map_t(5, 'c_pred', 'final_fcst_cum', 'sum(t.c_pred)'||l_over, 'sum');
616: t(20) := msc_apcc_measure_map_t(5, 'fcst_hyp_financial', 'financial_fcst_value', 't.fcst_hyp_financial', 'sum');
617: t(21) := msc_apcc_measure_map_t(5, 'fcst_hyp_financial', 'financial_fcst_value2', 't.fcst_hyp_financial'||l_rpt_cur, 'sum');
618: t(22) := msc_apcc_measure_map_t(5, 'mktg_fcst', 'mktg_fcst', 't.mktg_fcst', 'sum');
619: t(23) := msc_apcc_measure_map_t(5, 'mktg_fcst', 'mktg_fcst_value', 't.mktg_fcst'||l_value, 'sum');
620: t(24) := msc_apcc_measure_map_t(5, 'mktg_fcst', 'mktg_fcst_value2', 't.mktg_fcst'||l_value2, 'sum');
621: t(25) := msc_apcc_measure_map_t(5, 'mktg_fcst', 'mktg_fcst_cum', 'sum(t.mktg_fcst)'||l_over, 'sum');
622: t(26) := msc_apcc_measure_map_t(5, 'sales_fcst', 'sales_fcst', 't.sales_fcst', 'sum');

Line 619: t(23) := msc_apcc_measure_map_t(5, 'mktg_fcst', 'mktg_fcst_value', 't.mktg_fcst'||l_value, 'sum');

615: t(19) := msc_apcc_measure_map_t(5, 'c_pred', 'final_fcst_cum', 'sum(t.c_pred)'||l_over, 'sum');
616: t(20) := msc_apcc_measure_map_t(5, 'fcst_hyp_financial', 'financial_fcst_value', 't.fcst_hyp_financial', 'sum');
617: t(21) := msc_apcc_measure_map_t(5, 'fcst_hyp_financial', 'financial_fcst_value2', 't.fcst_hyp_financial'||l_rpt_cur, 'sum');
618: t(22) := msc_apcc_measure_map_t(5, 'mktg_fcst', 'mktg_fcst', 't.mktg_fcst', 'sum');
619: t(23) := msc_apcc_measure_map_t(5, 'mktg_fcst', 'mktg_fcst_value', 't.mktg_fcst'||l_value, 'sum');
620: t(24) := msc_apcc_measure_map_t(5, 'mktg_fcst', 'mktg_fcst_value2', 't.mktg_fcst'||l_value2, 'sum');
621: t(25) := msc_apcc_measure_map_t(5, 'mktg_fcst', 'mktg_fcst_cum', 'sum(t.mktg_fcst)'||l_over, 'sum');
622: t(26) := msc_apcc_measure_map_t(5, 'sales_fcst', 'sales_fcst', 't.sales_fcst', 'sum');
623: t(27) := msc_apcc_measure_map_t(5, 'sales_fcst', 'sales_fcst_value', 't.sales_fcst'||l_value, 'sum');

Line 620: t(24) := msc_apcc_measure_map_t(5, 'mktg_fcst', 'mktg_fcst_value2', 't.mktg_fcst'||l_value2, 'sum');

616: t(20) := msc_apcc_measure_map_t(5, 'fcst_hyp_financial', 'financial_fcst_value', 't.fcst_hyp_financial', 'sum');
617: t(21) := msc_apcc_measure_map_t(5, 'fcst_hyp_financial', 'financial_fcst_value2', 't.fcst_hyp_financial'||l_rpt_cur, 'sum');
618: t(22) := msc_apcc_measure_map_t(5, 'mktg_fcst', 'mktg_fcst', 't.mktg_fcst', 'sum');
619: t(23) := msc_apcc_measure_map_t(5, 'mktg_fcst', 'mktg_fcst_value', 't.mktg_fcst'||l_value, 'sum');
620: t(24) := msc_apcc_measure_map_t(5, 'mktg_fcst', 'mktg_fcst_value2', 't.mktg_fcst'||l_value2, 'sum');
621: t(25) := msc_apcc_measure_map_t(5, 'mktg_fcst', 'mktg_fcst_cum', 'sum(t.mktg_fcst)'||l_over, 'sum');
622: t(26) := msc_apcc_measure_map_t(5, 'sales_fcst', 'sales_fcst', 't.sales_fcst', 'sum');
623: t(27) := msc_apcc_measure_map_t(5, 'sales_fcst', 'sales_fcst_value', 't.sales_fcst'||l_value, 'sum');
624: t(28) := msc_apcc_measure_map_t(5, 'sales_fcst', 'sales_fcst_value2', 't.sales_fcst'||l_value2, 'sum');

Line 621: t(25) := msc_apcc_measure_map_t(5, 'mktg_fcst', 'mktg_fcst_cum', 'sum(t.mktg_fcst)'||l_over, 'sum');

617: t(21) := msc_apcc_measure_map_t(5, 'fcst_hyp_financial', 'financial_fcst_value2', 't.fcst_hyp_financial'||l_rpt_cur, 'sum');
618: t(22) := msc_apcc_measure_map_t(5, 'mktg_fcst', 'mktg_fcst', 't.mktg_fcst', 'sum');
619: t(23) := msc_apcc_measure_map_t(5, 'mktg_fcst', 'mktg_fcst_value', 't.mktg_fcst'||l_value, 'sum');
620: t(24) := msc_apcc_measure_map_t(5, 'mktg_fcst', 'mktg_fcst_value2', 't.mktg_fcst'||l_value2, 'sum');
621: t(25) := msc_apcc_measure_map_t(5, 'mktg_fcst', 'mktg_fcst_cum', 'sum(t.mktg_fcst)'||l_over, 'sum');
622: t(26) := msc_apcc_measure_map_t(5, 'sales_fcst', 'sales_fcst', 't.sales_fcst', 'sum');
623: t(27) := msc_apcc_measure_map_t(5, 'sales_fcst', 'sales_fcst_value', 't.sales_fcst'||l_value, 'sum');
624: t(28) := msc_apcc_measure_map_t(5, 'sales_fcst', 'sales_fcst_value2', 't.sales_fcst'||l_value2, 'sum');
625: t(29) := msc_apcc_measure_map_t(5, 'sales_fcst', 'sales_fcst_cum', 'sum(t.sales_fcst)'||l_over, 'sum');

Line 622: t(26) := msc_apcc_measure_map_t(5, 'sales_fcst', 'sales_fcst', 't.sales_fcst', 'sum');

618: t(22) := msc_apcc_measure_map_t(5, 'mktg_fcst', 'mktg_fcst', 't.mktg_fcst', 'sum');
619: t(23) := msc_apcc_measure_map_t(5, 'mktg_fcst', 'mktg_fcst_value', 't.mktg_fcst'||l_value, 'sum');
620: t(24) := msc_apcc_measure_map_t(5, 'mktg_fcst', 'mktg_fcst_value2', 't.mktg_fcst'||l_value2, 'sum');
621: t(25) := msc_apcc_measure_map_t(5, 'mktg_fcst', 'mktg_fcst_cum', 'sum(t.mktg_fcst)'||l_over, 'sum');
622: t(26) := msc_apcc_measure_map_t(5, 'sales_fcst', 'sales_fcst', 't.sales_fcst', 'sum');
623: t(27) := msc_apcc_measure_map_t(5, 'sales_fcst', 'sales_fcst_value', 't.sales_fcst'||l_value, 'sum');
624: t(28) := msc_apcc_measure_map_t(5, 'sales_fcst', 'sales_fcst_value2', 't.sales_fcst'||l_value2, 'sum');
625: t(29) := msc_apcc_measure_map_t(5, 'sales_fcst', 'sales_fcst_cum', 'sum(t.sales_fcst)'||l_over, 'sum');
626: t(30) := msc_apcc_measure_map_t(5, 'fcst_shipment', 'shipment_fcst', 't.fcst_shipment', 'sum');

Line 623: t(27) := msc_apcc_measure_map_t(5, 'sales_fcst', 'sales_fcst_value', 't.sales_fcst'||l_value, 'sum');

619: t(23) := msc_apcc_measure_map_t(5, 'mktg_fcst', 'mktg_fcst_value', 't.mktg_fcst'||l_value, 'sum');
620: t(24) := msc_apcc_measure_map_t(5, 'mktg_fcst', 'mktg_fcst_value2', 't.mktg_fcst'||l_value2, 'sum');
621: t(25) := msc_apcc_measure_map_t(5, 'mktg_fcst', 'mktg_fcst_cum', 'sum(t.mktg_fcst)'||l_over, 'sum');
622: t(26) := msc_apcc_measure_map_t(5, 'sales_fcst', 'sales_fcst', 't.sales_fcst', 'sum');
623: t(27) := msc_apcc_measure_map_t(5, 'sales_fcst', 'sales_fcst_value', 't.sales_fcst'||l_value, 'sum');
624: t(28) := msc_apcc_measure_map_t(5, 'sales_fcst', 'sales_fcst_value2', 't.sales_fcst'||l_value2, 'sum');
625: t(29) := msc_apcc_measure_map_t(5, 'sales_fcst', 'sales_fcst_cum', 'sum(t.sales_fcst)'||l_over, 'sum');
626: t(30) := msc_apcc_measure_map_t(5, 'fcst_shipment', 'shipment_fcst', 't.fcst_shipment', 'sum');
627: t(31) := msc_apcc_measure_map_t(5, 'fcst_shipment', 'shipment_fcst_value', 't.fcst_shipment'||l_value, 'sum');

Line 624: t(28) := msc_apcc_measure_map_t(5, 'sales_fcst', 'sales_fcst_value2', 't.sales_fcst'||l_value2, 'sum');

620: t(24) := msc_apcc_measure_map_t(5, 'mktg_fcst', 'mktg_fcst_value2', 't.mktg_fcst'||l_value2, 'sum');
621: t(25) := msc_apcc_measure_map_t(5, 'mktg_fcst', 'mktg_fcst_cum', 'sum(t.mktg_fcst)'||l_over, 'sum');
622: t(26) := msc_apcc_measure_map_t(5, 'sales_fcst', 'sales_fcst', 't.sales_fcst', 'sum');
623: t(27) := msc_apcc_measure_map_t(5, 'sales_fcst', 'sales_fcst_value', 't.sales_fcst'||l_value, 'sum');
624: t(28) := msc_apcc_measure_map_t(5, 'sales_fcst', 'sales_fcst_value2', 't.sales_fcst'||l_value2, 'sum');
625: t(29) := msc_apcc_measure_map_t(5, 'sales_fcst', 'sales_fcst_cum', 'sum(t.sales_fcst)'||l_over, 'sum');
626: t(30) := msc_apcc_measure_map_t(5, 'fcst_shipment', 'shipment_fcst', 't.fcst_shipment', 'sum');
627: t(31) := msc_apcc_measure_map_t(5, 'fcst_shipment', 'shipment_fcst_value', 't.fcst_shipment'||l_value, 'sum');
628: t(32) := msc_apcc_measure_map_t(5, 'fcst_shipment', 'shipment_fcst_value2', 't.fcst_shipment'||l_value2, 'sum');

Line 625: t(29) := msc_apcc_measure_map_t(5, 'sales_fcst', 'sales_fcst_cum', 'sum(t.sales_fcst)'||l_over, 'sum');

621: t(25) := msc_apcc_measure_map_t(5, 'mktg_fcst', 'mktg_fcst_cum', 'sum(t.mktg_fcst)'||l_over, 'sum');
622: t(26) := msc_apcc_measure_map_t(5, 'sales_fcst', 'sales_fcst', 't.sales_fcst', 'sum');
623: t(27) := msc_apcc_measure_map_t(5, 'sales_fcst', 'sales_fcst_value', 't.sales_fcst'||l_value, 'sum');
624: t(28) := msc_apcc_measure_map_t(5, 'sales_fcst', 'sales_fcst_value2', 't.sales_fcst'||l_value2, 'sum');
625: t(29) := msc_apcc_measure_map_t(5, 'sales_fcst', 'sales_fcst_cum', 'sum(t.sales_fcst)'||l_over, 'sum');
626: t(30) := msc_apcc_measure_map_t(5, 'fcst_shipment', 'shipment_fcst', 't.fcst_shipment', 'sum');
627: t(31) := msc_apcc_measure_map_t(5, 'fcst_shipment', 'shipment_fcst_value', 't.fcst_shipment'||l_value, 'sum');
628: t(32) := msc_apcc_measure_map_t(5, 'fcst_shipment', 'shipment_fcst_value2', 't.fcst_shipment'||l_value2, 'sum');
629: t(33) := msc_apcc_measure_map_t(5, 'fcst_shipment', 'shipment_fcst_cum', 'sum(t.fcst_shipment)'||l_over, 'sum');

Line 626: t(30) := msc_apcc_measure_map_t(5, 'fcst_shipment', 'shipment_fcst', 't.fcst_shipment', 'sum');

622: t(26) := msc_apcc_measure_map_t(5, 'sales_fcst', 'sales_fcst', 't.sales_fcst', 'sum');
623: t(27) := msc_apcc_measure_map_t(5, 'sales_fcst', 'sales_fcst_value', 't.sales_fcst'||l_value, 'sum');
624: t(28) := msc_apcc_measure_map_t(5, 'sales_fcst', 'sales_fcst_value2', 't.sales_fcst'||l_value2, 'sum');
625: t(29) := msc_apcc_measure_map_t(5, 'sales_fcst', 'sales_fcst_cum', 'sum(t.sales_fcst)'||l_over, 'sum');
626: t(30) := msc_apcc_measure_map_t(5, 'fcst_shipment', 'shipment_fcst', 't.fcst_shipment', 'sum');
627: t(31) := msc_apcc_measure_map_t(5, 'fcst_shipment', 'shipment_fcst_value', 't.fcst_shipment'||l_value, 'sum');
628: t(32) := msc_apcc_measure_map_t(5, 'fcst_shipment', 'shipment_fcst_value2', 't.fcst_shipment'||l_value2, 'sum');
629: t(33) := msc_apcc_measure_map_t(5, 'fcst_shipment', 'shipment_fcst_cum', 'sum(t.fcst_shipment)'||l_over, 'sum');
630: t(33) := msc_apcc_measure_map_t(5, 'total_backlog', 'projected_backlog', l_projected_backlog, 'sum');

Line 627: t(31) := msc_apcc_measure_map_t(5, 'fcst_shipment', 'shipment_fcst_value', 't.fcst_shipment'||l_value, 'sum');

623: t(27) := msc_apcc_measure_map_t(5, 'sales_fcst', 'sales_fcst_value', 't.sales_fcst'||l_value, 'sum');
624: t(28) := msc_apcc_measure_map_t(5, 'sales_fcst', 'sales_fcst_value2', 't.sales_fcst'||l_value2, 'sum');
625: t(29) := msc_apcc_measure_map_t(5, 'sales_fcst', 'sales_fcst_cum', 'sum(t.sales_fcst)'||l_over, 'sum');
626: t(30) := msc_apcc_measure_map_t(5, 'fcst_shipment', 'shipment_fcst', 't.fcst_shipment', 'sum');
627: t(31) := msc_apcc_measure_map_t(5, 'fcst_shipment', 'shipment_fcst_value', 't.fcst_shipment'||l_value, 'sum');
628: t(32) := msc_apcc_measure_map_t(5, 'fcst_shipment', 'shipment_fcst_value2', 't.fcst_shipment'||l_value2, 'sum');
629: t(33) := msc_apcc_measure_map_t(5, 'fcst_shipment', 'shipment_fcst_cum', 'sum(t.fcst_shipment)'||l_over, 'sum');
630: t(33) := msc_apcc_measure_map_t(5, 'total_backlog', 'projected_backlog', l_projected_backlog, 'sum');
631: t(35) := msc_apcc_measure_map_t(5, 'fcst_booking', 'projected_backlog', l_projected_backlog, 'sum');

Line 628: t(32) := msc_apcc_measure_map_t(5, 'fcst_shipment', 'shipment_fcst_value2', 't.fcst_shipment'||l_value2, 'sum');

624: t(28) := msc_apcc_measure_map_t(5, 'sales_fcst', 'sales_fcst_value2', 't.sales_fcst'||l_value2, 'sum');
625: t(29) := msc_apcc_measure_map_t(5, 'sales_fcst', 'sales_fcst_cum', 'sum(t.sales_fcst)'||l_over, 'sum');
626: t(30) := msc_apcc_measure_map_t(5, 'fcst_shipment', 'shipment_fcst', 't.fcst_shipment', 'sum');
627: t(31) := msc_apcc_measure_map_t(5, 'fcst_shipment', 'shipment_fcst_value', 't.fcst_shipment'||l_value, 'sum');
628: t(32) := msc_apcc_measure_map_t(5, 'fcst_shipment', 'shipment_fcst_value2', 't.fcst_shipment'||l_value2, 'sum');
629: t(33) := msc_apcc_measure_map_t(5, 'fcst_shipment', 'shipment_fcst_cum', 'sum(t.fcst_shipment)'||l_over, 'sum');
630: t(33) := msc_apcc_measure_map_t(5, 'total_backlog', 'projected_backlog', l_projected_backlog, 'sum');
631: t(35) := msc_apcc_measure_map_t(5, 'fcst_booking', 'projected_backlog', l_projected_backlog, 'sum');
632: t(36) := msc_apcc_measure_map_t(5, 'fcst_shipment', 'projected_backlog', l_projected_backlog, 'sum');

Line 629: t(33) := msc_apcc_measure_map_t(5, 'fcst_shipment', 'shipment_fcst_cum', 'sum(t.fcst_shipment)'||l_over, 'sum');

625: t(29) := msc_apcc_measure_map_t(5, 'sales_fcst', 'sales_fcst_cum', 'sum(t.sales_fcst)'||l_over, 'sum');
626: t(30) := msc_apcc_measure_map_t(5, 'fcst_shipment', 'shipment_fcst', 't.fcst_shipment', 'sum');
627: t(31) := msc_apcc_measure_map_t(5, 'fcst_shipment', 'shipment_fcst_value', 't.fcst_shipment'||l_value, 'sum');
628: t(32) := msc_apcc_measure_map_t(5, 'fcst_shipment', 'shipment_fcst_value2', 't.fcst_shipment'||l_value2, 'sum');
629: t(33) := msc_apcc_measure_map_t(5, 'fcst_shipment', 'shipment_fcst_cum', 'sum(t.fcst_shipment)'||l_over, 'sum');
630: t(33) := msc_apcc_measure_map_t(5, 'total_backlog', 'projected_backlog', l_projected_backlog, 'sum');
631: t(35) := msc_apcc_measure_map_t(5, 'fcst_booking', 'projected_backlog', l_projected_backlog, 'sum');
632: t(36) := msc_apcc_measure_map_t(5, 'fcst_shipment', 'projected_backlog', l_projected_backlog, 'sum');
633:

Line 630: t(33) := msc_apcc_measure_map_t(5, 'total_backlog', 'projected_backlog', l_projected_backlog, 'sum');

626: t(30) := msc_apcc_measure_map_t(5, 'fcst_shipment', 'shipment_fcst', 't.fcst_shipment', 'sum');
627: t(31) := msc_apcc_measure_map_t(5, 'fcst_shipment', 'shipment_fcst_value', 't.fcst_shipment'||l_value, 'sum');
628: t(32) := msc_apcc_measure_map_t(5, 'fcst_shipment', 'shipment_fcst_value2', 't.fcst_shipment'||l_value2, 'sum');
629: t(33) := msc_apcc_measure_map_t(5, 'fcst_shipment', 'shipment_fcst_cum', 'sum(t.fcst_shipment)'||l_over, 'sum');
630: t(33) := msc_apcc_measure_map_t(5, 'total_backlog', 'projected_backlog', l_projected_backlog, 'sum');
631: t(35) := msc_apcc_measure_map_t(5, 'fcst_booking', 'projected_backlog', l_projected_backlog, 'sum');
632: t(36) := msc_apcc_measure_map_t(5, 'fcst_shipment', 'projected_backlog', l_projected_backlog, 'sum');
633:
634: t(37) := msc_apcc_measure_map_t(4, 'week4_abs_pct_err', 'consen_fcst_accrcy_mape_4week', 't.week4_abs_pct_err', 'avg');

Line 631: t(35) := msc_apcc_measure_map_t(5, 'fcst_booking', 'projected_backlog', l_projected_backlog, 'sum');

627: t(31) := msc_apcc_measure_map_t(5, 'fcst_shipment', 'shipment_fcst_value', 't.fcst_shipment'||l_value, 'sum');
628: t(32) := msc_apcc_measure_map_t(5, 'fcst_shipment', 'shipment_fcst_value2', 't.fcst_shipment'||l_value2, 'sum');
629: t(33) := msc_apcc_measure_map_t(5, 'fcst_shipment', 'shipment_fcst_cum', 'sum(t.fcst_shipment)'||l_over, 'sum');
630: t(33) := msc_apcc_measure_map_t(5, 'total_backlog', 'projected_backlog', l_projected_backlog, 'sum');
631: t(35) := msc_apcc_measure_map_t(5, 'fcst_booking', 'projected_backlog', l_projected_backlog, 'sum');
632: t(36) := msc_apcc_measure_map_t(5, 'fcst_shipment', 'projected_backlog', l_projected_backlog, 'sum');
633:
634: t(37) := msc_apcc_measure_map_t(4, 'week4_abs_pct_err', 'consen_fcst_accrcy_mape_4week', 't.week4_abs_pct_err', 'avg');
635: t(38) := msc_apcc_measure_map_t(4, 'week8_abs_pct_err', 'consen_fcst_accrcy_mape_8week', 't.week8_abs_pct_err', 'avg');

Line 632: t(36) := msc_apcc_measure_map_t(5, 'fcst_shipment', 'projected_backlog', l_projected_backlog, 'sum');

628: t(32) := msc_apcc_measure_map_t(5, 'fcst_shipment', 'shipment_fcst_value2', 't.fcst_shipment'||l_value2, 'sum');
629: t(33) := msc_apcc_measure_map_t(5, 'fcst_shipment', 'shipment_fcst_cum', 'sum(t.fcst_shipment)'||l_over, 'sum');
630: t(33) := msc_apcc_measure_map_t(5, 'total_backlog', 'projected_backlog', l_projected_backlog, 'sum');
631: t(35) := msc_apcc_measure_map_t(5, 'fcst_booking', 'projected_backlog', l_projected_backlog, 'sum');
632: t(36) := msc_apcc_measure_map_t(5, 'fcst_shipment', 'projected_backlog', l_projected_backlog, 'sum');
633:
634: t(37) := msc_apcc_measure_map_t(4, 'week4_abs_pct_err', 'consen_fcst_accrcy_mape_4week', 't.week4_abs_pct_err', 'avg');
635: t(38) := msc_apcc_measure_map_t(4, 'week8_abs_pct_err', 'consen_fcst_accrcy_mape_8week', 't.week8_abs_pct_err', 'avg');
636: t(39) := msc_apcc_measure_map_t(4, 'week13_abs_pct_err', 'consen_fcst_accrcy_mape_13week', 't.week13_abs_pct_err', 'avg');

Line 634: t(37) := msc_apcc_measure_map_t(4, 'week4_abs_pct_err', 'consen_fcst_accrcy_mape_4week', 't.week4_abs_pct_err', 'avg');

630: t(33) := msc_apcc_measure_map_t(5, 'total_backlog', 'projected_backlog', l_projected_backlog, 'sum');
631: t(35) := msc_apcc_measure_map_t(5, 'fcst_booking', 'projected_backlog', l_projected_backlog, 'sum');
632: t(36) := msc_apcc_measure_map_t(5, 'fcst_shipment', 'projected_backlog', l_projected_backlog, 'sum');
633:
634: t(37) := msc_apcc_measure_map_t(4, 'week4_abs_pct_err', 'consen_fcst_accrcy_mape_4week', 't.week4_abs_pct_err', 'avg');
635: t(38) := msc_apcc_measure_map_t(4, 'week8_abs_pct_err', 'consen_fcst_accrcy_mape_8week', 't.week8_abs_pct_err', 'avg');
636: t(39) := msc_apcc_measure_map_t(4, 'week13_abs_pct_err', 'consen_fcst_accrcy_mape_13week', 't.week13_abs_pct_err', 'avg');
637: t(40) := msc_apcc_measure_map_t(4, 'actual_prod', 'production_history', l_production_history, 'sum');
638: t(41) := msc_apcc_measure_map_t(4, 'ebs_bh_book_qty_bd', 'booking_history', l_booking_history, 'sum');

Line 635: t(38) := msc_apcc_measure_map_t(4, 'week8_abs_pct_err', 'consen_fcst_accrcy_mape_8week', 't.week8_abs_pct_err', 'avg');

631: t(35) := msc_apcc_measure_map_t(5, 'fcst_booking', 'projected_backlog', l_projected_backlog, 'sum');
632: t(36) := msc_apcc_measure_map_t(5, 'fcst_shipment', 'projected_backlog', l_projected_backlog, 'sum');
633:
634: t(37) := msc_apcc_measure_map_t(4, 'week4_abs_pct_err', 'consen_fcst_accrcy_mape_4week', 't.week4_abs_pct_err', 'avg');
635: t(38) := msc_apcc_measure_map_t(4, 'week8_abs_pct_err', 'consen_fcst_accrcy_mape_8week', 't.week8_abs_pct_err', 'avg');
636: t(39) := msc_apcc_measure_map_t(4, 'week13_abs_pct_err', 'consen_fcst_accrcy_mape_13week', 't.week13_abs_pct_err', 'avg');
637: t(40) := msc_apcc_measure_map_t(4, 'actual_prod', 'production_history', l_production_history, 'sum');
638: t(41) := msc_apcc_measure_map_t(4, 'ebs_bh_book_qty_bd', 'booking_history', l_booking_history, 'sum');
639: t(42) := msc_apcc_measure_map_t(4, 'ebs_bh_book_qty_bd', 'booking_history_value', l_booking_history||l_value, 'sum');

Line 636: t(39) := msc_apcc_measure_map_t(4, 'week13_abs_pct_err', 'consen_fcst_accrcy_mape_13week', 't.week13_abs_pct_err', 'avg');

632: t(36) := msc_apcc_measure_map_t(5, 'fcst_shipment', 'projected_backlog', l_projected_backlog, 'sum');
633:
634: t(37) := msc_apcc_measure_map_t(4, 'week4_abs_pct_err', 'consen_fcst_accrcy_mape_4week', 't.week4_abs_pct_err', 'avg');
635: t(38) := msc_apcc_measure_map_t(4, 'week8_abs_pct_err', 'consen_fcst_accrcy_mape_8week', 't.week8_abs_pct_err', 'avg');
636: t(39) := msc_apcc_measure_map_t(4, 'week13_abs_pct_err', 'consen_fcst_accrcy_mape_13week', 't.week13_abs_pct_err', 'avg');
637: t(40) := msc_apcc_measure_map_t(4, 'actual_prod', 'production_history', l_production_history, 'sum');
638: t(41) := msc_apcc_measure_map_t(4, 'ebs_bh_book_qty_bd', 'booking_history', l_booking_history, 'sum');
639: t(42) := msc_apcc_measure_map_t(4, 'ebs_bh_book_qty_bd', 'booking_history_value', l_booking_history||l_value, 'sum');
640: t(43) := msc_apcc_measure_map_t(4, 'ebs_bh_book_qty_bd', 'booking_history_value2', l_booking_history||l_value2, 'sum');

Line 637: t(40) := msc_apcc_measure_map_t(4, 'actual_prod', 'production_history', l_production_history, 'sum');

633:
634: t(37) := msc_apcc_measure_map_t(4, 'week4_abs_pct_err', 'consen_fcst_accrcy_mape_4week', 't.week4_abs_pct_err', 'avg');
635: t(38) := msc_apcc_measure_map_t(4, 'week8_abs_pct_err', 'consen_fcst_accrcy_mape_8week', 't.week8_abs_pct_err', 'avg');
636: t(39) := msc_apcc_measure_map_t(4, 'week13_abs_pct_err', 'consen_fcst_accrcy_mape_13week', 't.week13_abs_pct_err', 'avg');
637: t(40) := msc_apcc_measure_map_t(4, 'actual_prod', 'production_history', l_production_history, 'sum');
638: t(41) := msc_apcc_measure_map_t(4, 'ebs_bh_book_qty_bd', 'booking_history', l_booking_history, 'sum');
639: t(42) := msc_apcc_measure_map_t(4, 'ebs_bh_book_qty_bd', 'booking_history_value', l_booking_history||l_value, 'sum');
640: t(43) := msc_apcc_measure_map_t(4, 'ebs_bh_book_qty_bd', 'booking_history_value2', l_booking_history||l_value2, 'sum');
641: t(44) := msc_apcc_measure_map_t(4, 'ebs_sh_ship_qty_sd', 'shipment_history', l_shipment_history, 'sum');

Line 638: t(41) := msc_apcc_measure_map_t(4, 'ebs_bh_book_qty_bd', 'booking_history', l_booking_history, 'sum');

634: t(37) := msc_apcc_measure_map_t(4, 'week4_abs_pct_err', 'consen_fcst_accrcy_mape_4week', 't.week4_abs_pct_err', 'avg');
635: t(38) := msc_apcc_measure_map_t(4, 'week8_abs_pct_err', 'consen_fcst_accrcy_mape_8week', 't.week8_abs_pct_err', 'avg');
636: t(39) := msc_apcc_measure_map_t(4, 'week13_abs_pct_err', 'consen_fcst_accrcy_mape_13week', 't.week13_abs_pct_err', 'avg');
637: t(40) := msc_apcc_measure_map_t(4, 'actual_prod', 'production_history', l_production_history, 'sum');
638: t(41) := msc_apcc_measure_map_t(4, 'ebs_bh_book_qty_bd', 'booking_history', l_booking_history, 'sum');
639: t(42) := msc_apcc_measure_map_t(4, 'ebs_bh_book_qty_bd', 'booking_history_value', l_booking_history||l_value, 'sum');
640: t(43) := msc_apcc_measure_map_t(4, 'ebs_bh_book_qty_bd', 'booking_history_value2', l_booking_history||l_value2, 'sum');
641: t(44) := msc_apcc_measure_map_t(4, 'ebs_sh_ship_qty_sd', 'shipment_history', l_shipment_history, 'sum');
642: t(45) := msc_apcc_measure_map_t(4, 'ebs_sh_ship_qty_sd', 'shipment_history_value', l_shipment_history||l_value, 'sum');

Line 639: t(42) := msc_apcc_measure_map_t(4, 'ebs_bh_book_qty_bd', 'booking_history_value', l_booking_history||l_value, 'sum');

635: t(38) := msc_apcc_measure_map_t(4, 'week8_abs_pct_err', 'consen_fcst_accrcy_mape_8week', 't.week8_abs_pct_err', 'avg');
636: t(39) := msc_apcc_measure_map_t(4, 'week13_abs_pct_err', 'consen_fcst_accrcy_mape_13week', 't.week13_abs_pct_err', 'avg');
637: t(40) := msc_apcc_measure_map_t(4, 'actual_prod', 'production_history', l_production_history, 'sum');
638: t(41) := msc_apcc_measure_map_t(4, 'ebs_bh_book_qty_bd', 'booking_history', l_booking_history, 'sum');
639: t(42) := msc_apcc_measure_map_t(4, 'ebs_bh_book_qty_bd', 'booking_history_value', l_booking_history||l_value, 'sum');
640: t(43) := msc_apcc_measure_map_t(4, 'ebs_bh_book_qty_bd', 'booking_history_value2', l_booking_history||l_value2, 'sum');
641: t(44) := msc_apcc_measure_map_t(4, 'ebs_sh_ship_qty_sd', 'shipment_history', l_shipment_history, 'sum');
642: t(45) := msc_apcc_measure_map_t(4, 'ebs_sh_ship_qty_sd', 'shipment_history_value', l_shipment_history||l_value, 'sum');
643: t(46) := msc_apcc_measure_map_t(4, 'ebs_sh_ship_qty_sd', 'shipment_history_value2', l_shipment_history||l_value2, 'sum');

Line 640: t(43) := msc_apcc_measure_map_t(4, 'ebs_bh_book_qty_bd', 'booking_history_value2', l_booking_history||l_value2, 'sum');

636: t(39) := msc_apcc_measure_map_t(4, 'week13_abs_pct_err', 'consen_fcst_accrcy_mape_13week', 't.week13_abs_pct_err', 'avg');
637: t(40) := msc_apcc_measure_map_t(4, 'actual_prod', 'production_history', l_production_history, 'sum');
638: t(41) := msc_apcc_measure_map_t(4, 'ebs_bh_book_qty_bd', 'booking_history', l_booking_history, 'sum');
639: t(42) := msc_apcc_measure_map_t(4, 'ebs_bh_book_qty_bd', 'booking_history_value', l_booking_history||l_value, 'sum');
640: t(43) := msc_apcc_measure_map_t(4, 'ebs_bh_book_qty_bd', 'booking_history_value2', l_booking_history||l_value2, 'sum');
641: t(44) := msc_apcc_measure_map_t(4, 'ebs_sh_ship_qty_sd', 'shipment_history', l_shipment_history, 'sum');
642: t(45) := msc_apcc_measure_map_t(4, 'ebs_sh_ship_qty_sd', 'shipment_history_value', l_shipment_history||l_value, 'sum');
643: t(46) := msc_apcc_measure_map_t(4, 'ebs_sh_ship_qty_sd', 'shipment_history_value2', l_shipment_history||l_value2, 'sum');
644: t(47) := msc_apcc_measure_map_t(4, 'total_backlog', 'actual_backlog', 't.total_backlog', 'sum');

Line 641: t(44) := msc_apcc_measure_map_t(4, 'ebs_sh_ship_qty_sd', 'shipment_history', l_shipment_history, 'sum');

637: t(40) := msc_apcc_measure_map_t(4, 'actual_prod', 'production_history', l_production_history, 'sum');
638: t(41) := msc_apcc_measure_map_t(4, 'ebs_bh_book_qty_bd', 'booking_history', l_booking_history, 'sum');
639: t(42) := msc_apcc_measure_map_t(4, 'ebs_bh_book_qty_bd', 'booking_history_value', l_booking_history||l_value, 'sum');
640: t(43) := msc_apcc_measure_map_t(4, 'ebs_bh_book_qty_bd', 'booking_history_value2', l_booking_history||l_value2, 'sum');
641: t(44) := msc_apcc_measure_map_t(4, 'ebs_sh_ship_qty_sd', 'shipment_history', l_shipment_history, 'sum');
642: t(45) := msc_apcc_measure_map_t(4, 'ebs_sh_ship_qty_sd', 'shipment_history_value', l_shipment_history||l_value, 'sum');
643: t(46) := msc_apcc_measure_map_t(4, 'ebs_sh_ship_qty_sd', 'shipment_history_value2', l_shipment_history||l_value2, 'sum');
644: t(47) := msc_apcc_measure_map_t(4, 'total_backlog', 'actual_backlog', 't.total_backlog', 'sum');
645: t(48) := msc_apcc_measure_map_t(4, 'total_backlog', 'actual_backlog_value', 't.total_backlog'||l_value, 'sum');

Line 642: t(45) := msc_apcc_measure_map_t(4, 'ebs_sh_ship_qty_sd', 'shipment_history_value', l_shipment_history||l_value, 'sum');

638: t(41) := msc_apcc_measure_map_t(4, 'ebs_bh_book_qty_bd', 'booking_history', l_booking_history, 'sum');
639: t(42) := msc_apcc_measure_map_t(4, 'ebs_bh_book_qty_bd', 'booking_history_value', l_booking_history||l_value, 'sum');
640: t(43) := msc_apcc_measure_map_t(4, 'ebs_bh_book_qty_bd', 'booking_history_value2', l_booking_history||l_value2, 'sum');
641: t(44) := msc_apcc_measure_map_t(4, 'ebs_sh_ship_qty_sd', 'shipment_history', l_shipment_history, 'sum');
642: t(45) := msc_apcc_measure_map_t(4, 'ebs_sh_ship_qty_sd', 'shipment_history_value', l_shipment_history||l_value, 'sum');
643: t(46) := msc_apcc_measure_map_t(4, 'ebs_sh_ship_qty_sd', 'shipment_history_value2', l_shipment_history||l_value2, 'sum');
644: t(47) := msc_apcc_measure_map_t(4, 'total_backlog', 'actual_backlog', 't.total_backlog', 'sum');
645: t(48) := msc_apcc_measure_map_t(4, 'total_backlog', 'actual_backlog_value', 't.total_backlog'||l_value, 'sum');
646: t(49) := msc_apcc_measure_map_t(4, 'total_backlog', 'actual_backlog_value2', 't.total_backlog'||l_value2, 'sum');

Line 643: t(46) := msc_apcc_measure_map_t(4, 'ebs_sh_ship_qty_sd', 'shipment_history_value2', l_shipment_history||l_value2, 'sum');

639: t(42) := msc_apcc_measure_map_t(4, 'ebs_bh_book_qty_bd', 'booking_history_value', l_booking_history||l_value, 'sum');
640: t(43) := msc_apcc_measure_map_t(4, 'ebs_bh_book_qty_bd', 'booking_history_value2', l_booking_history||l_value2, 'sum');
641: t(44) := msc_apcc_measure_map_t(4, 'ebs_sh_ship_qty_sd', 'shipment_history', l_shipment_history, 'sum');
642: t(45) := msc_apcc_measure_map_t(4, 'ebs_sh_ship_qty_sd', 'shipment_history_value', l_shipment_history||l_value, 'sum');
643: t(46) := msc_apcc_measure_map_t(4, 'ebs_sh_ship_qty_sd', 'shipment_history_value2', l_shipment_history||l_value2, 'sum');
644: t(47) := msc_apcc_measure_map_t(4, 'total_backlog', 'actual_backlog', 't.total_backlog', 'sum');
645: t(48) := msc_apcc_measure_map_t(4, 'total_backlog', 'actual_backlog_value', 't.total_backlog'||l_value, 'sum');
646: t(49) := msc_apcc_measure_map_t(4, 'total_backlog', 'actual_backlog_value2', 't.total_backlog'||l_value2, 'sum');
647: t(50) := msc_apcc_measure_map_t(4, 'actual_on_hand', 'inventory_history', l_inventory_history, 'sum');

Line 644: t(47) := msc_apcc_measure_map_t(4, 'total_backlog', 'actual_backlog', 't.total_backlog', 'sum');

640: t(43) := msc_apcc_measure_map_t(4, 'ebs_bh_book_qty_bd', 'booking_history_value2', l_booking_history||l_value2, 'sum');
641: t(44) := msc_apcc_measure_map_t(4, 'ebs_sh_ship_qty_sd', 'shipment_history', l_shipment_history, 'sum');
642: t(45) := msc_apcc_measure_map_t(4, 'ebs_sh_ship_qty_sd', 'shipment_history_value', l_shipment_history||l_value, 'sum');
643: t(46) := msc_apcc_measure_map_t(4, 'ebs_sh_ship_qty_sd', 'shipment_history_value2', l_shipment_history||l_value2, 'sum');
644: t(47) := msc_apcc_measure_map_t(4, 'total_backlog', 'actual_backlog', 't.total_backlog', 'sum');
645: t(48) := msc_apcc_measure_map_t(4, 'total_backlog', 'actual_backlog_value', 't.total_backlog'||l_value, 'sum');
646: t(49) := msc_apcc_measure_map_t(4, 'total_backlog', 'actual_backlog_value2', 't.total_backlog'||l_value2, 'sum');
647: t(50) := msc_apcc_measure_map_t(4, 'actual_on_hand', 'inventory_history', l_inventory_history, 'sum');
648: t(51) := msc_apcc_measure_map_t(4, 'actual_on_hand', 'inventory_history_value', l_inventory_history||l_value, 'sum');

Line 645: t(48) := msc_apcc_measure_map_t(4, 'total_backlog', 'actual_backlog_value', 't.total_backlog'||l_value, 'sum');

641: t(44) := msc_apcc_measure_map_t(4, 'ebs_sh_ship_qty_sd', 'shipment_history', l_shipment_history, 'sum');
642: t(45) := msc_apcc_measure_map_t(4, 'ebs_sh_ship_qty_sd', 'shipment_history_value', l_shipment_history||l_value, 'sum');
643: t(46) := msc_apcc_measure_map_t(4, 'ebs_sh_ship_qty_sd', 'shipment_history_value2', l_shipment_history||l_value2, 'sum');
644: t(47) := msc_apcc_measure_map_t(4, 'total_backlog', 'actual_backlog', 't.total_backlog', 'sum');
645: t(48) := msc_apcc_measure_map_t(4, 'total_backlog', 'actual_backlog_value', 't.total_backlog'||l_value, 'sum');
646: t(49) := msc_apcc_measure_map_t(4, 'total_backlog', 'actual_backlog_value2', 't.total_backlog'||l_value2, 'sum');
647: t(50) := msc_apcc_measure_map_t(4, 'actual_on_hand', 'inventory_history', l_inventory_history, 'sum');
648: t(51) := msc_apcc_measure_map_t(4, 'actual_on_hand', 'inventory_history_value', l_inventory_history||l_value, 'sum');
649: t(52) := msc_apcc_measure_map_t(4, 'actual_on_hand', 'inventory_history_value2', l_inventory_history||l_value2, 'sum');

Line 646: t(49) := msc_apcc_measure_map_t(4, 'total_backlog', 'actual_backlog_value2', 't.total_backlog'||l_value2, 'sum');

642: t(45) := msc_apcc_measure_map_t(4, 'ebs_sh_ship_qty_sd', 'shipment_history_value', l_shipment_history||l_value, 'sum');
643: t(46) := msc_apcc_measure_map_t(4, 'ebs_sh_ship_qty_sd', 'shipment_history_value2', l_shipment_history||l_value2, 'sum');
644: t(47) := msc_apcc_measure_map_t(4, 'total_backlog', 'actual_backlog', 't.total_backlog', 'sum');
645: t(48) := msc_apcc_measure_map_t(4, 'total_backlog', 'actual_backlog_value', 't.total_backlog'||l_value, 'sum');
646: t(49) := msc_apcc_measure_map_t(4, 'total_backlog', 'actual_backlog_value2', 't.total_backlog'||l_value2, 'sum');
647: t(50) := msc_apcc_measure_map_t(4, 'actual_on_hand', 'inventory_history', l_inventory_history, 'sum');
648: t(51) := msc_apcc_measure_map_t(4, 'actual_on_hand', 'inventory_history_value', l_inventory_history||l_value, 'sum');
649: t(52) := msc_apcc_measure_map_t(4, 'actual_on_hand', 'inventory_history_value2', l_inventory_history||l_value2, 'sum');
650: t(53) := msc_apcc_measure_map_t(4, 'ebs_bh_book_qty_rd', 'booking_history_rd', 't.ebs_bh_book_qty_rd', 'sum');

Line 647: t(50) := msc_apcc_measure_map_t(4, 'actual_on_hand', 'inventory_history', l_inventory_history, 'sum');

643: t(46) := msc_apcc_measure_map_t(4, 'ebs_sh_ship_qty_sd', 'shipment_history_value2', l_shipment_history||l_value2, 'sum');
644: t(47) := msc_apcc_measure_map_t(4, 'total_backlog', 'actual_backlog', 't.total_backlog', 'sum');
645: t(48) := msc_apcc_measure_map_t(4, 'total_backlog', 'actual_backlog_value', 't.total_backlog'||l_value, 'sum');
646: t(49) := msc_apcc_measure_map_t(4, 'total_backlog', 'actual_backlog_value2', 't.total_backlog'||l_value2, 'sum');
647: t(50) := msc_apcc_measure_map_t(4, 'actual_on_hand', 'inventory_history', l_inventory_history, 'sum');
648: t(51) := msc_apcc_measure_map_t(4, 'actual_on_hand', 'inventory_history_value', l_inventory_history||l_value, 'sum');
649: t(52) := msc_apcc_measure_map_t(4, 'actual_on_hand', 'inventory_history_value2', l_inventory_history||l_value2, 'sum');
650: t(53) := msc_apcc_measure_map_t(4, 'ebs_bh_book_qty_rd', 'booking_history_rd', 't.ebs_bh_book_qty_rd', 'sum');
651: t(54) := msc_apcc_measure_map_t(4, 'ebs_bh_book_qty_rd', 'booking_history_rd_value', 't.ebs_bh_book_qty_rd'||l_value, 'sum');

Line 648: t(51) := msc_apcc_measure_map_t(4, 'actual_on_hand', 'inventory_history_value', l_inventory_history||l_value, 'sum');

644: t(47) := msc_apcc_measure_map_t(4, 'total_backlog', 'actual_backlog', 't.total_backlog', 'sum');
645: t(48) := msc_apcc_measure_map_t(4, 'total_backlog', 'actual_backlog_value', 't.total_backlog'||l_value, 'sum');
646: t(49) := msc_apcc_measure_map_t(4, 'total_backlog', 'actual_backlog_value2', 't.total_backlog'||l_value2, 'sum');
647: t(50) := msc_apcc_measure_map_t(4, 'actual_on_hand', 'inventory_history', l_inventory_history, 'sum');
648: t(51) := msc_apcc_measure_map_t(4, 'actual_on_hand', 'inventory_history_value', l_inventory_history||l_value, 'sum');
649: t(52) := msc_apcc_measure_map_t(4, 'actual_on_hand', 'inventory_history_value2', l_inventory_history||l_value2, 'sum');
650: t(53) := msc_apcc_measure_map_t(4, 'ebs_bh_book_qty_rd', 'booking_history_rd', 't.ebs_bh_book_qty_rd', 'sum');
651: t(54) := msc_apcc_measure_map_t(4, 'ebs_bh_book_qty_rd', 'booking_history_rd_value', 't.ebs_bh_book_qty_rd'||l_value, 'sum');
652: t(55) := msc_apcc_measure_map_t(4, 'ebs_bh_book_qty_rd', 'booking_history_rd_value2', 't.ebs_bh_book_qty_rd'||l_value2, 'sum');

Line 649: t(52) := msc_apcc_measure_map_t(4, 'actual_on_hand', 'inventory_history_value2', l_inventory_history||l_value2, 'sum');

645: t(48) := msc_apcc_measure_map_t(4, 'total_backlog', 'actual_backlog_value', 't.total_backlog'||l_value, 'sum');
646: t(49) := msc_apcc_measure_map_t(4, 'total_backlog', 'actual_backlog_value2', 't.total_backlog'||l_value2, 'sum');
647: t(50) := msc_apcc_measure_map_t(4, 'actual_on_hand', 'inventory_history', l_inventory_history, 'sum');
648: t(51) := msc_apcc_measure_map_t(4, 'actual_on_hand', 'inventory_history_value', l_inventory_history||l_value, 'sum');
649: t(52) := msc_apcc_measure_map_t(4, 'actual_on_hand', 'inventory_history_value2', l_inventory_history||l_value2, 'sum');
650: t(53) := msc_apcc_measure_map_t(4, 'ebs_bh_book_qty_rd', 'booking_history_rd', 't.ebs_bh_book_qty_rd', 'sum');
651: t(54) := msc_apcc_measure_map_t(4, 'ebs_bh_book_qty_rd', 'booking_history_rd_value', 't.ebs_bh_book_qty_rd'||l_value, 'sum');
652: t(55) := msc_apcc_measure_map_t(4, 'ebs_bh_book_qty_rd', 'booking_history_rd_value2', 't.ebs_bh_book_qty_rd'||l_value2, 'sum');
653: t(56) := msc_apcc_measure_map_t(4, 'ebs_return_history', 'returns_history', l_returns_history, 'sum');

Line 650: t(53) := msc_apcc_measure_map_t(4, 'ebs_bh_book_qty_rd', 'booking_history_rd', 't.ebs_bh_book_qty_rd', 'sum');

646: t(49) := msc_apcc_measure_map_t(4, 'total_backlog', 'actual_backlog_value2', 't.total_backlog'||l_value2, 'sum');
647: t(50) := msc_apcc_measure_map_t(4, 'actual_on_hand', 'inventory_history', l_inventory_history, 'sum');
648: t(51) := msc_apcc_measure_map_t(4, 'actual_on_hand', 'inventory_history_value', l_inventory_history||l_value, 'sum');
649: t(52) := msc_apcc_measure_map_t(4, 'actual_on_hand', 'inventory_history_value2', l_inventory_history||l_value2, 'sum');
650: t(53) := msc_apcc_measure_map_t(4, 'ebs_bh_book_qty_rd', 'booking_history_rd', 't.ebs_bh_book_qty_rd', 'sum');
651: t(54) := msc_apcc_measure_map_t(4, 'ebs_bh_book_qty_rd', 'booking_history_rd_value', 't.ebs_bh_book_qty_rd'||l_value, 'sum');
652: t(55) := msc_apcc_measure_map_t(4, 'ebs_bh_book_qty_rd', 'booking_history_rd_value2', 't.ebs_bh_book_qty_rd'||l_value2, 'sum');
653: t(56) := msc_apcc_measure_map_t(4, 'ebs_return_history', 'returns_history', l_returns_history, 'sum');
654: return t;

Line 651: t(54) := msc_apcc_measure_map_t(4, 'ebs_bh_book_qty_rd', 'booking_history_rd_value', 't.ebs_bh_book_qty_rd'||l_value, 'sum');

647: t(50) := msc_apcc_measure_map_t(4, 'actual_on_hand', 'inventory_history', l_inventory_history, 'sum');
648: t(51) := msc_apcc_measure_map_t(4, 'actual_on_hand', 'inventory_history_value', l_inventory_history||l_value, 'sum');
649: t(52) := msc_apcc_measure_map_t(4, 'actual_on_hand', 'inventory_history_value2', l_inventory_history||l_value2, 'sum');
650: t(53) := msc_apcc_measure_map_t(4, 'ebs_bh_book_qty_rd', 'booking_history_rd', 't.ebs_bh_book_qty_rd', 'sum');
651: t(54) := msc_apcc_measure_map_t(4, 'ebs_bh_book_qty_rd', 'booking_history_rd_value', 't.ebs_bh_book_qty_rd'||l_value, 'sum');
652: t(55) := msc_apcc_measure_map_t(4, 'ebs_bh_book_qty_rd', 'booking_history_rd_value2', 't.ebs_bh_book_qty_rd'||l_value2, 'sum');
653: t(56) := msc_apcc_measure_map_t(4, 'ebs_return_history', 'returns_history', l_returns_history, 'sum');
654: return t;
655: end seeded_measure_mapping;

Line 652: t(55) := msc_apcc_measure_map_t(4, 'ebs_bh_book_qty_rd', 'booking_history_rd_value2', 't.ebs_bh_book_qty_rd'||l_value2, 'sum');

648: t(51) := msc_apcc_measure_map_t(4, 'actual_on_hand', 'inventory_history_value', l_inventory_history||l_value, 'sum');
649: t(52) := msc_apcc_measure_map_t(4, 'actual_on_hand', 'inventory_history_value2', l_inventory_history||l_value2, 'sum');
650: t(53) := msc_apcc_measure_map_t(4, 'ebs_bh_book_qty_rd', 'booking_history_rd', 't.ebs_bh_book_qty_rd', 'sum');
651: t(54) := msc_apcc_measure_map_t(4, 'ebs_bh_book_qty_rd', 'booking_history_rd_value', 't.ebs_bh_book_qty_rd'||l_value, 'sum');
652: t(55) := msc_apcc_measure_map_t(4, 'ebs_bh_book_qty_rd', 'booking_history_rd_value2', 't.ebs_bh_book_qty_rd'||l_value2, 'sum');
653: t(56) := msc_apcc_measure_map_t(4, 'ebs_return_history', 'returns_history', l_returns_history, 'sum');
654: return t;
655: end seeded_measure_mapping;
656:

Line 653: t(56) := msc_apcc_measure_map_t(4, 'ebs_return_history', 'returns_history', l_returns_history, 'sum');

649: t(52) := msc_apcc_measure_map_t(4, 'actual_on_hand', 'inventory_history_value2', l_inventory_history||l_value2, 'sum');
650: t(53) := msc_apcc_measure_map_t(4, 'ebs_bh_book_qty_rd', 'booking_history_rd', 't.ebs_bh_book_qty_rd', 'sum');
651: t(54) := msc_apcc_measure_map_t(4, 'ebs_bh_book_qty_rd', 'booking_history_rd_value', 't.ebs_bh_book_qty_rd'||l_value, 'sum');
652: t(55) := msc_apcc_measure_map_t(4, 'ebs_bh_book_qty_rd', 'booking_history_rd_value2', 't.ebs_bh_book_qty_rd'||l_value2, 'sum');
653: t(56) := msc_apcc_measure_map_t(4, 'ebs_return_history', 'returns_history', l_returns_history, 'sum');
654: return t;
655: end seeded_measure_mapping;
656:
657: function list_measures(p_list_type number, p_prefix varchar2, p_fact_type number, p_publisher varchar2)