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 CE_STATEMENT_LINES

Line 88: csl_statement_line_id CE_STATEMENT_LINES.statement_line_id%TYPE;

84: --
85: -- Statement Lines
86: --
87: csl_rowid VARCHAR2(100);
88: csl_statement_line_id CE_STATEMENT_LINES.statement_line_id%TYPE;
89: csl_line_number CE_STATEMENT_LINES.line_number%TYPE;
90: csl_trx_date CE_STATEMENT_LINES.trx_date%TYPE;
91: csl_trx_type CE_STATEMENT_LINES.trx_type%TYPE;
92: csl_trx_code_id CE_STATEMENT_LINES.trx_code_id%TYPE;

Line 89: csl_line_number CE_STATEMENT_LINES.line_number%TYPE;

85: -- Statement Lines
86: --
87: csl_rowid VARCHAR2(100);
88: csl_statement_line_id CE_STATEMENT_LINES.statement_line_id%TYPE;
89: csl_line_number CE_STATEMENT_LINES.line_number%TYPE;
90: csl_trx_date CE_STATEMENT_LINES.trx_date%TYPE;
91: csl_trx_type CE_STATEMENT_LINES.trx_type%TYPE;
92: csl_trx_code_id CE_STATEMENT_LINES.trx_code_id%TYPE;
93: csl_bank_trx_number CE_STATEMENT_LINES.bank_trx_number%TYPE;

Line 90: csl_trx_date CE_STATEMENT_LINES.trx_date%TYPE;

86: --
87: csl_rowid VARCHAR2(100);
88: csl_statement_line_id CE_STATEMENT_LINES.statement_line_id%TYPE;
89: csl_line_number CE_STATEMENT_LINES.line_number%TYPE;
90: csl_trx_date CE_STATEMENT_LINES.trx_date%TYPE;
91: csl_trx_type CE_STATEMENT_LINES.trx_type%TYPE;
92: csl_trx_code_id CE_STATEMENT_LINES.trx_code_id%TYPE;
93: csl_bank_trx_number CE_STATEMENT_LINES.bank_trx_number%TYPE;
94: csl_invoice_text CE_STATEMENT_LINES.invoice_text%TYPE;

Line 91: csl_trx_type CE_STATEMENT_LINES.trx_type%TYPE;

87: csl_rowid VARCHAR2(100);
88: csl_statement_line_id CE_STATEMENT_LINES.statement_line_id%TYPE;
89: csl_line_number CE_STATEMENT_LINES.line_number%TYPE;
90: csl_trx_date CE_STATEMENT_LINES.trx_date%TYPE;
91: csl_trx_type CE_STATEMENT_LINES.trx_type%TYPE;
92: csl_trx_code_id CE_STATEMENT_LINES.trx_code_id%TYPE;
93: csl_bank_trx_number CE_STATEMENT_LINES.bank_trx_number%TYPE;
94: csl_invoice_text CE_STATEMENT_LINES.invoice_text%TYPE;
95: csl_bank_account_text CE_STATEMENT_LINES.bank_account_text%TYPE;

Line 92: csl_trx_code_id CE_STATEMENT_LINES.trx_code_id%TYPE;

88: csl_statement_line_id CE_STATEMENT_LINES.statement_line_id%TYPE;
89: csl_line_number CE_STATEMENT_LINES.line_number%TYPE;
90: csl_trx_date CE_STATEMENT_LINES.trx_date%TYPE;
91: csl_trx_type CE_STATEMENT_LINES.trx_type%TYPE;
92: csl_trx_code_id CE_STATEMENT_LINES.trx_code_id%TYPE;
93: csl_bank_trx_number CE_STATEMENT_LINES.bank_trx_number%TYPE;
94: csl_invoice_text CE_STATEMENT_LINES.invoice_text%TYPE;
95: csl_bank_account_text CE_STATEMENT_LINES.bank_account_text%TYPE;
96: csl_amount CE_STATEMENT_LINES.amount%TYPE;

Line 93: csl_bank_trx_number CE_STATEMENT_LINES.bank_trx_number%TYPE;

89: csl_line_number CE_STATEMENT_LINES.line_number%TYPE;
90: csl_trx_date CE_STATEMENT_LINES.trx_date%TYPE;
91: csl_trx_type CE_STATEMENT_LINES.trx_type%TYPE;
92: csl_trx_code_id CE_STATEMENT_LINES.trx_code_id%TYPE;
93: csl_bank_trx_number CE_STATEMENT_LINES.bank_trx_number%TYPE;
94: csl_invoice_text CE_STATEMENT_LINES.invoice_text%TYPE;
95: csl_bank_account_text CE_STATEMENT_LINES.bank_account_text%TYPE;
96: csl_amount CE_STATEMENT_LINES.amount%TYPE;
97: csl_charges_amount CE_STATEMENT_LINES.charges_amount%TYPE;

