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 GL_JE_LINES

Line 153: FROM gl_je_lines jel,

149: -- Journals
150: --
151: CURSOR lock_101 (x_call_mode VARCHAR2, trx_rowid VARCHAR2) IS
152: SELECT jel.je_header_id
153: FROM gl_je_lines jel,
154: ce_statement_reconcils_all rec
155: WHERE jel.rowid = trx_rowid
156: AND rec.reference_id(+) = jel.je_line_num
157: AND rec.je_header_id(+) = jel.je_header_id

Line 7725: l_je_line_num GL_JE_LINES.je_line_num%TYPE;

7721: ----------------------------------------------------------------------*/
7722: PROCEDURE match_stmt_line_JE IS
7723: no_of_matches NUMBER;
7724: l_je_header_id GL_JE_HEADERS.je_header_id%TYPE := null;
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;

Line 7728: l_je_amount GL_JE_LINES.accounted_dr%TYPE;

7724: l_je_header_id GL_JE_HEADERS.je_header_id%TYPE := null;
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;

Line 7730: l_je_entered_dr GL_JE_LINES.entered_dr%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;
7734: d_statement_header_id CE_STATEMENT_HEADERS.statement_header_id%TYPE;

Line 7731: l_je_entered_cr GL_JE_LINES.entered_cr%TYPE;

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;
7734: d_statement_header_id CE_STATEMENT_HEADERS.statement_header_id%TYPE;
7735: P_CURRENCY_CODE VARCHAR2(15);