APPS.MSC_SUPPLIER_PKG dependencies on FND_PROFILE

Line 134: fnd_profile.value('MSC_HUB_CUR_CODE_RPT'), 1, nvl(mcc.conv_rate,0))) buy_order_value2,

130: sum(t.po_count) po_count,
131: sum(t.po_cancel_count) po_cancel_count,
132: sum(t.buy_order_value) buy_order_value,
133: sum(t.buy_order_value * decode(t.currency_code,
134: fnd_profile.value('MSC_HUB_CUR_CODE_RPT'), 1, nvl(mcc.conv_rate,0))) buy_order_value2,
135: sum(buy_order_count) buy_order_count
136: from (
137: select
138: msr.sr_instance_id sr_instance_id,

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

258: msc_currency_conv_mv mcc,
259: msc_phub_suppliers_mv mps
260:
261: where mcc.from_currency(+) = t.currency_code
262: and mcc.to_currency(+) = fnd_profile.value('MSC_HUB_CUR_CODE_RPT')
263: and mcc.calendar_date(+) = t.analysis_date
264: and mps.supplier_id = nvl(t.supplier_id, -23453)
265: and mps.supplier_site_id = nvl(t.supplier_site_id, -23453)
266: and mps.region_id = decode(nvl(t.supplier_site_id, -23453),

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

667:
668: procedure populate_summary(errbuf out nocopy varchar2, retcode out nocopy varchar2,
669: p_plan_id number, p_plan_run_id number)
670: is
671: l_category_set_id1 number := fnd_profile.value('MSC_HUB_CAT_SET_ID_1');
672: begin
673: -- level 1
674: insert into msc_suppliers_f (
675: plan_id, plan_run_id,