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.BIM_MARKET_FACTS_PKG dependencies on FII_CURRENCY

Line 705: ,fii_currency.get_global_rate_primary(nvl(f3.functional_currency_code,'USD'),f3.last_update_date)

701: ,a.activity_id
702: ,a.start_date
703: ,a.end_date
704: ,a.business_unit_id
705: ,fii_currency.get_global_rate_primary(nvl(f3.functional_currency_code,'USD'),f3.last_update_date)
706: ,fii_currency.get_global_rate_secondary(nvl(f3.functional_currency_code,'USD'),f3.last_update_date)
707: ,nvl(f3.functional_currency_code,'USD')
708: HAVING sum(nvl(f3.func_actual_delta,0)) <> 0
709: union all --actual revenue at schedule level

Line 706: ,fii_currency.get_global_rate_secondary(nvl(f3.functional_currency_code,'USD'),f3.last_update_date)

702: ,a.start_date
703: ,a.end_date
704: ,a.business_unit_id
705: ,fii_currency.get_global_rate_primary(nvl(f3.functional_currency_code,'USD'),f3.last_update_date)
706: ,fii_currency.get_global_rate_secondary(nvl(f3.functional_currency_code,'USD'),f3.last_update_date)
707: ,nvl(f3.functional_currency_code,'USD')
708: HAVING sum(nvl(f3.func_actual_delta,0)) <> 0
709: union all --actual revenue at schedule level
710: SELECT trunc(f3.last_update_date) transaction_create_date

Line 800: ,fii_currency.get_global_rate_primary(nvl(f3.functional_currency_code,'USD'),f3.last_update_date)

796: ,a.activity_id
797: ,a.start_date
798: ,a.end_date
799: ,a.business_unit_id
800: ,fii_currency.get_global_rate_primary(nvl(f3.functional_currency_code,'USD'),f3.last_update_date)
801: ,fii_currency.get_global_rate_secondary(nvl(f3.functional_currency_code,'USD'),f3.last_update_date)
802: ,nvl(f3.functional_currency_code,'USD')
803: HAVING sum(nvl(f3.func_actual_delta,0)) <>0
804: union all --cost

Line 801: ,fii_currency.get_global_rate_secondary(nvl(f3.functional_currency_code,'USD'),f3.last_update_date)

797: ,a.start_date
798: ,a.end_date
799: ,a.business_unit_id
800: ,fii_currency.get_global_rate_primary(nvl(f3.functional_currency_code,'USD'),f3.last_update_date)
801: ,fii_currency.get_global_rate_secondary(nvl(f3.functional_currency_code,'USD'),f3.last_update_date)
802: ,nvl(f3.functional_currency_code,'USD')
803: HAVING sum(nvl(f3.func_actual_delta,0)) <>0
804: union all --cost
805: SELECT

Line 901: ,fii_currency.get_global_rate_primary(nvl(f3.functional_currency_code,'USD'),f3.last_update_date)

897: ,a.activity_id
898: ,a.start_date
899: ,a.end_date
900: ,a.business_unit_id
901: ,fii_currency.get_global_rate_primary(nvl(f3.functional_currency_code,'USD'),f3.last_update_date)
902: ,fii_currency.get_global_rate_secondary(nvl(f3.functional_currency_code,'USD'),f3.last_update_date)
903: ,nvl(f3.functional_currency_code,'USD')
904: HAVING sum(nvl(f3.func_actual_delta,0)) <> 0
905: union all --cost at schedule level

Line 902: ,fii_currency.get_global_rate_secondary(nvl(f3.functional_currency_code,'USD'),f3.last_update_date)

898: ,a.start_date
899: ,a.end_date
900: ,a.business_unit_id
901: ,fii_currency.get_global_rate_primary(nvl(f3.functional_currency_code,'USD'),f3.last_update_date)
902: ,fii_currency.get_global_rate_secondary(nvl(f3.functional_currency_code,'USD'),f3.last_update_date)
903: ,nvl(f3.functional_currency_code,'USD')
904: HAVING sum(nvl(f3.func_actual_delta,0)) <> 0
905: union all --cost at schedule level
906: SELECT case

Line 1002: ,fii_currency.get_global_rate_primary(nvl(f3.functional_currency_code,'USD'),f3.last_update_date)

998: ,a.activity_id
999: ,a.start_date
1000: ,a.end_date
1001: ,a.business_unit_id
1002: ,fii_currency.get_global_rate_primary(nvl(f3.functional_currency_code,'USD'),f3.last_update_date)
1003: ,fii_currency.get_global_rate_secondary(nvl(f3.functional_currency_code,'USD'),f3.last_update_date)
1004: ,nvl(f3.functional_currency_code,'USD')
1005: HAVING sum(nvl(f3.func_actual_delta,0)) <> 0
1006: --sbehera 15 jan 2004

