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

Line 17: l_enable_scrm number := nvl(fnd_profile.value('MSC_APCC_ENABLE_SCRM'), 1);

13: l_organization_id number;
14: l_transfer_id number := null;
15: l_start_time timestamp := systimestamp;
16: l_complete_time timestamp := systimestamp;
17: l_enable_scrm number := nvl(fnd_profile.value('MSC_APCC_ENABLE_SCRM'), 1);
18: begin
19: msc_phub_util.log('msc_phub_cost_pkg.populate_details:');
20: retcode := 0;
21: errbuf := null;

Line 482: f.revenue * decode(f.currency_code, fnd_profile.value('MSC_HUB_CUR_CODE_RPT'), 1, nvl(mcc.conv_rate, 0)) revenue2,

478: to_number(0) aggr_type,
479: to_number(-23453) category_set_id,
480: to_number(-23453) sr_category_id,
481: f.revenue,
482: f.revenue * decode(f.currency_code, fnd_profile.value('MSC_HUB_CUR_CODE_RPT'), 1, nvl(mcc.conv_rate, 0)) revenue2,
483: f.manufacturing_cost,
484: f.manufacturing_cost * decode(f.currency_code, fnd_profile.value('MSC_HUB_CUR_CODE_RPT'), 1, nvl(mcc.conv_rate, 0)) manufacturing_cost2,
485: f.purchasing_cost,
486: f.purchasing_cost * decode(f.currency_code, fnd_profile.value('MSC_HUB_CUR_CODE_RPT'), 1, nvl(mcc.conv_rate, 0)) purchasing_cost2,

Line 484: f.manufacturing_cost * decode(f.currency_code, fnd_profile.value('MSC_HUB_CUR_CODE_RPT'), 1, nvl(mcc.conv_rate, 0)) manufacturing_cost2,

480: to_number(-23453) sr_category_id,
481: f.revenue,
482: f.revenue * decode(f.currency_code, fnd_profile.value('MSC_HUB_CUR_CODE_RPT'), 1, nvl(mcc.conv_rate, 0)) revenue2,
483: f.manufacturing_cost,
484: f.manufacturing_cost * decode(f.currency_code, fnd_profile.value('MSC_HUB_CUR_CODE_RPT'), 1, nvl(mcc.conv_rate, 0)) manufacturing_cost2,
485: f.purchasing_cost,
486: f.purchasing_cost * decode(f.currency_code, fnd_profile.value('MSC_HUB_CUR_CODE_RPT'), 1, nvl(mcc.conv_rate, 0)) purchasing_cost2,
487: f.transportation_cost,
488: f.transportation_cost * decode(f.currency_code, fnd_profile.value('MSC_HUB_CUR_CODE_RPT'), 1, nvl(mcc.conv_rate, 0)) transportation_cost2,

Line 486: f.purchasing_cost * decode(f.currency_code, fnd_profile.value('MSC_HUB_CUR_CODE_RPT'), 1, nvl(mcc.conv_rate, 0)) purchasing_cost2,

482: f.revenue * decode(f.currency_code, fnd_profile.value('MSC_HUB_CUR_CODE_RPT'), 1, nvl(mcc.conv_rate, 0)) revenue2,
483: f.manufacturing_cost,
484: f.manufacturing_cost * decode(f.currency_code, fnd_profile.value('MSC_HUB_CUR_CODE_RPT'), 1, nvl(mcc.conv_rate, 0)) manufacturing_cost2,
485: f.purchasing_cost,
486: f.purchasing_cost * decode(f.currency_code, fnd_profile.value('MSC_HUB_CUR_CODE_RPT'), 1, nvl(mcc.conv_rate, 0)) purchasing_cost2,
487: f.transportation_cost,
488: f.transportation_cost * decode(f.currency_code, fnd_profile.value('MSC_HUB_CUR_CODE_RPT'), 1, nvl(mcc.conv_rate, 0)) transportation_cost2,
489: f.carrying_cost,
490: f.carrying_cost * decode(f.currency_code, fnd_profile.value('MSC_HUB_CUR_CODE_RPT'), 1, nvl(mcc.conv_rate, 0)) carrying_cost2,

Line 488: f.transportation_cost * decode(f.currency_code, fnd_profile.value('MSC_HUB_CUR_CODE_RPT'), 1, nvl(mcc.conv_rate, 0)) transportation_cost2,

