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_MATCH dependencies on GL_DAILY_RATES

Line 109: csl_exchange_rate_type GL_DAILY_RATES.conversion_type%TYPE;

105: csl_reconcile_flag CE_TRANSACTION_CODES.reconcile_flag%TYPE;
106: csl_receipt_method_name AR_RECEIPT_METHODS.name%TYPE;
107: csl_currency_code FND_CURRENCIES.currency_code%TYPE;
108: csl_line_trx_type CE_STATEMENT_LINES.trx_type%TYPE;
109: csl_exchange_rate_type GL_DAILY_RATES.conversion_type%TYPE;
110: csl_exchange_rate_date GL_DAILY_RATES.conversion_date%TYPE;
111: csl_exchange_rate GL_DAILY_RATES.conversion_rate%TYPE;
112: csl_match_found FND_LOOKUP_VALUES.lookup_code%TYPE;
113: csl_original_amount CE_STATEMENT_LINES.original_amount%TYPE;

Line 110: csl_exchange_rate_date GL_DAILY_RATES.conversion_date%TYPE;

106: csl_receipt_method_name AR_RECEIPT_METHODS.name%TYPE;
107: csl_currency_code FND_CURRENCIES.currency_code%TYPE;
108: csl_line_trx_type CE_STATEMENT_LINES.trx_type%TYPE;
109: csl_exchange_rate_type GL_DAILY_RATES.conversion_type%TYPE;
110: csl_exchange_rate_date GL_DAILY_RATES.conversion_date%TYPE;
111: csl_exchange_rate GL_DAILY_RATES.conversion_rate%TYPE;
112: csl_match_found FND_LOOKUP_VALUES.lookup_code%TYPE;
113: csl_original_amount CE_STATEMENT_LINES.original_amount%TYPE;
114: csl_payroll_payment_format PAY_PAYMENT_TYPES.payment_type_name%TYPE;

Line 111: csl_exchange_rate GL_DAILY_RATES.conversion_rate%TYPE;

107: csl_currency_code FND_CURRENCIES.currency_code%TYPE;
108: csl_line_trx_type CE_STATEMENT_LINES.trx_type%TYPE;
109: csl_exchange_rate_type GL_DAILY_RATES.conversion_type%TYPE;
110: csl_exchange_rate_date GL_DAILY_RATES.conversion_date%TYPE;
111: csl_exchange_rate GL_DAILY_RATES.conversion_rate%TYPE;
112: csl_match_found FND_LOOKUP_VALUES.lookup_code%TYPE;
113: csl_original_amount CE_STATEMENT_LINES.original_amount%TYPE;
114: csl_payroll_payment_format PAY_PAYMENT_TYPES.payment_type_name%TYPE;
115: csl_clearing_trx_type FND_LOOKUP_VALUES.lookup_code%TYPE;

Line 143: trx_exchange_rate_type GL_DAILY_RATES.conversion_type%TYPE;

139: trx_status AR_CASH_RECEIPT_HISTORY_ALL.status%TYPE;
140: trx_errors_amount CE_STATEMENT_LINES.amount%TYPE;
141: trx_charges_amount CE_STATEMENT_LINES.amount%TYPE;
142: trx_prorate_amount CE_STATEMENT_LINES.amount%TYPE;
143: trx_exchange_rate_type GL_DAILY_RATES.conversion_type%TYPE;
144: trx_exchange_rate_date GL_DAILY_RATES.conversion_date%TYPE;
145: trx_exchange_rate GL_DAILY_RATES.conversion_rate%TYPE;
146: trx_customer_id NUMBER; --RA_CUSTOMERS.customer_id%TYPE;
147: reversed_receipt_flag VARCHAR2(1);

Line 144: trx_exchange_rate_date GL_DAILY_RATES.conversion_date%TYPE;

140: trx_errors_amount CE_STATEMENT_LINES.amount%TYPE;
141: trx_charges_amount CE_STATEMENT_LINES.amount%TYPE;
142: trx_prorate_amount CE_STATEMENT_LINES.amount%TYPE;
143: trx_exchange_rate_type GL_DAILY_RATES.conversion_type%TYPE;
144: trx_exchange_rate_date GL_DAILY_RATES.conversion_date%TYPE;
145: trx_exchange_rate GL_DAILY_RATES.conversion_rate%TYPE;
146: trx_customer_id NUMBER; --RA_CUSTOMERS.customer_id%TYPE;
147: reversed_receipt_flag VARCHAR2(1);
148: trx_gl_date DATE;

Line 145: trx_exchange_rate GL_DAILY_RATES.conversion_rate%TYPE;

141: trx_charges_amount CE_STATEMENT_LINES.amount%TYPE;
142: trx_prorate_amount CE_STATEMENT_LINES.amount%TYPE;
143: trx_exchange_rate_type GL_DAILY_RATES.conversion_type%TYPE;
144: trx_exchange_rate_date GL_DAILY_RATES.conversion_date%TYPE;
145: trx_exchange_rate GL_DAILY_RATES.conversion_rate%TYPE;
146: trx_customer_id NUMBER; --RA_CUSTOMERS.customer_id%TYPE;
147: reversed_receipt_flag VARCHAR2(1);
148: trx_gl_date DATE;
149: trx_group VARCHAR2(100);

Line 174: trx_exchange_rate_type2 GL_DAILY_RATES.conversion_type%TYPE;

170: trx_status2 AR_CASH_RECEIPT_HISTORY_ALL.status%TYPE;
171: trx_errors_amount2 CE_STATEMENT_LINES.amount%TYPE;
172: trx_charges_amount2 CE_STATEMENT_LINES.amount%TYPE;
173: trx_prorate_amount2 CE_STATEMENT_LINES.amount%TYPE;
174: trx_exchange_rate_type2 GL_DAILY_RATES.conversion_type%TYPE;
175: trx_exchange_rate_date2 GL_DAILY_RATES.conversion_date%TYPE;
176: trx_type2 FND_LOOKUP_VALUES.lookup_code%TYPE;
177: trx_exchange_rate2 GL_DAILY_RATES.conversion_rate%TYPE;
178: --

Line 175: trx_exchange_rate_date2 GL_DAILY_RATES.conversion_date%TYPE;

171: trx_errors_amount2 CE_STATEMENT_LINES.amount%TYPE;
172: trx_charges_amount2 CE_STATEMENT_LINES.amount%TYPE;
173: trx_prorate_amount2 CE_STATEMENT_LINES.amount%TYPE;
174: trx_exchange_rate_type2 GL_DAILY_RATES.conversion_type%TYPE;
175: trx_exchange_rate_date2 GL_DAILY_RATES.conversion_date%TYPE;
176: trx_type2 FND_LOOKUP_VALUES.lookup_code%TYPE;
177: trx_exchange_rate2 GL_DAILY_RATES.conversion_rate%TYPE;
178: --
179: -- csl_match_type is blank when there is no matching transaction

Line 177: trx_exchange_rate2 GL_DAILY_RATES.conversion_rate%TYPE;

173: trx_prorate_amount2 CE_STATEMENT_LINES.amount%TYPE;
174: trx_exchange_rate_type2 GL_DAILY_RATES.conversion_type%TYPE;
175: trx_exchange_rate_date2 GL_DAILY_RATES.conversion_date%TYPE;
176: trx_type2 FND_LOOKUP_VALUES.lookup_code%TYPE;
177: trx_exchange_rate2 GL_DAILY_RATES.conversion_rate%TYPE;
178: --
179: -- csl_match_type is blank when there is no matching transaction
180: -- it is one of the following when the match is found:
181: --