Line 1003: ,fii_currency.get_global_rate_secondary(nvl(f3.functional_currency_code,'USD'),f3.last_update_date)

999: ,a.start_date
1000: ,a.end_date
1001: ,a.business_unit_id
1002: ,fii_currency.get_global_rate_primary(nvl(f3.functional_currency_code,'USD'),f3.last_update_date)
1003: ,fii_currency.get_global_rate_secondary(nvl(f3.functional_currency_code,'USD'),f3.last_update_date)
1004: ,nvl(f3.functional_currency_code,'USD')
1005: HAVING sum(nvl(f3.func_actual_delta,0)) <> 0
1006: --sbehera 15 jan 2004
1007: --for campaign forecasted response

Line 1470: ,fii_currency.get_global_rate_primary(nvl(s.request_currency,'USD'),nvl(s.approval_date,s.last_update_date))

1466: ,a.activity_id
1467: ,a.business_unit_id
1468: ,a.start_date
1469: ,a.end_date
1470: ,fii_currency.get_global_rate_primary(nvl(s.request_currency,'USD'),nvl(s.approval_date,s.last_update_date))
1471: ,fii_currency.get_global_rate_secondary(nvl(s.request_currency,'USD'),nvl(s.approval_date,s.last_update_date))
1472: ,nvl(s.request_currency,'USD')
1473: HAVING sum(nvl(s.approved_amount,0)) > 0
1474: --budget2

Line 1471: ,fii_currency.get_global_rate_secondary(nvl(s.request_currency,'USD'),nvl(s.approval_date,s.last_update_date))

1467: ,a.business_unit_id
1468: ,a.start_date
1469: ,a.end_date
1470: ,fii_currency.get_global_rate_primary(nvl(s.request_currency,'USD'),nvl(s.approval_date,s.last_update_date))
1471: ,fii_currency.get_global_rate_secondary(nvl(s.request_currency,'USD'),nvl(s.approval_date,s.last_update_date))
1472: ,nvl(s.request_currency,'USD')
1473: HAVING sum(nvl(s.approved_amount,0)) > 0
1474: --budget2
1475: union all

Line 1572: ,fii_currency.get_global_rate_primary(nvl(request_currency,'USD'),nvl(s.approval_date,s.last_update_date))

1568: ,a.activity_id
1569: ,a.business_unit_id
1570: ,a.start_date
1571: ,a.end_date
1572: ,fii_currency.get_global_rate_primary(nvl(request_currency,'USD'),nvl(s.approval_date,s.last_update_date))
1573: ,fii_currency.get_global_rate_secondary(nvl(request_currency,'USD'),nvl(s.approval_date,s.last_update_date))
1574: ,nvl(request_currency,'USD')
1575: union all
1576: --budget1 for Camp Schedules and Event Schedules

Line 1573: ,fii_currency.get_global_rate_secondary(nvl(request_currency,'USD'),nvl(s.approval_date,s.last_update_date))

1569: ,a.business_unit_id
1570: ,a.start_date
1571: ,a.end_date
1572: ,fii_currency.get_global_rate_primary(nvl(request_currency,'USD'),nvl(s.approval_date,s.last_update_date))
1573: ,fii_currency.get_global_rate_secondary(nvl(request_currency,'USD'),nvl(s.approval_date,s.last_update_date))
1574: ,nvl(request_currency,'USD')
1575: union all
1576: --budget1 for Camp Schedules and Event Schedules
1577: SELECT /*+ USE_HASH(S A B) */

Line 1668: ,fii_currency.get_global_rate_primary(nvl(s.request_currency,'USD'),nvl(s.approval_date,s.last_update_date))

1664: ,a.activity_id
1665: ,a.business_unit_id
1666: ,a.start_date
1667: ,a.end_date
1668: ,fii_currency.get_global_rate_primary(nvl(s.request_currency,'USD'),nvl(s.approval_date,s.last_update_date))
1669: ,fii_currency.get_global_rate_secondary(nvl(s.request_currency,'USD'),nvl(s.approval_date,s.last_update_date))
1670: ,nvl(s.request_currency,'USD')
1671: HAVING sum(nvl(s.approved_amount,0)) > 0
1672: union all

Line 1669: ,fii_currency.get_global_rate_secondary(nvl(s.request_currency,'USD'),nvl(s.approval_date,s.last_update_date))

