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

Line 2449: decode(txn_currency,g_prim_currency,1,fii_currency.get_global_rate_primary(txn_currency,

2445: MERGE INTO BIL_BI_CURRENCY_RATE sumry
2446: USING ( SELECT
2447: txn_currency,
2448: effective_date,
2449: decode(txn_currency,g_prim_currency,1,fii_currency.get_global_rate_primary(txn_currency,
2450: trunc(least(sysdate,effective_date)))) rate,
2451: decode(txn_currency,g_sec_currency,1,fii_currency.get_global_rate_secondary(txn_currency,
2452: trunc(least(sysdate,effective_date)))) rate_s
2453: FROM (SELECT /*+ parallel(stg) */ DISTINCT

Line 2451: decode(txn_currency,g_sec_currency,1,fii_currency.get_global_rate_secondary(txn_currency,

2447: txn_currency,
2448: effective_date,
2449: decode(txn_currency,g_prim_currency,1,fii_currency.get_global_rate_primary(txn_currency,
2450: trunc(least(sysdate,effective_date)))) rate,
2451: decode(txn_currency,g_sec_currency,1,fii_currency.get_global_rate_secondary(txn_currency,
2452: trunc(least(sysdate,effective_date)))) rate_s
2453: FROM (SELECT /*+ parallel(stg) */ DISTINCT
2454: txn_currency ,
2455: effective_date

Line 2481: decode(txn_currency,g_prim_currency,1,fii_currency.get_global_rate_primary(txn_currency,

2477: MERGE INTO BIL_BI_CURRENCY_RATE sumry
2478: USING ( SELECT
2479: txn_currency,
2480: effective_date,
2481: decode(txn_currency,g_prim_currency,1,fii_currency.get_global_rate_primary(txn_currency,
2482: trunc(least(sysdate,effective_date)))) rate,
2483: decode(txn_currency,g_sec_currency,1,fii_currency.get_global_rate_secondary(txn_currency,
2484: trunc(least(sysdate,effective_date)))) rate_s
2485: FROM (SELECT DISTINCT txn_currency,

Line 2483: decode(txn_currency,g_sec_currency,1,fii_currency.get_global_rate_secondary(txn_currency,

2479: txn_currency,
2480: effective_date,
2481: decode(txn_currency,g_prim_currency,1,fii_currency.get_global_rate_primary(txn_currency,
2482: trunc(least(sysdate,effective_date)))) rate,
2483: decode(txn_currency,g_sec_currency,1,fii_currency.get_global_rate_secondary(txn_currency,
2484: trunc(least(sysdate,effective_date)))) rate_s
2485: FROM (SELECT DISTINCT txn_currency,
2486: effective_date
2487: FROM BIL_BI_OPDTL_STG stg

Line 2516: decode(txn_currency,g_prim_currency,1,fii_currency.get_global_rate_primary(txn_currency,

2512: MERGE INTO BIL_BI_CURRENCY_RATE sumry
2513: USING ( SELECT
2514: txn_currency,
2515: effective_date,
2516: decode(txn_currency,g_prim_currency,1,fii_currency.get_global_rate_primary(txn_currency,
2517: trunc(least(sysdate,effective_date)))) rate
2518: FROM (SELECT /*+ parallel(stg) */ DISTINCT
2519: txn_currency ,
2520: effective_date

Line 2543: decode(txn_currency,g_prim_currency,1,fii_currency.get_global_rate_primary(txn_currency,

2539: MERGE INTO BIL_BI_CURRENCY_RATE sumry
2540: USING ( SELECT
2541: txn_currency,
2542: effective_date,
2543: decode(txn_currency,g_prim_currency,1,fii_currency.get_global_rate_primary(txn_currency,
2544: trunc(least(sysdate,effective_date)))) rate
2545: FROM (SELECT DISTINCT txn_currency,
2546: effective_date
2547: FROM BIL_BI_OPDTL_STG stg