484: f.manufacturing_cost * decode(f.currency_code, fnd_profile.value('MSC_HUB_CUR_CODE_RPT'), 1, nvl(mcc.conv_rate, 0)) manufacturing_cost2,
485: f.purchasing_cost,
486: f.purchasing_cost * decode(f.currency_code, fnd_profile.value('MSC_HUB_CUR_CODE_RPT'), 1, nvl(mcc.conv_rate, 0)) purchasing_cost2,
487: f.transportation_cost,
488: f.transportation_cost * decode(f.currency_code, fnd_profile.value('MSC_HUB_CUR_CODE_RPT'), 1, nvl(mcc.conv_rate, 0)) transportation_cost2,
489: f.carrying_cost,
490: f.carrying_cost * decode(f.currency_code, fnd_profile.value('MSC_HUB_CUR_CODE_RPT'), 1, nvl(mcc.conv_rate, 0)) carrying_cost2,
491: f.supply_chain_cost,
492: f.supply_chain_cost * decode(f.currency_code, fnd_profile.value('MSC_HUB_CUR_CODE_RPT'), 1, nvl(mcc.conv_rate, 0)) supply_chain_cost2,

Line 490: f.carrying_cost * decode(f.currency_code, fnd_profile.value('MSC_HUB_CUR_CODE_RPT'), 1, nvl(mcc.conv_rate, 0)) carrying_cost2,

486: f.purchasing_cost * decode(f.currency_code, fnd_profile.value('MSC_HUB_CUR_CODE_RPT'), 1, nvl(mcc.conv_rate, 0)) purchasing_cost2,
487: f.transportation_cost,
488: f.transportation_cost * decode(f.currency_code, fnd_profile.value('MSC_HUB_CUR_CODE_RPT'), 1, nvl(mcc.conv_rate, 0)) transportation_cost2,
489: f.carrying_cost,
490: f.carrying_cost * decode(f.currency_code, fnd_profile.value('MSC_HUB_CUR_CODE_RPT'), 1, nvl(mcc.conv_rate, 0)) carrying_cost2,
491: f.supply_chain_cost,
492: f.supply_chain_cost * decode(f.currency_code, fnd_profile.value('MSC_HUB_CUR_CODE_RPT'), 1, nvl(mcc.conv_rate, 0)) supply_chain_cost2,
493: (nvl(f.revenue,0) - nvl(f.supply_chain_cost,0)) gross_margin,
494: (nvl(f.revenue,0) - nvl(f.supply_chain_cost,0)) * decode(f.currency_code, fnd_profile.value('MSC_HUB_CUR_CODE_RPT'), 1, nvl(mcc.conv_rate, 0)) gross_margin2,

Line 492: f.supply_chain_cost * decode(f.currency_code, fnd_profile.value('MSC_HUB_CUR_CODE_RPT'), 1, nvl(mcc.conv_rate, 0)) supply_chain_cost2,

488: f.transportation_cost * decode(f.currency_code, fnd_profile.value('MSC_HUB_CUR_CODE_RPT'), 1, nvl(mcc.conv_rate, 0)) transportation_cost2,
489: f.carrying_cost,
490: f.carrying_cost * decode(f.currency_code, fnd_profile.value('MSC_HUB_CUR_CODE_RPT'), 1, nvl(mcc.conv_rate, 0)) carrying_cost2,
491: f.supply_chain_cost,
492: f.supply_chain_cost * decode(f.currency_code, fnd_profile.value('MSC_HUB_CUR_CODE_RPT'), 1, nvl(mcc.conv_rate, 0)) supply_chain_cost2,
493: (nvl(f.revenue,0) - nvl(f.supply_chain_cost,0)) gross_margin,
494: (nvl(f.revenue,0) - nvl(f.supply_chain_cost,0)) * decode(f.currency_code, fnd_profile.value('MSC_HUB_CUR_CODE_RPT'), 1, nvl(mcc.conv_rate, 0)) gross_margin2,
495: f.fixed_cost,
496: f.fixed_cost * decode(f.currency_code, fnd_profile.value('MSC_HUB_CUR_CODE_RPT'), 1, nvl(mcc.conv_rate, 0)) fixed_cost2,

Line 494: (nvl(f.revenue,0) - nvl(f.supply_chain_cost,0)) * decode(f.currency_code, fnd_profile.value('MSC_HUB_CUR_CODE_RPT'), 1, nvl(mcc.conv_rate, 0)) gross_margin2,