1665: ,a.business_unit_id
1666: ,a.start_date
1667: ,a.end_date
1668: ,fii_currency.get_global_rate_primary(nvl(s.request_currency,'USD'),nvl(s.approval_date,s.last_update_date))
1669: ,fii_currency.get_global_rate_secondary(nvl(s.request_currency,'USD'),nvl(s.approval_date,s.last_update_date))
1670: ,nvl(s.request_currency,'USD')
1671: HAVING sum(nvl(s.approved_amount,0)) > 0
1672: union all
1673: --budget2 for Camp Schedules and Event Schedules

Line 1764: ,fii_currency.get_global_rate_primary(nvl(request_currency,'USD'),nvl(s.approval_date,s.last_update_date))

1760: ,a.activity_id
1761: ,a.business_unit_id
1762: ,a.start_date
1763: ,a.end_date
1764: ,fii_currency.get_global_rate_primary(nvl(request_currency,'USD'),nvl(s.approval_date,s.last_update_date))
1765: ,fii_currency.get_global_rate_secondary(nvl(request_currency,'USD'),nvl(s.approval_date,s.last_update_date))
1766: ,nvl(request_currency,'USD')
1767: union all --registration1
1768: SELECT /*+ USE_HASH(S A B) */

Line 1765: ,fii_currency.get_global_rate_secondary(nvl(request_currency,'USD'),nvl(s.approval_date,s.last_update_date))

1761: ,a.business_unit_id
1762: ,a.start_date
1763: ,a.end_date
1764: ,fii_currency.get_global_rate_primary(nvl(request_currency,'USD'),nvl(s.approval_date,s.last_update_date))
1765: ,fii_currency.get_global_rate_secondary(nvl(request_currency,'USD'),nvl(s.approval_date,s.last_update_date))
1766: ,nvl(request_currency,'USD')
1767: union all --registration1
1768: SELECT /*+ USE_HASH(S A B) */
1769: trunc(X.last_reg_status_date) transaction_create_date

Line 2822: FII_CURRENCY.get_rate(from_currency,l_global_currency_code,transaction_create_date,l_pgc_rate_type),

2818: prim_conversion_rate,
2819: sec_conversion_rate)
2820: SELECT from_currency,
2821: transaction_create_date,
2822: FII_CURRENCY.get_rate(from_currency,l_global_currency_code,transaction_create_date,l_pgc_rate_type),
2823: FII_CURRENCY.get_rate(from_currency,l_secondary_currency_code,transaction_create_date,l_sgc_rate_type)
2824: FROM (select distinct from_currency from_currency,
2825: transaction_create_date transaction_create_date
2826: from bim_i_marketing_facts_stg);

Line 2823: FII_CURRENCY.get_rate(from_currency,l_secondary_currency_code,transaction_create_date,l_sgc_rate_type)

2819: sec_conversion_rate)
2820: SELECT from_currency,
2821: transaction_create_date,
2822: FII_CURRENCY.get_rate(from_currency,l_global_currency_code,transaction_create_date,l_pgc_rate_type),
2823: FII_CURRENCY.get_rate(from_currency,l_secondary_currency_code,transaction_create_date,l_sgc_rate_type)
2824: FROM (select distinct from_currency from_currency,
2825: transaction_create_date transaction_create_date
2826: from bim_i_marketing_facts_stg);
2827: commit;

Line 5356: FII_CURRENCY.get_rate(from_currency,l_global_currency_code,transaction_create_date,l_pgc_rate_type),

5352: prim_conversion_rate,
5353: sec_conversion_rate)
5354: SELECT from_currency,
5355: transaction_create_date,
5356: FII_CURRENCY.get_rate(from_currency,l_global_currency_code,transaction_create_date,l_pgc_rate_type),
5357: FII_CURRENCY.get_rate(from_currency,l_secondary_currency_code,transaction_create_date,l_sgc_rate_type)
5358: FROM (select distinct from_currency from_currency,
5359: transaction_create_date transaction_create_date
5360: from bim_i_marketing_facts_stg);

Line 5357: FII_CURRENCY.get_rate(from_currency,l_secondary_currency_code,transaction_create_date,l_sgc_rate_type)

5353: sec_conversion_rate)
5354: SELECT from_currency,
5355: transaction_create_date,
5356: FII_CURRENCY.get_rate(from_currency,l_global_currency_code,transaction_create_date,l_pgc_rate_type),
5357: FII_CURRENCY.get_rate(from_currency,l_secondary_currency_code,transaction_create_date,l_sgc_rate_type)
5358: FROM (select distinct from_currency from_currency,
5359: transaction_create_date transaction_create_date
5360: from bim_i_marketing_facts_stg);
5361: