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_IMPORT dependencies on CE_TRANSACTION_CODES

Line 150: ce_transaction_codes ctc,

146: gt.user_conversion_type,
147: curr.currency_code
148: FROM fnd_currencies curr,
149: gl_daily_conversion_types gt,
150: ce_transaction_codes ctc,
151: ce_statement_lines_interface l
152: WHERE curr.currency_code(+) = l.currency_code
153: AND gt.user_conversion_type(+) = l.user_exchange_rate_type
154: AND ctc.trx_code(+) = l.trx_code

Line 157: FROM ce_Transaction_Codes ctc2

153: AND gt.user_conversion_type(+) = l.user_exchange_rate_type
154: AND ctc.trx_code(+) = l.trx_code
155: AND ctc.bank_account_id(+) = CE_AUTO_BANK_IMPORT.G_bank_account_id
156: AND nvl(ctc.Reconciliation_Sequence,1) = (SELECT nvl(min(ctc2.Reconciliation_Sequence),1)-- Code added for bug 7531187
157: FROM ce_Transaction_Codes ctc2
158: WHERE ctc2.Bank_Account_Id (+) =CE_AUTO_BANK_IMPORT.G_bank_account_id
159: AND ctc2.trx_Code (+) = l.trx_Code
160: AND ((CE_AUTO_BANK_IMPORT.G_cshi_statement_date BETWEEN --8928828 start
161: Nvl(ctc2.start_date,CE_AUTO_BANK_IMPORT.G_cshi_statement_date)

Line 164: (NOT EXISTS (SELECT 1 FROM ce_transaction_codes tc

160: AND ((CE_AUTO_BANK_IMPORT.G_cshi_statement_date BETWEEN --8928828 start
161: Nvl(ctc2.start_date,CE_AUTO_BANK_IMPORT.G_cshi_statement_date)
162: AND Nvl(ctc2.end_date,CE_AUTO_BANK_IMPORT.G_cshi_statement_date))
163: OR
164: (NOT EXISTS (SELECT 1 FROM ce_transaction_codes tc
165: WHERE tc.trx_code = l.trx_code
166: AND tc. bank_account_id = CE_AUTO_BANK_IMPORT.G_bank_account_id
167: AND CE_AUTO_BANK_IMPORT.G_cshi_statement_date BETWEEN
168: NVL(tc.start_date, CE_AUTO_BANK_IMPORT.G_cshi_statement_date)

Line 905: FROM ce_transaction_codes ctc,

901: csli.attribute12,
902: csli.attribute13,
903: csli.attribute14,
904: csli.attribute15
905: FROM ce_transaction_codes ctc,
906: ce_statement_lines_interface csli,
907: ce_bank_accts_gt_v aba --ce_bank_accounts_v aba
908: WHERE ctc.trx_code(+) = csli.trx_code
909: AND NVL(ctc.bank_account_id,aba.bank_account_id) =

Line 964: from ce_transaction_codes ctc

960: CE_AUTO_BANK_IMPORT.G_cshi_statement_header_id,
961: csli.line_number,
962: csli.trx_date,
963: (select distinct ctc.trx_type
964: from ce_transaction_codes ctc
965: where ctc.trx_code(+) = csli.trx_code
966: AND NVL(ctc.bank_account_id,aba.bank_account_id) =
967: aba.bank_account_id),
968: csli.trx_code, --ctc.transaction_code_id,

Line 1014: FROM --ce_transaction_codes ctc,

1010: csli.attribute12,
1011: csli.attribute13,
1012: csli.attribute14,
1013: csli.attribute15
1014: FROM --ce_transaction_codes ctc,
1015: gl_daily_conversion_types gdct,
1016: ce_statement_lines_interface csli,
1017: ce_bank_accts_gt_v aba --ce_bank_accounts_v aba
1018: WHERE gdct.user_conversion_type(+) = csli.user_exchange_rate_type

Line 1515: FROM ce_transaction_codes

1511: -- We need to do this because of the control total validation relies on these codes
1512: --
1513: SELECT count(*)
1514: INTO trx_code_count
1515: FROM ce_transaction_codes
1516: WHERE bank_account_id = CE_AUTO_BANK_IMPORT.G_bank_account_id;
1517: IF (trx_code_count = 0) THEN
1518: error_found := CE_AUTO_BANK_IMPORT.header_error('CE_NO_TRX_CODES');
1519: END IF;

Line 1848: r_trx_code_id CE_TRANSACTION_CODES.transaction_code_id%TYPE;

1844: r_statement_number CE_STATEMENT_HEADERS.statement_number%TYPE;
1845: r_user_conversion_type GL_DAILY_CONVERSION_TYPES.user_conversion_type%TYPE;
1846: r_exchange_rate_type GL_DAILY_CONVERSION_TYPES.conversion_type%TYPE;
1847: r_currency_code FND_CURRENCIES.currency_code%TYPE;
1848: r_trx_code_id CE_TRANSACTION_CODES.transaction_code_id%TYPE;
1849: r_start_date CE_TRANSACTION_CODES.start_date%TYPE;
1850: r_end_date CE_TRANSACTION_CODES.end_date%TYPE;
1851: line_error_found BOOLEAN;
1852: l_error_found BOOLEAN;

Line 1849: r_start_date CE_TRANSACTION_CODES.start_date%TYPE;

1845: r_user_conversion_type GL_DAILY_CONVERSION_TYPES.user_conversion_type%TYPE;
1846: r_exchange_rate_type GL_DAILY_CONVERSION_TYPES.conversion_type%TYPE;
1847: r_currency_code FND_CURRENCIES.currency_code%TYPE;
1848: r_trx_code_id CE_TRANSACTION_CODES.transaction_code_id%TYPE;
1849: r_start_date CE_TRANSACTION_CODES.start_date%TYPE;
1850: r_end_date CE_TRANSACTION_CODES.end_date%TYPE;
1851: line_error_found BOOLEAN;
1852: l_error_found BOOLEAN;
1853: header_error_found BOOLEAN;

Line 1850: r_end_date CE_TRANSACTION_CODES.end_date%TYPE;

1846: r_exchange_rate_type GL_DAILY_CONVERSION_TYPES.conversion_type%TYPE;
1847: r_currency_code FND_CURRENCIES.currency_code%TYPE;
1848: r_trx_code_id CE_TRANSACTION_CODES.transaction_code_id%TYPE;
1849: r_start_date CE_TRANSACTION_CODES.start_date%TYPE;
1850: r_end_date CE_TRANSACTION_CODES.end_date%TYPE;
1851: line_error_found BOOLEAN;
1852: l_error_found BOOLEAN;
1853: header_error_found BOOLEAN;
1854: lock_error_found BOOLEAN;