Line 94: csl_invoice_text CE_STATEMENT_LINES.invoice_text%TYPE;

90: csl_trx_date CE_STATEMENT_LINES.trx_date%TYPE;
91: csl_trx_type CE_STATEMENT_LINES.trx_type%TYPE;
92: csl_trx_code_id CE_STATEMENT_LINES.trx_code_id%TYPE;
93: csl_bank_trx_number CE_STATEMENT_LINES.bank_trx_number%TYPE;
94: csl_invoice_text CE_STATEMENT_LINES.invoice_text%TYPE;
95: csl_bank_account_text CE_STATEMENT_LINES.bank_account_text%TYPE;
96: csl_amount CE_STATEMENT_LINES.amount%TYPE;
97: csl_charges_amount CE_STATEMENT_LINES.charges_amount%TYPE;
98: corr_csl_amount CE_STATEMENT_LINES.amount%TYPE;

Line 95: csl_bank_account_text CE_STATEMENT_LINES.bank_account_text%TYPE;

91: csl_trx_type CE_STATEMENT_LINES.trx_type%TYPE;
92: csl_trx_code_id CE_STATEMENT_LINES.trx_code_id%TYPE;
93: csl_bank_trx_number CE_STATEMENT_LINES.bank_trx_number%TYPE;
94: csl_invoice_text CE_STATEMENT_LINES.invoice_text%TYPE;
95: csl_bank_account_text CE_STATEMENT_LINES.bank_account_text%TYPE;
96: csl_amount CE_STATEMENT_LINES.amount%TYPE;
97: csl_charges_amount CE_STATEMENT_LINES.charges_amount%TYPE;
98: corr_csl_amount CE_STATEMENT_LINES.amount%TYPE;
99: calc_csl_amount CE_STATEMENT_LINES.amount%TYPE;

Line 96: csl_amount CE_STATEMENT_LINES.amount%TYPE;

92: csl_trx_code_id CE_STATEMENT_LINES.trx_code_id%TYPE;
93: csl_bank_trx_number CE_STATEMENT_LINES.bank_trx_number%TYPE;
94: csl_invoice_text CE_STATEMENT_LINES.invoice_text%TYPE;
95: csl_bank_account_text CE_STATEMENT_LINES.bank_account_text%TYPE;
96: csl_amount CE_STATEMENT_LINES.amount%TYPE;
97: csl_charges_amount CE_STATEMENT_LINES.charges_amount%TYPE;
98: corr_csl_amount CE_STATEMENT_LINES.amount%TYPE;
99: calc_csl_amount CE_STATEMENT_LINES.amount%TYPE;
100: csl_receivables_trx_id CE_TRANSACTION_CODES.receivables_trx_id%TYPE;

Line 97: csl_charges_amount CE_STATEMENT_LINES.charges_amount%TYPE;

93: csl_bank_trx_number CE_STATEMENT_LINES.bank_trx_number%TYPE;
94: csl_invoice_text CE_STATEMENT_LINES.invoice_text%TYPE;
95: csl_bank_account_text CE_STATEMENT_LINES.bank_account_text%TYPE;
96: csl_amount CE_STATEMENT_LINES.amount%TYPE;
97: csl_charges_amount CE_STATEMENT_LINES.charges_amount%TYPE;
98: corr_csl_amount CE_STATEMENT_LINES.amount%TYPE;
99: calc_csl_amount CE_STATEMENT_LINES.amount%TYPE;
100: csl_receivables_trx_id CE_TRANSACTION_CODES.receivables_trx_id%TYPE;
101: csl_receipt_method_id CE_TRANSACTION_CODES.receipt_method_id%TYPE;

Line 98: corr_csl_amount CE_STATEMENT_LINES.amount%TYPE;

