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

Line 533: fii_currency.get_rate(from_currency, to_currency1, time_booked_date_id, rate_type)) RATE1,

529: RATE3,
530: RATE4)
531: SELECT from_currency, to_currency1, to_currency3, time_booked_date_id CONVERSION_DATE, rate_type CONVERSION_TYPE,
532: decode(from_currency, to_currency1, 1,
533: fii_currency.get_rate(from_currency, to_currency1, time_booked_date_id, rate_type)) RATE1,
534: decode(from_currency, g_global_currency, 1,
535: fii_currency.get_global_rate_primary(to_currency3, time_booked_date_id)) RATE2,
536: decode(from_currency, to_currency3, 1,
537: fii_currency.get_rate(from_currency, to_currency3, time_booked_date_id, g_global_rate_type)) RATE3,

Line 535: fii_currency.get_global_rate_primary(to_currency3, time_booked_date_id)) RATE2,

531: SELECT from_currency, to_currency1, to_currency3, time_booked_date_id CONVERSION_DATE, rate_type CONVERSION_TYPE,
532: decode(from_currency, to_currency1, 1,
533: fii_currency.get_rate(from_currency, to_currency1, time_booked_date_id, rate_type)) RATE1,
534: decode(from_currency, g_global_currency, 1,
535: fii_currency.get_global_rate_primary(to_currency3, time_booked_date_id)) RATE2,
536: decode(from_currency, to_currency3, 1,
537: fii_currency.get_rate(from_currency, to_currency3, time_booked_date_id, g_global_rate_type)) RATE3,
538: decode(from_currency, g_sec_global_currency, 1,
539: fii_currency.get_global_rate_secondary(to_currency3, time_booked_date_id)) RATE4

Line 537: fii_currency.get_rate(from_currency, to_currency3, time_booked_date_id, g_global_rate_type)) RATE3,

533: fii_currency.get_rate(from_currency, to_currency1, time_booked_date_id, rate_type)) RATE1,
534: decode(from_currency, g_global_currency, 1,
535: fii_currency.get_global_rate_primary(to_currency3, time_booked_date_id)) RATE2,
536: decode(from_currency, to_currency3, 1,
537: fii_currency.get_rate(from_currency, to_currency3, time_booked_date_id, g_global_rate_type)) RATE3,
538: decode(from_currency, g_sec_global_currency, 1,
539: fii_currency.get_global_rate_secondary(to_currency3, time_booked_date_id)) RATE4
540: FROM (SELECT /*+ PARALLEL(tmp) */ distinct from_currency, to_currency1, to_currency3, time_booked_date_id, rate_type
541: FROM isc_tmp_book_sum2 tmp);

Line 539: fii_currency.get_global_rate_secondary(to_currency3, time_booked_date_id)) RATE4

535: fii_currency.get_global_rate_primary(to_currency3, time_booked_date_id)) RATE2,
536: decode(from_currency, to_currency3, 1,
537: fii_currency.get_rate(from_currency, to_currency3, time_booked_date_id, g_global_rate_type)) RATE3,
538: decode(from_currency, g_sec_global_currency, 1,
539: fii_currency.get_global_rate_secondary(to_currency3, time_booked_date_id)) RATE4
540: FROM (SELECT /*+ PARALLEL(tmp) */ distinct from_currency, to_currency1, to_currency3, time_booked_date_id, rate_type
541: FROM isc_tmp_book_sum2 tmp);
542:
543: FII_UTIL.Stop_Timer;

Line 970: fii_currency.get_rate(from_currency, to_currency1, time_booked_date_id, rate_type)) RATE1,

966: RATE3,
967: RATE4)
968: SELECT from_currency, to_currency1, to_currency3, time_booked_date_id CONVERSION_DATE, rate_type CONVERSION_TYPE,
969: decode(from_currency, to_currency1, 1,
970: fii_currency.get_rate(from_currency, to_currency1, time_booked_date_id, rate_type)) RATE1,
971: decode(from_currency, g_global_currency, 1,
972: fii_currency.get_global_rate_primary(to_currency3, time_booked_date_id)) RATE2,
973: decode(from_currency, to_currency3, 1,
974: fii_currency.get_rate(from_currency, to_currency3, time_booked_date_id, g_global_rate_type)) RATE3,

Line 972: fii_currency.get_global_rate_primary(to_currency3, time_booked_date_id)) RATE2,

968: SELECT from_currency, to_currency1, to_currency3, time_booked_date_id CONVERSION_DATE, rate_type CONVERSION_TYPE,
969: decode(from_currency, to_currency1, 1,
970: fii_currency.get_rate(from_currency, to_currency1, time_booked_date_id, rate_type)) RATE1,
971: decode(from_currency, g_global_currency, 1,
972: fii_currency.get_global_rate_primary(to_currency3, time_booked_date_id)) RATE2,
973: decode(from_currency, to_currency3, 1,
974: fii_currency.get_rate(from_currency, to_currency3, time_booked_date_id, g_global_rate_type)) RATE3,
975: decode(from_currency, g_sec_global_currency, 1,
976: fii_currency.get_global_rate_secondary(to_currency3, time_booked_date_id)) RATE4

Line 974: fii_currency.get_rate(from_currency, to_currency3, time_booked_date_id, g_global_rate_type)) RATE3,

970: fii_currency.get_rate(from_currency, to_currency1, time_booked_date_id, rate_type)) RATE1,
971: decode(from_currency, g_global_currency, 1,
972: fii_currency.get_global_rate_primary(to_currency3, time_booked_date_id)) RATE2,
973: decode(from_currency, to_currency3, 1,
974: fii_currency.get_rate(from_currency, to_currency3, time_booked_date_id, g_global_rate_type)) RATE3,
975: decode(from_currency, g_sec_global_currency, 1,
976: fii_currency.get_global_rate_secondary(to_currency3, time_booked_date_id)) RATE4
977: FROM (SELECT distinct from_currency, to_currency1, to_currency3, time_booked_date_id, rate_type
978: FROM isc_tmp_book_sum2);

Line 976: fii_currency.get_global_rate_secondary(to_currency3, time_booked_date_id)) RATE4

972: fii_currency.get_global_rate_primary(to_currency3, time_booked_date_id)) RATE2,
973: decode(from_currency, to_currency3, 1,
974: fii_currency.get_rate(from_currency, to_currency3, time_booked_date_id, g_global_rate_type)) RATE3,
975: decode(from_currency, g_sec_global_currency, 1,
976: fii_currency.get_global_rate_secondary(to_currency3, time_booked_date_id)) RATE4
977: FROM (SELECT distinct from_currency, to_currency1, to_currency3, time_booked_date_id, rate_type
978: FROM isc_tmp_book_sum2);
979:
980: FII_UTIL.Stop_Timer;