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

Line 22: l_enable_num number := nvl(fnd_profile.value('MSC_APCC_ENABLE_CUM'), 1);

18: l_rowcount2 number := 0;
19: l_transfer_id number := null;
20: l_start_time timestamp := systimestamp;
21: l_ddl varchar2(500);
22: l_enable_num number := nvl(fnd_profile.value('MSC_APCC_ENABLE_CUM'), 1);
23: begin
24: msc_phub_util.log('msc_demand_pkg.populate_details');
25:
26: retcode := 0; -- this means successfully

Line 1326: f.qty_by_due_date_value * decode(f.currency_code, fnd_profile.value('MSC_HUB_CUR_CODE_RPT'), 1, nvl(mcc.conv_rate, 0)) qty_by_due_date_value2,

1322:
1323: f.demand_qty,
1324: f.qty_by_due_date,
1325: f.qty_by_due_date_value,
1326: f.qty_by_due_date_value * decode(f.currency_code, fnd_profile.value('MSC_HUB_CUR_CODE_RPT'), 1, nvl(mcc.conv_rate, 0)) qty_by_due_date_value2,
1327: f.indep_demand_count,
1328: f.indep_met_ontime_count,
1329: f.indep_met_full_count,
1330: f.indep_demand_qty,

Line 1332: f.indep_demand_value * decode(f.currency_code, fnd_profile.value('MSC_HUB_CUR_CODE_RPT'), 1, nvl(mcc.conv_rate, 0)) indep_demand_value2,

1328: f.indep_met_ontime_count,
1329: f.indep_met_full_count,
1330: f.indep_demand_qty,
1331: f.indep_demand_value,
1332: f.indep_demand_value * decode(f.currency_code, fnd_profile.value('MSC_HUB_CUR_CODE_RPT'), 1, nvl(mcc.conv_rate, 0)) indep_demand_value2,
1333: f.indep_by_due_date_qty,
1334: f.sales_order_qty,
1335: f.sales_order_count,
1336: f.sales_order_metr_count,

Line 1343: f.late_order_value * decode(f.currency_code, fnd_profile.value('MSC_HUB_CUR_CODE_RPT'), 1, nvl(mcc.conv_rate, 0)) late_order_value2,

1339: f.late_dmd_stf_factor,
1340: f.late_order_count,
1341: f.late_order_qty,
1342: f.late_order_value,
1343: f.late_order_value * decode(f.currency_code, fnd_profile.value('MSC_HUB_CUR_CODE_RPT'), 1, nvl(mcc.conv_rate, 0)) late_order_value2,
1344: f.io_delivered_qty,
1345: f.io_required_qty,
1346: f.net_demand,
1347: f.constrained_fcst,

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

1345: f.io_required_qty,
1346: f.net_demand,
1347: f.constrained_fcst,
1348: f.constrained_fcst_value,
1349: f.constrained_fcst_value * decode(f.currency_code, fnd_profile.value('MSC_HUB_CUR_CODE_RPT'), 1, nvl(mcc.conv_rate, 0)) constrained_fcst_value2,
1350: f.service_level,
1351: f.annualized_cogs,
1352: f.demand_fulfillment_lead_time,
1353: f.sales_order_sd,

Line 1355: f.sales_order_sd_value * decode(f.currency_code, fnd_profile.value('MSC_HUB_CUR_CODE_RPT'), 1, nvl(mcc.conv_rate, 0)) sales_order_sd_value2,

1351: f.annualized_cogs,
1352: f.demand_fulfillment_lead_time,
1353: f.sales_order_sd,
1354: f.sales_order_sd_value,
1355: f.sales_order_sd_value * decode(f.currency_code, fnd_profile.value('MSC_HUB_CUR_CODE_RPT'), 1, nvl(mcc.conv_rate, 0)) sales_order_sd_value2,
1356: f.sales_order_rd,
1357: f.sales_order_rd_value,
1358: f.sales_order_rd_value * decode(f.currency_code, fnd_profile.value('MSC_HUB_CUR_CODE_RPT'), 1, nvl(mcc.conv_rate, 0)) sales_order_rd_value2,
1359: f.sales_order_pd,

