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 FND_PROFILE

Line 280: sum(demand_tbl.constrained_fcst_value * decode(demand_tbl.currency_code, fnd_profile.value('MSC_HUB_CUR_CODE_RPT'), 1, nvl(mcc.conv_rate,0))) constrained_fcst_value2,

276: sum(demand_tbl.qty_by_due_date),
277: sum(demand_tbl.net_demand),
278: sum(demand_tbl.constrained_fcst),
279: sum(demand_tbl.constrained_fcst_value),
280: sum(demand_tbl.constrained_fcst_value * decode(demand_tbl.currency_code, fnd_profile.value('MSC_HUB_CUR_CODE_RPT'), 1, nvl(mcc.conv_rate,0))) constrained_fcst_value2,
281: sum(demand_tbl.indep_demand_count),
282: sum(demand_tbl.indep_met_ontime_count),
283: sum(demand_tbl.indep_met_full_count),
284: sum(demand_tbl.indep_demand_value),

Line 285: sum(demand_tbl.indep_demand_value * decode(demand_tbl.currency_code,fnd_profile.value('MSC_HUB_CUR_CODE_RPT'),1,

281: sum(demand_tbl.indep_demand_count),
282: sum(demand_tbl.indep_met_ontime_count),
283: sum(demand_tbl.indep_met_full_count),
284: sum(demand_tbl.indep_demand_value),
285: sum(demand_tbl.indep_demand_value * decode(demand_tbl.currency_code,fnd_profile.value('MSC_HUB_CUR_CODE_RPT'),1,
286: nvl(mcc.CONV_RATE,0))), -- rate converation
287: sum(demand_tbl.indep_demand_qty),
288: sum(demand_tbl.indep_by_due_date_qty),
289: sum(demand_tbl.sales_order_qty),

Line 299: sum(demand_tbl.late_order_value * decode(demand_tbl.currency_code,fnd_profile.value('MSC_HUB_CUR_CODE_RPT'),1,

295: sum(demand_tbl.io_delivered_qty),
296: sum(demand_tbl.late_dmd_stf_factor),
297: sum(demand_tbl.late_order_count),
298: sum(demand_tbl.late_order_value),
299: sum(demand_tbl.late_order_value * decode(demand_tbl.currency_code,fnd_profile.value('MSC_HUB_CUR_CODE_RPT'),1,
300: nvl(mcc.CONV_RATE,0))), --- rate
301: min(demand_tbl.service_level)
302:
303: from(

Line 921: and mcc.TO_CURRENCY(+) = fnd_profile.value('MSC_HUB_CUR_CODE_RPT')

917: order by 1,2,3,4,5,6,7,8,9,10,11,12,13) demand_tbl,msc_plans mp_tbl,
918: MSC_CURRENCY_CONV_MV mcc,msc_phub_customers_mv cmv
919: where
920: mcc.FROM_CURRENCY(+) =demand_tbl.currency_code -- make sure 'XXX' is not a valid currency code
921: and mcc.TO_CURRENCY(+) = fnd_profile.value('MSC_HUB_CUR_CODE_RPT')
922: and mcc.CALENDAR_DATE (+)= demand_tbl.order_date
923: and mp_tbl.plan_id = p_plan_id
924: and cmv.customer_id = nvl(demand_tbl.customer_id,-23453)
925: and cmv.customer_site_id = nvl(demand_tbl.customer_site_id,-23453)

Line 1399: l_category_set_id1 number := fnd_profile.value('MSC_HUB_CAT_SET_ID_1');

1395:
1396: procedure populate_summary(errbuf out nocopy varchar2, retcode out nocopy varchar2,
1397: p_plan_id number, p_plan_run_id number)
1398: is
1399: l_category_set_id1 number := fnd_profile.value('MSC_HUB_CAT_SET_ID_1');
1400: begin
1401: -- level 1
1402: insert into msc_demands_f (
1403: plan_id, plan_run_id,