94: csl_invoice_text CE_STATEMENT_LINES.invoice_text%TYPE;
95: csl_bank_account_text CE_STATEMENT_LINES.bank_account_text%TYPE;
96: csl_amount CE_STATEMENT_LINES.amount%TYPE;
97: csl_charges_amount CE_STATEMENT_LINES.charges_amount%TYPE;
98: corr_csl_amount CE_STATEMENT_LINES.amount%TYPE;
99: calc_csl_amount CE_STATEMENT_LINES.amount%TYPE;
100: csl_receivables_trx_id CE_TRANSACTION_CODES.receivables_trx_id%TYPE;
101: csl_receipt_method_id CE_TRANSACTION_CODES.receipt_method_id%TYPE;
102: csl_create_misc_trx_flag CE_TRANSACTION_CODES.create_misc_trx_flag%TYPE;

Line 99: calc_csl_amount CE_STATEMENT_LINES.amount%TYPE;

95: csl_bank_account_text CE_STATEMENT_LINES.bank_account_text%TYPE;
96: csl_amount CE_STATEMENT_LINES.amount%TYPE;
97: csl_charges_amount CE_STATEMENT_LINES.charges_amount%TYPE;
98: corr_csl_amount CE_STATEMENT_LINES.amount%TYPE;
99: calc_csl_amount CE_STATEMENT_LINES.amount%TYPE;
100: csl_receivables_trx_id CE_TRANSACTION_CODES.receivables_trx_id%TYPE;
101: csl_receipt_method_id CE_TRANSACTION_CODES.receipt_method_id%TYPE;
102: csl_create_misc_trx_flag CE_TRANSACTION_CODES.create_misc_trx_flag%TYPE;
103: csl_matching_against CE_TRANSACTION_CODES.matching_against%TYPE;

Line 108: csl_line_trx_type CE_STATEMENT_LINES.trx_type%TYPE;

104: csl_correction_method CE_TRANSACTION_CODES.correction_method%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;

Line 113: csl_original_amount CE_STATEMENT_LINES.original_amount%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;
116: csl_customer_text CE_STATEMENT_LINES.customer_text%TYPE;
117: csl_effective_date CE_STATEMENT_LINES.effective_date%TYPE;

Line 116: csl_customer_text CE_STATEMENT_LINES.customer_text%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;
116: csl_customer_text CE_STATEMENT_LINES.customer_text%TYPE;
117: csl_effective_date CE_STATEMENT_LINES.effective_date%TYPE;
118: csl_je_status_flag CE_STATEMENT_LINES.je_status_flag%TYPE;
119: csl_accounting_date CE_STATEMENT_LINES.accounting_date%TYPE;
120: csl_cashflow_id CE_STATEMENT_LINES.cashflow_id%TYPE;

Line 117: csl_effective_date CE_STATEMENT_LINES.effective_date%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;
116: csl_customer_text CE_STATEMENT_LINES.customer_text%TYPE;
117: csl_effective_date CE_STATEMENT_LINES.effective_date%TYPE;
118: csl_je_status_flag CE_STATEMENT_LINES.je_status_flag%TYPE;
119: csl_accounting_date CE_STATEMENT_LINES.accounting_date%TYPE;
120: csl_cashflow_id CE_STATEMENT_LINES.cashflow_id%TYPE;
121:

Line 118: csl_je_status_flag CE_STATEMENT_LINES.je_status_flag%TYPE;

114: csl_payroll_payment_format PAY_PAYMENT_TYPES.payment_type_name%TYPE;
115: csl_clearing_trx_type FND_LOOKUP_VALUES.lookup_code%TYPE;
116: csl_customer_text CE_STATEMENT_LINES.customer_text%TYPE;
117: csl_effective_date CE_STATEMENT_LINES.effective_date%TYPE;
118: csl_je_status_flag CE_STATEMENT_LINES.je_status_flag%TYPE;
119: csl_accounting_date CE_STATEMENT_LINES.accounting_date%TYPE;
120: csl_cashflow_id CE_STATEMENT_LINES.cashflow_id%TYPE;
121:
122: reconcile_to_statement_flag CE_STATEMENT_LINES.reconcile_to_statement_flag%TYPE;

Line 119: csl_accounting_date CE_STATEMENT_LINES.accounting_date%TYPE;

115: csl_clearing_trx_type FND_LOOKUP_VALUES.lookup_code%TYPE;
116: csl_customer_text CE_STATEMENT_LINES.customer_text%TYPE;
117: csl_effective_date CE_STATEMENT_LINES.effective_date%TYPE;
118: csl_je_status_flag CE_STATEMENT_LINES.je_status_flag%TYPE;
119: csl_accounting_date CE_STATEMENT_LINES.accounting_date%TYPE;
120: csl_cashflow_id CE_STATEMENT_LINES.cashflow_id%TYPE;
121:
122: reconcile_to_statement_flag CE_STATEMENT_LINES.reconcile_to_statement_flag%TYPE;
123: foreign_exchange_defaulted VARCHAR2(1) DEFAULT 'N';

