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 110: ce_statement_lines sl

106: FROM --pay_payment_types ppt,
107: --ar_receipt_methods rm,
108: ce_statement_headers sh,
109: ce_transaction_codes cd,
110: ce_statement_lines sl
111: WHERE --rm.receipt_method_id(+) = cd.receipt_method_id
112: --nvl(cd.RECONCILIATION_SEQUENCE (+) ,1) = 1
113: nvl(cd.RECONCILIATION_SEQUENCE ,1) =
114: (select nvl(min(tc.reconciliation_sequence),1)

Line 147: ce_statement_lines sl

143: ppt.payment_type_name
144: FROM pay_payment_types ppt,
145: ar_receipt_methods rm,
146: ce_transaction_codes cd,
147: ce_statement_lines sl
148: WHERE rm.receipt_method_id(+) = cd.receipt_method_id
149: --AND cd.transaction_code_id(+) = sl.trx_code_id
150: AND cd.trx_code (+) = sl.trx_code
151: AND cd.payroll_payment_format_id = ppt.payment_type_id (+)

Line 258: FROM ce_statement_lines cl,

254: -- Statement lines
255: --
256: CURSOR lock_260 (X_call_mode VARCHAR2,trx_rowid VARCHAR2) IS
257: SELECT cl.statement_line_id
258: FROM ce_statement_lines cl,
259: ce_statement_reconcils_all rec
260: WHERE cl.rowid = trx_rowid
261: AND rec.reference_id(+) = cl.statement_line_id
262: AND rec.reference_type(+) = 'STATEMENT'

Line 272: FROM ce_statement_lines cl

268: -- Statement line clearing
269: --
270: CURSOR clear_lock_260 (X_call_mode VARCHAR2,trx_rowid VARCHAR2) IS
271: SELECT cl.statement_line_id
272: FROM ce_statement_lines cl
273: WHERE cl.rowid = trx_rowid
274: FOR UPDATE OF cl.statement_line_id NOWAIT;
275:
276: --

Line 1281: FROM ce_statement_lines

1277: BEGIN
1278: cep_standard.debug('>>CE_AUTO_BANK_MATCH.get_min_statement_line_id');
1279: SELECT min(line_number)
1280: INTO min_statement_line_num
1281: FROM ce_statement_lines
1282: WHERE statement_header_id = CE_AUTO_BANK_MATCH.csh_statement_header_id;
1283:
1284: SELECT statement_line_id
1285: INTO min_statement_line

Line 1286: FROM ce_statement_lines

1282: WHERE statement_header_id = CE_AUTO_BANK_MATCH.csh_statement_header_id;
1283:
1284: SELECT statement_line_id
1285: INTO min_statement_line
1286: FROM ce_statement_lines
1287: WHERE line_number = min_statement_line_num
1288: AND statement_header_id = CE_AUTO_BANK_MATCH.csh_statement_header_id;
1289: cep_standard.debug('< 1290:

Line 3175: x_statement_line_id CE_STATEMENT_LINES.statement_line_id%TYPE;

3171: | match_engine |
3172: --------------------------------------------------------------------- */
3173: PROCEDURE create_misc_trx IS
3174: no_of_currencies NUMBER;
3175: x_statement_line_id CE_STATEMENT_LINES.statement_line_id%TYPE;
3176: misc_exists VARCHAR2(1);
3177: receipt_amount NUMBER;
3178: base_receipt_amount NUMBER;
3179: precision NUMBER;

Line 3184: l_trx_number CE_STATEMENT_LINES.BANK_TRX_NUMBER%TYPE; --Bug 3385023 added this variable.

3180: ext_precision NUMBER;
3181: min_acct_unit NUMBER;
3182: l_vat_tax_id NUMBER;
3183: l_tax_rate NUMBER;
3184: l_trx_number CE_STATEMENT_LINES.BANK_TRX_NUMBER%TYPE; --Bug 3385023 added this variable.
3185: current_org_id number;
3186: receivables_trx_org_id number;
3187: BEGIN
3188: cep_standard.debug('>>CE_AUTO_BANK_MATCH.create_misc_trx');

Line 4973: FROM ce_222_reconciled_v catv, ce_statement_lines sl

4969: catv.exchange_rate_date,
4970: catv.exchange_rate_type,
4971: catv.org_id,
4972: catv.CE_BANK_ACCT_USE_ID
4973: FROM ce_222_reconciled_v catv, ce_statement_lines sl
4974: WHERE nvl(sl.bank_trx_number,'-9999') =
4975: nvl(CE_AUTO_BANK_MATCH.csl_bank_trx_number, '-9999')
4976: AND (nvl(sl.invoice_text, '-99999') =
4977: nvl(CE_AUTO_BANK_MATCH.csl_invoice_text, '-99999')

Line 5071: FROM ce_222_reconciled_v catv, ce_statement_lines sl

5067: catv.exchange_rate_date,
5068: catv.exchange_rate_type,
5069: catv.org_id,
5070: catv.CE_BANK_ACCT_USE_ID
5071: FROM ce_222_reconciled_v catv, ce_statement_lines sl
5072: WHERE nvl(sl.bank_trx_number,'-9999') =
5073: nvl(CE_AUTO_BANK_MATCH.csl_bank_trx_number, '-9999')
5074: AND (nvl(sl.invoice_text, '-99999') =
5075: nvl(CE_AUTO_BANK_MATCH.csl_invoice_text, '-99999')

Line 5169: FROM ce_200_reconciled_v catv, ce_statement_lines sl

5165: catv.exchange_rate_date,
5166: catv.exchange_rate_type,
5167: catv.org_id,
5168: catv.CE_BANK_ACCT_USE_ID
5169: FROM ce_200_reconciled_v catv, ce_statement_lines sl
5170: WHERE nvl(sl.bank_trx_number,'-9999') =
5171: nvl(CE_AUTO_BANK_MATCH.csl_bank_trx_number, '-9999')
5172: AND (nvl(sl.invoice_text, '-99999') =
5173: nvl(CE_AUTO_BANK_MATCH.csl_invoice_text, '-99999')

Line 5289: ce_statement_reconcils_all r, ce_statement_lines l

5285: v.seq_id
5286: --FROM ce_222_transactions_v v, gl_daily_conversion_types glcc,
5287: FROM ce_available_transactions_tmp v, gl_daily_conversion_types glcc,
5288: ar_cash_receipt_history_all ar, ce_statement_headers h,
5289: ce_statement_reconcils_all r, ce_statement_lines l
5290: WHERE h.bank_account_id = CE_AUTO_BANK_MATCH.csh_bank_account_id
5291: AND nvl(l.bank_trx_number,'-9999') =
5292: nvl(CE_AUTO_BANK_MATCH.csl_bank_trx_number, '-9999')
5293: AND (nvl(l.invoice_text, '-99999') =

Line 5404: ce_statement_reconcils_all r, ce_statement_lines l

5400: v2.seq_id
5401: --FROM ce_200_transactions_v v2, gl_daily_conversion_types glcc,
5402: FROM ce_available_transactions_tmp v2, gl_daily_conversion_types glcc,
5403: ce_statement_headers h,
5404: ce_statement_reconcils_all r, ce_statement_lines l
5405: WHERE h.bank_account_id = CE_AUTO_BANK_MATCH.csh_bank_account_id
5406: AND nvl(l.bank_trx_number,'-9999') =
5407: nvl(CE_AUTO_BANK_MATCH.csl_bank_trx_number, '-9999')
5408: AND (nvl(l.invoice_text, '-99999') =

Line 6221: x_statement_line_id CE_STATEMENT_LINES.statement_line_id%TYPE;

6217: no_of_currencies NUMBER;
6218: primary_match VARCHAR2(10);
6219: secondary_match VARCHAR2(10);
6220: Tertiary_match VARCHAR2(10); --- FOR SEPA ER 6700007
6221: x_statement_line_id CE_STATEMENT_LINES.statement_line_id%TYPE;
6222: misc_exists VARCHAR2(1) := 'N';
6223: receipt_amount NUMBER;
6224: base_receipt_amount NUMBER;
6225: precision NUMBER;

Line 6230: l_trx_number CE_STATEMENT_LINES.BANK_TRX_NUMBER%TYPE; --Bug 3385023 added this variable.

6226: ext_precision NUMBER;
6227: min_acct_unit NUMBER;
6228: l_vat_tax_id NUMBER := to_number(null);
6229: l_tax_rate NUMBER := to_number(null);
6230: l_trx_number CE_STATEMENT_LINES.BANK_TRX_NUMBER%TYPE; --Bug 3385023 added this variable.
6231: accounting_method_found NUMBER := 0;
6232: current_org_id number;
6233: receivables_trx_org_id number;
6234:

Line 6861: FROM ce_statement_lines

6857: CE_AUTO_BANK_MATCH.csl_line_number,
6858: CE_AUTO_BANK_MATCH.csl_customer_text,
6859: CE_AUTO_BANK_MATCH.csl_effective_date,
6860: CE_AUTO_BANK_MATCH.csl_original_amount
6861: FROM ce_statement_lines
6862: WHERE rowid = CE_AUTO_BANK_MATCH.csl_rowid
6863: FOR UPDATE OF status NOWAIT;
6864:
6865: cep_standard.debug('CE_AUTO_BANK_MATCH.csl_trx_type='||CE_AUTO_BANK_MATCH.csl_trx_type||

Line 7498: l_sl_amount CE_STATEMENT_LINES.amount%TYPE;

7494: l_je_line_num GL_JE_LINES.je_line_num%TYPE;
7495: l_trx_currency_type VARCHAR2(100);
7496: l_sob_currency_code FND_CURRENCIES.CURRENCY_CODE%TYPE;
7497: l_je_amount GL_JE_LINES.accounted_dr%TYPE;
7498: l_sl_amount CE_STATEMENT_LINES.amount%TYPE;
7499: l_je_entered_dr GL_JE_LINES.entered_dr%TYPE;
7500: l_je_entered_cr GL_JE_LINES.entered_cr%TYPE;
7501: l_je_currency_code FND_CURRENCIES.CURRENCY_CODE%TYPE;
7502: l_sl_currency_code FND_CURRENCIES.CURRENCY_CODE%TYPE;

Line 7777: from ce_statement_lines sl,

7773: -- before everything else, it'll match to cashflow transactions
7774:
7775: select count(1)
7776: into l_cf
7777: from ce_statement_lines sl,
7778: ce_statement_headers sh
7779: where sl.statement_header_id = sh.statement_header_id
7780: and sh.bank_account_id = p_bank_account_id
7781: and sl.cashflow_id is not null;

Line 9769: error_statement_line_id CE_STATEMENT_LINES.statement_line_id%TYPE;

9765: | CALLED BY |
9766: | statement |
9767: --------------------------------------------------------------------- */
9768: PROCEDURE match_process IS
9769: error_statement_line_id CE_STATEMENT_LINES.statement_line_id%TYPE;
9770: lockhandle VARCHAR2(128);
9771: lock_status NUMBER;
9772: statement_line_count NUMBER;
9773: i NUMBER;

Line 10032: from ce_statement_lines

10028: -- EXIT WHEN r_bank_cursor%NOTFOUND OR r_bank_cursor%NOTFOUND IS NULL;
10029:
10030: select count(1)
10031: into row_count
10032: from ce_statement_lines
10033: where statement_header_id = CE_AUTO_BANK_MATCH.csh_statement_header_id;
10034:
10035: if (row_count = 0 ) then
10036: CE_RECONCILIATION_ERRORS_PKG.delete_row(