490: f.carrying_cost * decode(f.currency_code, fnd_profile.value('MSC_HUB_CUR_CODE_RPT'), 1, nvl(mcc.conv_rate, 0)) carrying_cost2,
491: f.supply_chain_cost,
492: f.supply_chain_cost * decode(f.currency_code, fnd_profile.value('MSC_HUB_CUR_CODE_RPT'), 1, nvl(mcc.conv_rate, 0)) supply_chain_cost2,
493: (nvl(f.revenue,0) - nvl(f.supply_chain_cost,0)) gross_margin,
494: (nvl(f.revenue,0) - nvl(f.supply_chain_cost,0)) * decode(f.currency_code, fnd_profile.value('MSC_HUB_CUR_CODE_RPT'), 1, nvl(mcc.conv_rate, 0)) gross_margin2,
495: f.fixed_cost,
496: f.fixed_cost * decode(f.currency_code, fnd_profile.value('MSC_HUB_CUR_CODE_RPT'), 1, nvl(mcc.conv_rate, 0)) fixed_cost2,
497: f.facility_cost,
498: f.facility_cost * decode(f.currency_code, fnd_profile.value('MSC_HUB_CUR_CODE_RPT'), 1, nvl(mcc.conv_rate, 0)) facility_cost2,

Line 496: f.fixed_cost * decode(f.currency_code, fnd_profile.value('MSC_HUB_CUR_CODE_RPT'), 1, nvl(mcc.conv_rate, 0)) fixed_cost2,

492: f.supply_chain_cost * decode(f.currency_code, fnd_profile.value('MSC_HUB_CUR_CODE_RPT'), 1, nvl(mcc.conv_rate, 0)) supply_chain_cost2,
493: (nvl(f.revenue,0) - nvl(f.supply_chain_cost,0)) gross_margin,
494: (nvl(f.revenue,0) - nvl(f.supply_chain_cost,0)) * decode(f.currency_code, fnd_profile.value('MSC_HUB_CUR_CODE_RPT'), 1, nvl(mcc.conv_rate, 0)) gross_margin2,
495: f.fixed_cost,
496: f.fixed_cost * decode(f.currency_code, fnd_profile.value('MSC_HUB_CUR_CODE_RPT'), 1, nvl(mcc.conv_rate, 0)) fixed_cost2,
497: f.facility_cost,
498: f.facility_cost * decode(f.currency_code, fnd_profile.value('MSC_HUB_CUR_CODE_RPT'), 1, nvl(mcc.conv_rate, 0)) facility_cost2,
499: f.item_travel_distance,
500: f.source_count,

Line 498: f.facility_cost * decode(f.currency_code, fnd_profile.value('MSC_HUB_CUR_CODE_RPT'), 1, nvl(mcc.conv_rate, 0)) facility_cost2,

494: (nvl(f.revenue,0) - nvl(f.supply_chain_cost,0)) * decode(f.currency_code, fnd_profile.value('MSC_HUB_CUR_CODE_RPT'), 1, nvl(mcc.conv_rate, 0)) gross_margin2,
495: f.fixed_cost,
496: f.fixed_cost * decode(f.currency_code, fnd_profile.value('MSC_HUB_CUR_CODE_RPT'), 1, nvl(mcc.conv_rate, 0)) fixed_cost2,
497: f.facility_cost,
498: f.facility_cost * decode(f.currency_code, fnd_profile.value('MSC_HUB_CUR_CODE_RPT'), 1, nvl(mcc.conv_rate, 0)) facility_cost2,
499: f.item_travel_distance,
500: f.source_count,
501: f.risk_item_count,
502: f.ctb_make_order_cnt,

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

569: decode(l_plan_type, 6, l_owning_currency_code, nvl(mtp.currency_code, l_owning_currency_code))
570: ) f,
571: msc_currency_conv_mv mcc
572: where f.currency_code=mcc.from_currency(+)
573: and fnd_profile.value('MSC_HUB_CUR_CODE_RPT')=mcc.to_currency(+)
574: and f.detail_date=mcc.calendar_date(+);
575:
576: msc_phub_util.log('insert into msc_costs_f:final: '||sql%rowcount);
577: commit;

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

592:
593: procedure summarize_costs_f(errbuf out nocopy varchar2, retcode out nocopy varchar2,
594: p_plan_id number, p_plan_run_id number)
595: is
596: l_category_set_id1 number := fnd_profile.value('MSC_HUB_CAT_SET_ID_1');
597: begin
598: msc_phub_util.log('msc_phub_cost_pkg.summarize_costs_f');
599: retcode := 0;
600: errbuf := '';