Line 120: csl_cashflow_id CE_STATEMENT_LINES.cashflow_id%TYPE;

116: csl_customer_text CE_STATEMENT_LINES.customer_text%TYPE;
117: csl_effective_date CE_STATEMENT_LINES.effective_date%TYPE;
118: csl_je_status_flag CE_STATEMENT_LINES.je_status_flag%TYPE;
119: csl_accounting_date CE_STATEMENT_LINES.accounting_date%TYPE;
120: csl_cashflow_id CE_STATEMENT_LINES.cashflow_id%TYPE;
121:
122: reconcile_to_statement_flag CE_STATEMENT_LINES.reconcile_to_statement_flag%TYPE;
123: foreign_exchange_defaulted VARCHAR2(1) DEFAULT 'N';
124: csl_event_id NUMBER(15);

Line 122: reconcile_to_statement_flag CE_STATEMENT_LINES.reconcile_to_statement_flag%TYPE;

118: csl_je_status_flag CE_STATEMENT_LINES.je_status_flag%TYPE;
119: csl_accounting_date CE_STATEMENT_LINES.accounting_date%TYPE;
120: csl_cashflow_id CE_STATEMENT_LINES.cashflow_id%TYPE;
121:
122: reconcile_to_statement_flag CE_STATEMENT_LINES.reconcile_to_statement_flag%TYPE;
123: foreign_exchange_defaulted VARCHAR2(1) DEFAULT 'N';
124: csl_event_id NUMBER(15);
125:
126: --

Line 140: trx_errors_amount CE_STATEMENT_LINES.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;
144: trx_exchange_rate_date GL_DAILY_RATES.conversion_date%TYPE;

Line 141: trx_charges_amount CE_STATEMENT_LINES.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;
144: trx_exchange_rate_date GL_DAILY_RATES.conversion_date%TYPE;
145: trx_exchange_rate GL_DAILY_RATES.conversion_rate%TYPE;

Line 142: trx_prorate_amount CE_STATEMENT_LINES.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;
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;

Line 161: trx_id2 CE_STATEMENT_LINES.statement_line_id%TYPE;

157: LOGICAL_GROUP_REFERENCE IBY_PAYMENTS_ALL.LOGICAL_GROUP_REFERENCE%type; -- FOR SEPA ER 6700007
158: --
159: -- Adjustment Statement lines
160: --
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;

Line 171: trx_errors_amount2 CE_STATEMENT_LINES.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;
175: trx_exchange_rate_date2 GL_DAILY_RATES.conversion_date%TYPE;

Line 172: trx_charges_amount2 CE_STATEMENT_LINES.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;
175: trx_exchange_rate_date2 GL_DAILY_RATES.conversion_date%TYPE;
176: trx_type2 FND_LOOKUP_VALUES.lookup_code%TYPE;

Line 173: trx_prorate_amount2 CE_STATEMENT_LINES.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;
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;

Line 188: tolerance_amount CE_STATEMENT_LINES.amount%TYPE;

184: csl_match_type2 FND_LOOKUP_VALUES.lookup_code%TYPE;
185: trx_match_type FND_LOOKUP_VALUES.lookup_code%TYPE;
186: csl_match_correction_type FND_LOOKUP_VALUES.lookup_code%TYPE;
187: reconciled_this_run VARCHAR2(1);
188: tolerance_amount CE_STATEMENT_LINES.amount%TYPE;
189: acctd_exchange_rate CE_STATEMENT_LINES.exchange_rate%TYPE;
190: nsf_info_flag VARCHAR2(1) DEFAULT 'N';
191: trx_clr_flag VARCHAR2(1) DEFAULT 'N';
192:

Line 189: acctd_exchange_rate CE_STATEMENT_LINES.exchange_rate%TYPE;

185: trx_match_type FND_LOOKUP_VALUES.lookup_code%TYPE;
186: csl_match_correction_type FND_LOOKUP_VALUES.lookup_code%TYPE;
187: reconciled_this_run VARCHAR2(1);
188: tolerance_amount CE_STATEMENT_LINES.amount%TYPE;
189: acctd_exchange_rate CE_STATEMENT_LINES.exchange_rate%TYPE;
190: nsf_info_flag VARCHAR2(1) DEFAULT 'N';
191: trx_clr_flag VARCHAR2(1) DEFAULT 'N';
192:
193: --