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

87: FROM --pay_payment_types ppt,
88: --ar_receipt_methods rm,
89: ce_statement_headers sh,
90: ce_transaction_codes cd,
91: ce_statement_lines sl
92: WHERE --rm.receipt_method_id(+) = cd.receipt_method_id
93: --nvl(cd.RECONCILIATION_SEQUENCE (+) ,1) = 1
94: nvl(cd.RECONCILIATION_SEQUENCE ,1) =
95: (select nvl(min(tc.reconciliation_sequence),1)

Line 128: ce_statement_lines sl

124: ppt.payment_type_name
125: FROM pay_payment_types ppt,
126: ar_receipt_methods rm,
127: ce_transaction_codes cd,
128: ce_statement_lines sl
129: WHERE rm.receipt_method_id(+) = cd.receipt_method_id
130: --AND cd.transaction_code_id(+) = sl.trx_code_id
131: AND cd.trx_code (+) = sl.trx_code
132: AND cd.payroll_payment_format_id = ppt.payment_type_id (+)

Line 239: FROM ce_statement_lines cl,

235: -- Statement lines
236: --
237: CURSOR lock_260 (X_call_mode VARCHAR2,trx_rowid VARCHAR2) IS
238: SELECT cl.statement_line_id
239: FROM ce_statement_lines cl,
240: ce_statement_reconcils_all rec
241: WHERE cl.rowid = trx_rowid
242: AND rec.reference_id(+) = cl.statement_line_id
243: AND rec.reference_type(+) = 'STATEMENT'

Line 253: FROM ce_statement_lines cl

249: -- Statement line clearing
250: --
251: CURSOR clear_lock_260 (X_call_mode VARCHAR2,trx_rowid VARCHAR2) IS
252: SELECT cl.statement_line_id
253: FROM ce_statement_lines cl
254: WHERE cl.rowid = trx_rowid
255: FOR UPDATE OF cl.statement_line_id NOWAIT;
256:
257: --

Line 594: num_check ce_statement_lines.bank_trx_number%type;

590: /* check if check_value is a numeric value Bug 13495984*/
591: FUNCTION ce_check_numeric(check_value VARCHAR2,
592: pos_from NUMBER,
593: pos_for NUMBER) RETURN VARCHAR2 IS
594: num_check ce_statement_lines.bank_trx_number%type;
595:
596: BEGIN
597: num_check := nvl(
598: rtrim(

Line 1296: FROM ce_statement_lines

1292: BEGIN
1293: cep_standard.debug('>>CE_AUTO_BANK_MATCH.get_min_statement_line_id');
1294: SELECT min(line_number)
1295: INTO min_statement_line_num
1296: FROM ce_statement_lines
1297: WHERE statement_header_id = CE_AUTO_BANK_MATCH.csh_statement_header_id;
1298:
1299: SELECT statement_line_id
1300: INTO min_statement_line

Line 1301: FROM ce_statement_lines

1297: WHERE statement_header_id = CE_AUTO_BANK_MATCH.csh_statement_header_id;
1298:
1299: SELECT statement_line_id
1300: INTO min_statement_line
1301: FROM ce_statement_lines
1302: WHERE line_number = min_statement_line_num
1303: AND statement_header_id = CE_AUTO_BANK_MATCH.csh_statement_header_id;
1304: cep_standard.debug('< 1305:

Line 3257: x_statement_line_id CE_STATEMENT_LINES.statement_line_id%TYPE;

3253: --------------------------------------------------------------------- */
3254: PROCEDURE create_misc_trx
3255: IS
3256: no_of_currencies NUMBER;
3257: x_statement_line_id CE_STATEMENT_LINES.statement_line_id%TYPE;
3258: misc_exists VARCHAR2(1);
3259: receipt_amount NUMBER;
3260: base_receipt_amount NUMBER;
3261: PRECISION NUMBER;

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

3262: ext_precision NUMBER;
3263: min_acct_unit NUMBER;
3264: l_vat_tax_id NUMBER;
3265: l_tax_rate NUMBER;
3266: l_trx_number CE_STATEMENT_LINES.BANK_TRX_NUMBER%TYPE; --Bug 3385023 added this variable.
3267: current_org_id NUMBER;
3268: receivables_trx_org_id NUMBER;
3269: l_creation_status AR_RECEIPT_CLASSES.creation_status%TYPE; --Bug 9021558 Added
3270: BEGIN

Line 5220: FROM ce_222_reconciled_v catv, ce_statement_lines sl

5216: catv.exchange_rate_date,
5217: catv.exchange_rate_type,
5218: catv.org_id,
5219: catv.CE_BANK_ACCT_USE_ID
5220: FROM ce_222_reconciled_v catv, ce_statement_lines sl
5221: WHERE nvl(sl.bank_trx_number,'-9999') =
5222: nvl(CE_AUTO_BANK_MATCH.csl_bank_trx_number, '-9999')
5223: AND (nvl(sl.invoice_text, '-99999') =
5224: nvl(CE_AUTO_BANK_MATCH.csl_invoice_text, '-99999')

Line 5318: FROM ce_222_reconciled_v catv, ce_statement_lines sl

5314: catv.exchange_rate_date,
5315: catv.exchange_rate_type,
5316: catv.org_id,
5317: catv.CE_BANK_ACCT_USE_ID
5318: FROM ce_222_reconciled_v catv, ce_statement_lines sl
5319: WHERE nvl(sl.bank_trx_number,'-9999') =
5320: nvl(CE_AUTO_BANK_MATCH.csl_bank_trx_number, '-9999')
5321: AND (nvl(sl.invoice_text, '-99999') =
5322: nvl(CE_AUTO_BANK_MATCH.csl_invoice_text, '-99999')

Line 5416: FROM ce_200_reconciled_v catv, ce_statement_lines sl

5412: catv.exchange_rate_date,
5413: catv.exchange_rate_type,
5414: catv.org_id,
5415: catv.CE_BANK_ACCT_USE_ID
5416: FROM ce_200_reconciled_v catv, ce_statement_lines sl
5417: WHERE nvl(sl.bank_trx_number,'-9999') =
5418: nvl(CE_AUTO_BANK_MATCH.csl_bank_trx_number, '-9999')
5419: AND (nvl(sl.invoice_text, '-99999') =
5420: nvl(CE_AUTO_BANK_MATCH.csl_invoice_text, '-99999')

Line 5536: ce_statement_reconcils_all r, ce_statement_lines l

5532: v.seq_id
5533: --FROM ce_222_transactions_v v, gl_daily_conversion_types glcc,
5534: FROM ce_available_transactions_tmp v, gl_daily_conversion_types glcc,
5535: ar_cash_receipt_history_all ar, ce_statement_headers h,
5536: ce_statement_reconcils_all r, ce_statement_lines l
5537: WHERE h.bank_account_id = CE_AUTO_BANK_MATCH.csh_bank_account_id
5538: AND nvl(l.bank_trx_number,'-9999') =
5539: nvl(CE_AUTO_BANK_MATCH.csl_bank_trx_number, '-9999')
5540: AND (nvl(l.invoice_text, '-99999') =

Line 5651: ce_statement_reconcils_all r, ce_statement_lines l

5647: v2.seq_id
5648: --FROM ce_200_transactions_v v2, gl_daily_conversion_types glcc,
5649: FROM ce_available_transactions_tmp v2, gl_daily_conversion_types glcc,
5650: ce_statement_headers h,
5651: ce_statement_reconcils_all r, ce_statement_lines l
5652: WHERE h.bank_account_id = CE_AUTO_BANK_MATCH.csh_bank_account_id
5653: AND nvl(l.bank_trx_number,'-9999') =
5654: nvl(CE_AUTO_BANK_MATCH.csl_bank_trx_number, '-9999')
5655: AND (nvl(l.invoice_text, '-99999') =

Line 6428: x_statement_line_id CE_STATEMENT_LINES.statement_line_id%TYPE;

6424: primary_match VARCHAR2(10);
6425: secondary_match VARCHAR2(10);
6426: Tertiary_match VARCHAR2(10); -- FOR SEPA ER 6700007
6427: Tertiary_batch_match BOOLEAN; -- Bug 9577381 Added Line
6428: x_statement_line_id CE_STATEMENT_LINES.statement_line_id%TYPE;
6429: misc_exists VARCHAR2(1) := 'N';
6430: receipt_amount NUMBER;
6431: base_receipt_amount NUMBER;
6432: precision NUMBER;

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

6433: ext_precision NUMBER;
6434: min_acct_unit NUMBER;
6435: l_vat_tax_id NUMBER := to_number(null);
6436: l_tax_rate NUMBER := to_number(null);
6437: l_trx_number CE_STATEMENT_LINES.BANK_TRX_NUMBER%TYPE; --Bug 3385023 added this variable.
6438: accounting_method_found NUMBER := 0;
6439: current_org_id NUMBER;
6440: receivables_trx_org_id NUMBER;
6441: BEGIN

Line 7050: FROM ce_statement_lines

7046: CE_AUTO_BANK_MATCH.csl_line_number,
7047: CE_AUTO_BANK_MATCH.csl_customer_text,
7048: CE_AUTO_BANK_MATCH.csl_effective_date,
7049: CE_AUTO_BANK_MATCH.csl_original_amount
7050: FROM ce_statement_lines
7051: WHERE rowid = CE_AUTO_BANK_MATCH.csl_rowid
7052: FOR UPDATE OF status NOWAIT;
7053:
7054: cep_standard.debug('CE_AUTO_BANK_MATCH.csl_trx_type='||CE_AUTO_BANK_MATCH.csl_trx_type||

Line 7729: l_sl_amount CE_STATEMENT_LINES.amount%TYPE;

7725: l_je_line_num GL_JE_LINES.je_line_num%TYPE;
7726: l_trx_currency_type VARCHAR2(100);
7727: l_sob_currency_code FND_CURRENCIES.CURRENCY_CODE%TYPE;
7728: l_je_amount GL_JE_LINES.accounted_dr%TYPE;
7729: l_sl_amount CE_STATEMENT_LINES.amount%TYPE;
7730: l_je_entered_dr GL_JE_LINES.entered_dr%TYPE;
7731: l_je_entered_cr GL_JE_LINES.entered_cr%TYPE;
7732: l_je_currency_code FND_CURRENCIES.CURRENCY_CODE%TYPE;
7733: l_sl_currency_code FND_CURRENCIES.CURRENCY_CODE%TYPE;

Line 8025: from ce_statement_lines sl,

8021: -- before everything else, it'll match to cashflow transactions
8022:
8023: select count(1)
8024: into l_cf
8025: from ce_statement_lines sl,
8026: ce_statement_headers sh
8027: where sl.statement_header_id = sh.statement_header_id
8028: and sh.bank_account_id = p_bank_account_id
8029: and sl.cashflow_id is not null;

Line 10017: error_statement_line_id CE_STATEMENT_LINES.statement_line_id%TYPE;

10013: | CALLED BY |
10014: | statement |
10015: --------------------------------------------------------------------- */
10016: PROCEDURE match_process IS
10017: error_statement_line_id CE_STATEMENT_LINES.statement_line_id%TYPE;
10018: lockhandle VARCHAR2(128);
10019: statement_line_count NUMBER;
10020: i NUMBER;
10021: j NUMBER;

Line 10205: from ce_statement_lines

10201: end if;
10202:
10203: select count(1)
10204: into row_count
10205: from ce_statement_lines
10206: where statement_header_id = CE_AUTO_BANK_MATCH.csh_statement_header_id;
10207:
10208: cep_standard.debug('--> # of statement lines: '||row_count);
10209: if (row_count = 0 ) then