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 AR_CASH_RECEIPT_HISTORY_ALL

Line 129: trx_id AR_CASH_RECEIPT_HISTORY_ALL.cash_receipt_history_id%TYPE;

125:
126: --
127: -- Transactions
128: --
129: trx_id AR_CASH_RECEIPT_HISTORY_ALL.cash_receipt_history_id%TYPE;
130: trx_cash_receipt_id AR_CASH_RECEIPT_HISTORY_ALL.cash_receipt_id%TYPE;
131: trx_rowid VARCHAR2(100);
132: trx_date DATE;
133: trx_currency_code FND_CURRENCIES.currency_code%TYPE;

Line 130: trx_cash_receipt_id AR_CASH_RECEIPT_HISTORY_ALL.cash_receipt_id%TYPE;

126: --
127: -- Transactions
128: --
129: trx_id AR_CASH_RECEIPT_HISTORY_ALL.cash_receipt_history_id%TYPE;
130: trx_cash_receipt_id AR_CASH_RECEIPT_HISTORY_ALL.cash_receipt_id%TYPE;
131: trx_rowid VARCHAR2(100);
132: trx_date DATE;
133: trx_currency_code FND_CURRENCIES.currency_code%TYPE;
134: trx_amount AR_CASH_RECEIPT_HISTORY_ALL.amount%TYPE;

Line 134: trx_amount AR_CASH_RECEIPT_HISTORY_ALL.amount%TYPE;

130: trx_cash_receipt_id AR_CASH_RECEIPT_HISTORY_ALL.cash_receipt_id%TYPE;
131: trx_rowid VARCHAR2(100);
132: trx_date DATE;
133: trx_currency_code FND_CURRENCIES.currency_code%TYPE;
134: trx_amount AR_CASH_RECEIPT_HISTORY_ALL.amount%TYPE;
135: trx_base_amount AR_CASH_RECEIPT_HISTORY_ALL.acctd_amount%TYPE;
136: trx_cleared_amount AR_CASH_RECEIPT_HISTORY_ALL.amount%TYPE;
137: trx_curr_amount AR_CASH_RECEIPT_HISTORY_ALL.amount%TYPE;
138: trx_currency_type FND_LOOKUP_VALUES.lookup_code%TYPE;

Line 135: trx_base_amount AR_CASH_RECEIPT_HISTORY_ALL.acctd_amount%TYPE;

131: trx_rowid VARCHAR2(100);
132: trx_date DATE;
133: trx_currency_code FND_CURRENCIES.currency_code%TYPE;
134: trx_amount AR_CASH_RECEIPT_HISTORY_ALL.amount%TYPE;
135: trx_base_amount AR_CASH_RECEIPT_HISTORY_ALL.acctd_amount%TYPE;
136: trx_cleared_amount AR_CASH_RECEIPT_HISTORY_ALL.amount%TYPE;
137: trx_curr_amount AR_CASH_RECEIPT_HISTORY_ALL.amount%TYPE;
138: trx_currency_type FND_LOOKUP_VALUES.lookup_code%TYPE;
139: trx_status AR_CASH_RECEIPT_HISTORY_ALL.status%TYPE;

Line 136: trx_cleared_amount AR_CASH_RECEIPT_HISTORY_ALL.amount%TYPE;

132: trx_date DATE;
133: trx_currency_code FND_CURRENCIES.currency_code%TYPE;
134: trx_amount AR_CASH_RECEIPT_HISTORY_ALL.amount%TYPE;
135: trx_base_amount AR_CASH_RECEIPT_HISTORY_ALL.acctd_amount%TYPE;
136: trx_cleared_amount AR_CASH_RECEIPT_HISTORY_ALL.amount%TYPE;
137: trx_curr_amount AR_CASH_RECEIPT_HISTORY_ALL.amount%TYPE;
138: trx_currency_type FND_LOOKUP_VALUES.lookup_code%TYPE;
139: trx_status AR_CASH_RECEIPT_HISTORY_ALL.status%TYPE;
140: trx_errors_amount CE_STATEMENT_LINES.amount%TYPE;

Line 137: trx_curr_amount AR_CASH_RECEIPT_HISTORY_ALL.amount%TYPE;

133: trx_currency_code FND_CURRENCIES.currency_code%TYPE;
134: trx_amount AR_CASH_RECEIPT_HISTORY_ALL.amount%TYPE;
135: trx_base_amount AR_CASH_RECEIPT_HISTORY_ALL.acctd_amount%TYPE;
136: trx_cleared_amount AR_CASH_RECEIPT_HISTORY_ALL.amount%TYPE;
137: trx_curr_amount AR_CASH_RECEIPT_HISTORY_ALL.amount%TYPE;
138: trx_currency_type FND_LOOKUP_VALUES.lookup_code%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;

