82: fnd_profile.value('MSC_HUB_CUR_CODE_RPT'), 1, nvl(mcc.conv_rate,0))
83: consensus_fcst_value2,
84: t.consensus_fcst_cum,
85: t.priority,
86: fnd_global.user_id, sysdate,
87: sysdate, fnd_global.user_id, fnd_global.login_id,
88: fnd_global.conc_program_id, fnd_global.conc_login_id,
89: fnd_global.prog_appl_id, fnd_global.conc_request_id
90: from (
83: consensus_fcst_value2,
84: t.consensus_fcst_cum,
85: t.priority,
86: fnd_global.user_id, sysdate,
87: sysdate, fnd_global.user_id, fnd_global.login_id,
88: fnd_global.conc_program_id, fnd_global.conc_login_id,
89: fnd_global.prog_appl_id, fnd_global.conc_request_id
90: from (
91: select
84: t.consensus_fcst_cum,
85: t.priority,
86: fnd_global.user_id, sysdate,
87: sysdate, fnd_global.user_id, fnd_global.login_id,
88: fnd_global.conc_program_id, fnd_global.conc_login_id,
89: fnd_global.prog_appl_id, fnd_global.conc_request_id
90: from (
91: select
92: k.scenario_id,
85: t.priority,
86: fnd_global.user_id, sysdate,
87: sysdate, fnd_global.user_id, fnd_global.login_id,
88: fnd_global.conc_program_id, fnd_global.conc_login_id,
89: fnd_global.prog_appl_id, fnd_global.conc_request_id
90: from (
91: select
92: k.scenario_id,
93: k.sr_instance_id,
208: sum(f.consensus_fcst_value),
209: sum(f.consensus_fcst_value2),
210: sum(f.consensus_fcst_cum),
211: avg(f.priority),
212: fnd_global.user_id, sysdate,
213: sysdate, fnd_global.user_id, fnd_global.login_id,
214: fnd_global.conc_program_id, fnd_global.conc_login_id,
215: fnd_global.prog_appl_id, fnd_global.conc_request_id
216: from
209: sum(f.consensus_fcst_value2),
210: sum(f.consensus_fcst_cum),
211: avg(f.priority),
212: fnd_global.user_id, sysdate,
213: sysdate, fnd_global.user_id, fnd_global.login_id,
214: fnd_global.conc_program_id, fnd_global.conc_login_id,
215: fnd_global.prog_appl_id, fnd_global.conc_request_id
216: from
217: msc_demantra_f f,
210: sum(f.consensus_fcst_cum),
211: avg(f.priority),
212: fnd_global.user_id, sysdate,
213: sysdate, fnd_global.user_id, fnd_global.login_id,
214: fnd_global.conc_program_id, fnd_global.conc_login_id,
215: fnd_global.prog_appl_id, fnd_global.conc_request_id
216: from
217: msc_demantra_f f,
218: msc_phub_item_categories_mv q
211: avg(f.priority),
212: fnd_global.user_id, sysdate,
213: sysdate, fnd_global.user_id, fnd_global.login_id,
214: fnd_global.conc_program_id, fnd_global.conc_login_id,
215: fnd_global.prog_appl_id, fnd_global.conc_request_id
216: from
217: msc_demantra_f f,
218: msc_phub_item_categories_mv q
219: where f.plan_id = p_plan_id and f.plan_run_id = p_plan_run_id