Line 1358: f.sales_order_rd_value * decode(f.currency_code, fnd_profile.value('MSC_HUB_CUR_CODE_RPT'), 1, nvl(mcc.conv_rate, 0)) sales_order_rd_value2,

1354: f.sales_order_sd_value,
1355: f.sales_order_sd_value * decode(f.currency_code, fnd_profile.value('MSC_HUB_CUR_CODE_RPT'), 1, nvl(mcc.conv_rate, 0)) sales_order_sd_value2,
1356: f.sales_order_rd,
1357: f.sales_order_rd_value,
1358: f.sales_order_rd_value * decode(f.currency_code, fnd_profile.value('MSC_HUB_CUR_CODE_RPT'), 1, nvl(mcc.conv_rate, 0)) sales_order_rd_value2,
1359: f.sales_order_pd,
1360: f.sales_order_pd_value,
1361: f.sales_order_pd_value * decode(f.currency_code, fnd_profile.value('MSC_HUB_CUR_CODE_RPT'), 1, nvl(mcc.conv_rate, 0)) sales_order_pd_value2,
1362: fnd_global.user_id, sysdate,

Line 1361: f.sales_order_pd_value * decode(f.currency_code, fnd_profile.value('MSC_HUB_CUR_CODE_RPT'), 1, nvl(mcc.conv_rate, 0)) sales_order_pd_value2,

1357: f.sales_order_rd_value,
1358: f.sales_order_rd_value * decode(f.currency_code, fnd_profile.value('MSC_HUB_CUR_CODE_RPT'), 1, nvl(mcc.conv_rate, 0)) sales_order_rd_value2,
1359: f.sales_order_pd,
1360: f.sales_order_pd_value,
1361: f.sales_order_pd_value * decode(f.currency_code, fnd_profile.value('MSC_HUB_CUR_CODE_RPT'), 1, nvl(mcc.conv_rate, 0)) sales_order_pd_value2,
1362: fnd_global.user_id, sysdate,
1363: sysdate, fnd_global.user_id, fnd_global.login_id,
1364: fnd_global.conc_program_id, fnd_global.conc_login_id,
1365: fnd_global.prog_appl_id, fnd_global.conc_request_id

Line 1450: and fnd_profile.value('MSC_HUB_CUR_CODE_RPT')=mcc.to_currency(+)

1446: decode(l_plan_type, 6, l_owning_currency_code, nvl(mtp.currency_code, l_owning_currency_code))
1447: ) f,
1448: msc_currency_conv_mv mcc
1449: where f.currency_code=mcc.from_currency(+)
1450: and fnd_profile.value('MSC_HUB_CUR_CODE_RPT')=mcc.to_currency(+)
1451: and f.order_date=mcc.calendar_date(+);
1452:
1453: l_rowcount1 := l_rowcount1 + sql%rowcount;
1454: msc_phub_util.log('insert into msc_demands_f:final: '||sql%rowcount);

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

1561:
1562: procedure summarize_demands_f(errbuf out nocopy varchar2, retcode out nocopy varchar2,
1563: p_plan_id number, p_plan_run_id number)
1564: is
1565: l_category_set_id1 number := fnd_profile.value('MSC_HUB_CAT_SET_ID_1');
1566: begin
1567: msc_phub_util.log('msc_demand_pkg.summarize_demands_f');
1568: retcode := 0;
1569: errbuf := '';

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

1934:
1935: procedure summarize_demands_cum_f(errbuf out nocopy varchar2, retcode out nocopy varchar2,
1936: p_plan_id number, p_plan_run_id number)
1937: is
1938: l_category_set_id1 number := fnd_profile.value('MSC_HUB_CAT_SET_ID_1');
1939: begin
1940: msc_phub_util.log('msc_demand_pkg.summarize_demands_cum_f');
1941: retcode := 0;
1942: errbuf := '';