Line 139: trx_status AR_CASH_RECEIPT_HISTORY_ALL.status%TYPE;

135: trx_base_amount AR_CASH_RECEIPT_HISTORY_ALL.acctd_amount%TYPE;
136: trx_cleared_amount AR_CASH_RECEIPT_HISTORY_ALL.amount%TYPE;
137: trx_curr_amount AR_CASH_RECEIPT_HISTORY_ALL.amount%TYPE;
138: trx_currency_type FND_LOOKUP_VALUES.lookup_code%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;

Line 165: trx_amount2 AR_CASH_RECEIPT_HISTORY_ALL.amount%TYPE;

161: trx_id2 CE_STATEMENT_LINES.statement_line_id%TYPE;
162: trx_rowid2 VARCHAR2(100);
163: trx_date2 DATE;
164: trx_currency_code2 FND_CURRENCIES.currency_code%TYPE;
165: trx_amount2 AR_CASH_RECEIPT_HISTORY_ALL.amount%TYPE;
166: trx_base_amount2 AR_CASH_RECEIPT_HISTORY_ALL.acctd_amount%TYPE;
167: trx_cleared_amount2 AR_CASH_RECEIPT_HISTORY_ALL.amount%TYPE;
168: trx_curr_amount2 AR_CASH_RECEIPT_HISTORY_ALL.amount%TYPE;
169: trx_currency_type2 FND_LOOKUP_VALUES.lookup_code%TYPE;

Line 166: trx_base_amount2 AR_CASH_RECEIPT_HISTORY_ALL.acctd_amount%TYPE;

162: trx_rowid2 VARCHAR2(100);
163: trx_date2 DATE;
164: trx_currency_code2 FND_CURRENCIES.currency_code%TYPE;
165: trx_amount2 AR_CASH_RECEIPT_HISTORY_ALL.amount%TYPE;
166: trx_base_amount2 AR_CASH_RECEIPT_HISTORY_ALL.acctd_amount%TYPE;
167: trx_cleared_amount2 AR_CASH_RECEIPT_HISTORY_ALL.amount%TYPE;
168: trx_curr_amount2 AR_CASH_RECEIPT_HISTORY_ALL.amount%TYPE;
169: trx_currency_type2 FND_LOOKUP_VALUES.lookup_code%TYPE;
170: trx_status2 AR_CASH_RECEIPT_HISTORY_ALL.status%TYPE;

Line 167: trx_cleared_amount2 AR_CASH_RECEIPT_HISTORY_ALL.amount%TYPE;

163: trx_date2 DATE;
164: trx_currency_code2 FND_CURRENCIES.currency_code%TYPE;
165: trx_amount2 AR_CASH_RECEIPT_HISTORY_ALL.amount%TYPE;
166: trx_base_amount2 AR_CASH_RECEIPT_HISTORY_ALL.acctd_amount%TYPE;
167: trx_cleared_amount2 AR_CASH_RECEIPT_HISTORY_ALL.amount%TYPE;
168: trx_curr_amount2 AR_CASH_RECEIPT_HISTORY_ALL.amount%TYPE;
169: trx_currency_type2 FND_LOOKUP_VALUES.lookup_code%TYPE;
170: trx_status2 AR_CASH_RECEIPT_HISTORY_ALL.status%TYPE;
171: trx_errors_amount2 CE_STATEMENT_LINES.amount%TYPE;

Line 168: trx_curr_amount2 AR_CASH_RECEIPT_HISTORY_ALL.amount%TYPE;

164: trx_currency_code2 FND_CURRENCIES.currency_code%TYPE;
165: trx_amount2 AR_CASH_RECEIPT_HISTORY_ALL.amount%TYPE;
166: trx_base_amount2 AR_CASH_RECEIPT_HISTORY_ALL.acctd_amount%TYPE;
167: trx_cleared_amount2 AR_CASH_RECEIPT_HISTORY_ALL.amount%TYPE;
168: trx_curr_amount2 AR_CASH_RECEIPT_HISTORY_ALL.amount%TYPE;
169: trx_currency_type2 FND_LOOKUP_VALUES.lookup_code%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;

Line 170: trx_status2 AR_CASH_RECEIPT_HISTORY_ALL.status%TYPE;

166: trx_base_amount2 AR_CASH_RECEIPT_HISTORY_ALL.acctd_amount%TYPE;
167: trx_cleared_amount2 AR_CASH_RECEIPT_HISTORY_ALL.amount%TYPE;
168: trx_curr_amount2 AR_CASH_RECEIPT_HISTORY_ALL.amount%TYPE;
169: trx_currency_type2 FND_LOOKUP_VALUES.lookup_code%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;