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_AUTO_BANK_IMPORT dependencies on GL_DAILY_CONVERSION_TYPES

Line 149: gl_daily_conversion_types gt,

145: gt.conversion_type,
146: gt.user_conversion_type,
147: curr.currency_code
148: FROM fnd_currencies curr,
149: gl_daily_conversion_types gt,
150: ce_transaction_codes ctc,
151: ce_statement_lines_interface l
152: WHERE curr.currency_code(+) = l.currency_code
153: AND gt.user_conversion_type(+) = l.user_exchange_rate_type

Line 1015: gl_daily_conversion_types gdct,

1011: csli.attribute13,
1012: csli.attribute14,
1013: csli.attribute15
1014: FROM --ce_transaction_codes ctc,
1015: gl_daily_conversion_types gdct,
1016: ce_statement_lines_interface csli,
1017: ce_bank_accts_gt_v aba --ce_bank_accounts_v aba
1018: WHERE gdct.user_conversion_type(+) = csli.user_exchange_rate_type
1019: --AND ctc.trx_code(+) = csli.trx_code

Line 1845: r_user_conversion_type GL_DAILY_CONVERSION_TYPES.user_conversion_type%TYPE;

1841: csli_cr_sum CE_STATEMENT_LINES_INTERFACE.amount%TYPE;
1842: csli_dr_count CE_STATEMENT_LINES_INTERFACE.amount%TYPE;
1843: csli_cr_count CE_STATEMENT_LINES_INTERFACE.amount%TYPE;
1844: r_statement_number CE_STATEMENT_HEADERS.statement_number%TYPE;
1845: r_user_conversion_type GL_DAILY_CONVERSION_TYPES.user_conversion_type%TYPE;
1846: r_exchange_rate_type GL_DAILY_CONVERSION_TYPES.conversion_type%TYPE;
1847: r_currency_code FND_CURRENCIES.currency_code%TYPE;
1848: r_trx_code_id CE_TRANSACTION_CODES.transaction_code_id%TYPE;
1849: r_start_date CE_TRANSACTION_CODES.start_date%TYPE;

Line 1846: r_exchange_rate_type GL_DAILY_CONVERSION_TYPES.conversion_type%TYPE;

1842: csli_dr_count CE_STATEMENT_LINES_INTERFACE.amount%TYPE;
1843: csli_cr_count CE_STATEMENT_LINES_INTERFACE.amount%TYPE;
1844: r_statement_number CE_STATEMENT_HEADERS.statement_number%TYPE;
1845: r_user_conversion_type GL_DAILY_CONVERSION_TYPES.user_conversion_type%TYPE;
1846: r_exchange_rate_type GL_DAILY_CONVERSION_TYPES.conversion_type%TYPE;
1847: r_currency_code FND_CURRENCIES.currency_code%TYPE;
1848: r_trx_code_id CE_TRANSACTION_CODES.transaction_code_id%TYPE;
1849: r_start_date CE_TRANSACTION_CODES.start_date%TYPE;
1850: r_end_date CE_TRANSACTION_CODES.end_date%TYPE;