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_PIPELINE_F_PKG dependencies on BIL_BI_CURRENCY_RATE

Line 115: MERGE INTO BIL_BI_CURRENCY_RATE sumry

111: p_msg => 'Start of Procedure '|| l_proc);
112: END IF;
113:
114:
115: MERGE INTO BIL_BI_CURRENCY_RATE sumry
116: USING
117: (
118: SELECT
119: txn_currency,

Line 162: p_msg => 'Inserted '||sql%rowcount||' into bil_bi_currency_rate table');

158: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN
159: bil_bi_util_collection_pkg.writeLog(
160: p_log_level => fnd_log.LEVEL_EVENT,
161: p_module => g_pkg || l_proc ,
162: p_msg => 'Inserted '||sql%rowcount||' into bil_bi_currency_rate table');
163: END IF;
164:
165: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
166: bil_bi_util_collection_pkg.writeLog(

Line 243: from BIL_BI_CURRENCY_RATE

239: SET (stg.prim_conversion_rate,conversion_rate_s) =
240: (
241: select
242: exchange_rate,exchange_rate_s
243: from BIL_BI_CURRENCY_RATE
244: where
245: currency_code = stg.txn_currency and
246: exchange_date = stg.effective_date
247: );

Line 2871: MERGE /+ parallel(sumry) / INTO BIL_BI_CURRENCY_RATE sumry

2867: p_msg => 'Start of Procedure '|| l_proc);
2868: END IF;
2869:
2870: IF (p_mode = 'INIT') THEN
2871: MERGE /*+ parallel(sumry) */ INTO BIL_BI_CURRENCY_RATE sumry
2872: USING
2873: (
2874: SELECT
2875: txn_currency,

Line 2922: --gather stats on bil_bi_currency_rate during initial load

2918: rates.prate,
2919: rates.srate
2920: );
2921:
2922: --gather stats on bil_bi_currency_rate during initial load
2923: bil_bi_util_collection_pkg.analyze_table('BIL_BI_CURRENCY_RATE',TRUE, 10, 'GLOBAL');
2924:
2925: ELSE
2926: MERGE INTO BIL_BI_CURRENCY_RATE sumry

Line 2923: bil_bi_util_collection_pkg.analyze_table('BIL_BI_CURRENCY_RATE',TRUE, 10, 'GLOBAL');

2919: rates.srate
2920: );
2921:
2922: --gather stats on bil_bi_currency_rate during initial load
2923: bil_bi_util_collection_pkg.analyze_table('BIL_BI_CURRENCY_RATE',TRUE, 10, 'GLOBAL');
2924:
2925: ELSE
2926: MERGE INTO BIL_BI_CURRENCY_RATE sumry
2927: USING

Line 2926: MERGE INTO BIL_BI_CURRENCY_RATE sumry

2922: --gather stats on bil_bi_currency_rate during initial load
2923: bil_bi_util_collection_pkg.analyze_table('BIL_BI_CURRENCY_RATE',TRUE, 10, 'GLOBAL');
2924:
2925: ELSE
2926: MERGE INTO BIL_BI_CURRENCY_RATE sumry
2927: USING
2928: (
2929: SELECT
2930: txn_currency,

Line 2982: p_msg => 'Inserted '||sql%rowcount||' into bil_bi_currency_rate table');

2978: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN
2979: bil_bi_util_collection_pkg.writeLog(
2980: p_log_level => fnd_log.LEVEL_EVENT,
2981: p_module => g_pkg || l_proc ,
2982: p_msg => 'Inserted '||sql%rowcount||' into bil_bi_currency_rate table');
2983: END IF;
2984: commit;
2985: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
2986: bil_bi_util_collection_pkg.writeLog(

Line 3071: from BIL_BI_CURRENCY_RATE

3067: SET (stg.prim_conversion_rate,conversion_rate_s) =
3068: (
3069: select
3070: exchange_rate,exchange_rate_s
3071: from BIL_BI_CURRENCY_RATE
3072: where
3073: currency_code = stg.txn_currency and
3074: exchange_date = stg.effective_date
3075: );

Line 3086: bil_bi_currency_rate rates) curr_rate

3082: exchange_rate_s,
3083: exchange_date,
3084: currency_code
3085: FROM
3086: bil_bi_currency_rate rates) curr_rate
3087: ON (curr_rate.EXCHANGE_DATE = stg.decision_date AND curr_rate.currency_code = stg.currency_code)
3088: WHEN MATCHED THEN
3089: UPDATE SET
3090: stg.prim_conversion_rate = curr_rate.exchange_rate,

Line 3099: from BIL_BI_CURRENCY_RATE

3095: SET (stg.prim_conversion_rate,conversion_rate_s) =
3096: (
3097: select
3098: exchange_rate,exchange_rate_s
3099: from BIL_BI_CURRENCY_RATE
3100: where
3101: currency_code = stg.txn_currency and
3102: exchange_date = stg.effective_date
3103: );

Line 3111: from BIL_BI_CURRENCY_RATE

3107: SET (stg.prim_conversion_rate,conversion_rate_s) =
3108: (
3109: select
3110: exchange_rate,exchange_rate_s
3111: from BIL_BI_CURRENCY_RATE
3112: where
3113: currency_code = stg.currency_code and
3114: exchange_date = stg.decision_date
3115: );