DBA Data[Home] [Help]

APPS.MSC_DEMANTRA_PKG dependencies on FND_GLOBAL

Line 86: fnd_global.user_id, sysdate,

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 (

Line 87: sysdate, fnd_global.user_id, fnd_global.login_id,

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

Line 88: fnd_global.conc_program_id, fnd_global.conc_login_id,

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,

Line 89: fnd_global.prog_appl_id, fnd_global.conc_request_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,

Line 212: fnd_global.user_id, sysdate,

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

Line 213: sysdate, fnd_global.user_id, fnd_global.login_id,

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,

Line 214: fnd_global.conc_program_id, fnd_global.conc_login_id,

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

Line 215: fnd_global.prog_appl_id, fnd_global.conc_request_id

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