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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;