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.CE_CSH_FCST_POP dependencies on CE_CURRENCY_RATES_TEMP

Line 408: ce_currency_rates_temp curr ';

404:
405: IF( CE_CASH_FCST.G_rp_exchange_type IS NULL OR
406: CE_CASH_FCST.G_rp_exchange_type <> 'User')THEN
407: from_clause := from_clause || ' ,
408: ce_currency_rates_temp curr ';
409: END IF;
410:
411: IF (CE_CASH_FCST.G_trx_type IN ('APP','ARR','PAY','XTI','XTO','XTR')) THEN
412: from_clause := from_clause || ' ,

Line 448: -- Special case for OE, need to join to ce_currency_rates_temp to figure out

444: END IF;
445: END IF;
446:
447: --
448: -- Special case for OE, need to join to ce_currency_rates_temp to figure out
449: -- the functional value of the transaction amount
450: --
451: IF(CE_CASH_FCST.G_rp_amount_threshold IS NOT NULL AND
452: CE_CASH_FCST.G_rp_src_curr_type = 'F' AND

Line 455: ce_currency_rates_temp curr2 ';

451: IF(CE_CASH_FCST.G_rp_amount_threshold IS NOT NULL AND
452: CE_CASH_FCST.G_rp_src_curr_type = 'F' AND
453: CE_CASH_FCST.G_trx_type IN ('OEO','XTR'))THEN
454: from_clause := from_clause || ' ,
455: ce_currency_rates_temp curr2 ';
456: END IF;
457:
458: cep_standard.debug(from_clause);
459: return from_clause;

Line 746: -- Special case for OE, need to join to ce_currency_rates_temp to figure out

742: where_clause := where_clause || '
743: AND abs(nvl(src.amount,0)) > ' ||to_char(fnd_number.number_to_canonical(CE_CASH_FCST.G_rp_amount_threshold));
744: ELSIF(CE_CASH_FCST.G_rp_src_curr_type = 'F')THEN
745: --
746: -- Special case for OE, need to join to ce_currency_rates_temp to figure out
747: -- the functional value of the transaction amount
748: --
749: -- bug4345353 added the function fnd_number.number_to_canonical
750: IF(CE_CASH_FCST.G_trx_type <> 'OEO')THEN

Line 1085: ce_currency_rates_temp curr

1081: INTO l_end_of_day
1082: FROM gl_daily_balances gdb,
1083: gl_sets_of_books org,
1084: gl_code_combinations glcc,
1085: ce_currency_rates_temp curr
1086: WHERE curr.forecast_request_id = CE_CASH_FCST.G_forecast_id
1087: AND curr.currency_code = gdb.currency_code
1088: AND gdb.period_name = l_period_name
1089: AND gdb.currency_code = org.currency_code

Line 1157: ce_currency_rates_temp curr

1153: FROM gl_balances src,
1154: gl_sets_of_books org,
1155: gl_periods gp,
1156: gl_code_combinations glcc,
1157: ce_currency_rates_temp curr
1158: WHERE curr.forecast_request_id = CE_CASH_FCST.G_forecast_id
1159: AND curr.currency_code = src.currency_code
1160: AND src.period_name = gp.period_name
1161: AND src.currency_code = DECODE(CE_CASH_FCST.G_rp_src_curr_type,

Line 1198: ce_currency_rates_temp curr

1194: FROM gl_je_lines jl,
1195: gl_je_headers jh,
1196: gl_sets_of_books org,
1197: gl_code_combinations glcc,
1198: ce_currency_rates_temp curr
1199: WHERE curr.forecast_request_id = CE_CASH_FCST.G_forecast_id
1200: AND curr.currency_code = jh.currency_code
1201: AND jl.effective_date <= CE_CASH_FCST.G_rp_forecast_start_date
1202: AND jl.status = 'P'

Line 1235: ce_currency_rates_temp curr

1231: INTO initial_cash_pos
1232: FROM gl_balances src,
1233: gl_sets_of_books org,
1234: gl_code_combinations glcc,
1235: ce_currency_rates_temp curr
1236: WHERE curr.forecast_request_id = CE_CASH_FCST.G_forecast_id
1237: AND curr.currency_code = src.currency_code
1238: AND src.period_name = CE_CASH_FCST.G_rp_forecast_start_period
1239: AND org.period_set_name = CE_CASH_FCST.G_rp_calendar_name

Line 1423: from ce_currency_rates_temp

1419: cep_standard.debug('>>Bank Account currency conversion');
1420:
1421: select exchange_rate
1422: into l_exchange_rate
1423: from ce_currency_rates_temp
1424: where currency_code = l_bank_acc_curr
1425: and to_currency = CE_CASH_FCST.G_rp_forecast_currency
1426: and forecast_request_id = CE_CASH_FCST.G_forecast_id;
1427:

Line 1511: ce_currency_rates_temp curr

1507: ELSE
1508: SELECT SUM(src.amount*curr.exchange_rate)
1509: INTO l_app_cflow
1510: FROM ce_ap_fc_payments_v src,
1511: ce_currency_rates_temp curr
1512: WHERE src.bank_account_id = p_bank.bank_account_id
1513: AND src.payment_date >= l_balance_date
1514: AND src.payment_date < l_fc_start_date
1515: AND curr.forecast_request_id = CE_CASH_FCST.G_forecast_id

Line 1522: ce_currency_rates_temp curr

1518:
1519: SELECT SUM(src.amount*curr.exchange_rate)
1520: INTO l_arr_cflow
1521: FROM ce_ar_fc_receipts_v src,
1522: ce_currency_rates_temp curr
1523: WHERE src.bank_account_id = p_bank.bank_account_id
1524: AND src.cash_activity_date >= l_balance_date
1525: AND src.cash_activity_date < l_fc_start_date
1526: AND curr.forecast_request_id = CE_CASH_FCST.G_forecast_id

Line 1533: ce_currency_rates_temp curr

1529:
1530: SELECT SUM(src.amount*curr.exchange_rate)
1531: INTO l_xtr_cflow
1532: FROM ce_xtr_cashflows_v src,
1533: ce_currency_rates_temp curr
1534: WHERE src.bank_account_id = p_bank.bank_account_id
1535: AND src.trx_date >= l_balance_date
1536: AND src.trx_date < l_fc_start_date
1537: AND curr.forecast_request_id = CE_CASH_FCST.G_forecast_id

Line 1544: ce_currency_rates_temp curr

1540:
1541: SELECT SUM(src.amount*curr.exchange_rate)
1542: INTO l_pay_cflow
1543: FROM ce_pay_fc_payroll_v src,
1544: ce_currency_rates_temp curr
1545: WHERE src.bank_account_id = p_bank.bank_account_id
1546: AND src.trx_date >= l_balance_date
1547: AND src.trx_date < l_fc_start_date
1548: AND curr.forecast_request_id = CE_CASH_FCST.G_forecast_id

Line 1658: from ce_currency_rates_temp

1654: cep_standard.debug('>>Subsidiary Bank Account currency conversion');
1655:
1656: select exchange_rate
1657: into l_exchange_rate
1658: from ce_currency_rates_temp
1659: where currency_code = p_sub_acct.currency_code
1660: and to_currency = CE_CASH_FCST.G_rp_forecast_currency
1661: and forecast_request_id = CE_CASH_FCST.G_forecast_id;
1662:

Line 2586: ce_currency_rates_temp curr ';

2582:
2583: IF( CE_CASH_FCST.G_rp_exchange_type <> 'User' OR
2584: CE_CASH_FCST.G_rp_exchange_type IS NULL)THEN
2585: main_query := main_query || ',
2586: ce_currency_rates_temp curr ';
2587: END IF;
2588:
2589: main_query := main_query || '
2590: WHERE gp.start_date(+) = cab.start_date

Line 2852: FROM ce_currency_rates_temp

2848: AND org_id = p_org_id;
2849:
2850: CURSOR C_rate(p_currency_code VARCHAR2) IS
2851: SELECT exchange_rate
2852: FROM ce_currency_rates_temp
2853: WHERE forecast_request_id = CE_CASH_FCST.G_forecast_id
2854: AND to_currency = CE_CASH_FCST.G_rp_forecast_currency
2855: AND currency_code = p_currency_code;
2856:

Line 3817: FROM ce_currency_rates_temp

3813: AND org_id = p_org_id;
3814:
3815: CURSOR C_rate(p_currency_code VARCHAR2) IS
3816: SELECT exchange_rate
3817: FROM ce_currency_rates_temp
3818: WHERE forecast_request_id = CE_CASH_FCST.G_forecast_id
3819: AND to_currency = CE_CASH_FCST.G_rp_forecast_currency
3820: AND currency_code = p_currency_code;
3821:

Line 4942: FROM ce_currency_rates_temp

4938: AND org_id = p_org_id;
4939:
4940: CURSOR C_rate(p_currency_code VARCHAR2) IS
4941: SELECT exchange_rate
4942: FROM ce_currency_rates_temp
4943: WHERE forecast_request_id = CE_CASH_FCST.G_forecast_id
4944: AND to_currency = CE_CASH_FCST.G_rp_forecast_currency
4945: AND currency_code = p_currency_code;
4946:

Line 5233: FROM ce_currency_rates_temp

5229: conversion_table CE_FORECAST_REMOTE_SOURCES.ConversionTab'||db_link||';
5230: amount_table CE_FORECAST_REMOTE_SOURCES.AmountTab'||db_link||';
5231:
5232: CURSOR conversion_cursor IS SELECT currency_code, exchange_rate
5233: FROM ce_currency_rates_temp
5234: WHERE forecast_request_id = CE_CASH_FCST.G_forecast_id; ';
5235:
5236: IF( db_link IS NOT NULL )THEN
5237: main_query := main_query ||'