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_BANK_ACCOUNTS

Line 12: --FROM ce_bank_accounts_v aba

8: SELECT aba.bank_account_id,
9: aba.ACCOUNT_OWNER_ORG_ID,
10: nvl(aba.XTR_USE_ALLOWED_FLAG,'N'),
11: nvl(aba.PAY_USE_ALLOWED_FLAG,'N')
12: --FROM ce_bank_accounts_v aba
13: FROM ce_bank_accts_gt_v aba
14: WHERE aba.bank_branch_id = p_bank_branch_id
15: AND aba.bank_account_id = NVL(p_bank_account_id, aba.bank_account_id);
16: --AND aba.account_classification = 'INTERNAL';

Line 73: ce_bank_accts_gt_v ba --ce_bank_accounts_v ba

69: ba.currency_code,
70: ba.check_digits
71: FROM ce_statement_headers rsh,
72: ce_statement_headers_int sh,
73: ce_bank_accts_gt_v ba --ce_bank_accounts_v ba
74: WHERE rsh.statement_number(+) = sh.statement_number
75: AND rsh.bank_account_id(+) = p_bank_account_id
76: AND NVL(sh.record_status_flag, 'I') <> 'T'
77: AND sh.statement_number

Line 899: ce_bank_accts_gt_v aba --ce_bank_accounts_v aba

895: csli.attribute14,
896: csli.attribute15
897: FROM ce_transaction_codes ctc,
898: ce_statement_lines_interface csli,
899: ce_bank_accts_gt_v aba --ce_bank_accounts_v aba
900: WHERE ctc.trx_code(+) = csli.trx_code
901: AND NVL(ctc.bank_account_id,aba.bank_account_id) =
902: aba.bank_account_id
903: AND csli.statement_number = G_cshi_statement_number

Line 1006: ce_bank_accts_gt_v aba --ce_bank_accounts_v aba

1002: csli.attribute15
1003: FROM --ce_transaction_codes ctc,
1004: gl_daily_conversion_types gdct,
1005: ce_statement_lines_interface csli,
1006: ce_bank_accts_gt_v aba --ce_bank_accounts_v aba
1007: WHERE gdct.user_conversion_type(+) = csli.user_exchange_rate_type
1008: --AND ctc.trx_code(+) = csli.trx_code
1009: --AND NVL(ctc.bank_account_id,aba.bank_account_id) =
1010: -- aba.bank_account_id

Line 1099: (select bank_account_id from ce_bank_accounts_v

1095: (select statement_header_id
1096: from ce_intra_stmt_headers
1097: where statement_number = G_cshi_statement_number
1098: and bank_account_id in
1099: (select bank_account_id from ce_bank_accounts_v
1100: where bank_account_num = G_cshi_bank_account_num));
1101: DELETE FROM CE_INTRA_STMT_HEADERS
1102: WHERE statement_number = G_cshi_statement_number
1103: AND bank_account_id in

Line 1104: (select bank_account_id from ce_bank_accounts_v

1100: where bank_account_num = G_cshi_bank_account_num));
1101: DELETE FROM CE_INTRA_STMT_HEADERS
1102: WHERE statement_number = G_cshi_statement_number
1103: AND bank_account_id in
1104: (select bank_account_id from ce_bank_accounts_v
1105: where bank_account_num = G_cshi_bank_account_num);
1106:
1107: select ce_intra_stmt_headers_s.nextval
1108: into G_cshi_statement_header_id

Line 1584: ce_bank_accts_gt_v aba --ce_bank_accounts_v aba

1580: --SELECT aba.account_type
1581: SELECT aba.account_classification
1582: INTO account_type
1583: FROM ce_bank_branches_v abb,
1584: ce_bank_accts_gt_v aba --ce_bank_accounts_v aba
1585: WHERE aba.bank_branch_id = abb.branch_party_id
1586: AND abb.bank_name = nvl(CE_AUTO_BANK_IMPORT.G_cshi_bank_name, abb.bank_name)
1587: AND abb.bank_branch_name = nvl(CE_AUTO_BANK_IMPORT.G_cshi_bank_branch_name,abb.bank_branch_name)
1588: AND aba.bank_account_num = CE_AUTO_BANK_IMPORT.G_cshi_bank_account_num

Line 1760: ce_bank_accts_gt_v ba --ce_bank_accounts_v ba

1756: CE_AUTO_BANK_REC.G_interface_purge_flag ,
1757: CE_AUTO_BANK_REC.G_interface_archive_flag
1758: FROM CE_SYSTEM_PARAMETERS_ALL s,
1759: GL_SETS_OF_BOOKS g,
1760: ce_bank_accts_gt_v ba --ce_bank_accounts_v ba
1761: WHERE ba.bank_account_id = CE_AUTO_BANK_IMPORT.G_bank_account_id
1762: and ba.ACCOUNT_OWNER_ORG_ID = s.legal_entity_id
1763: and s.set_of_books_id = g.set_of_books_id;
1764:

Line 1814: aba_bank_account_id CE_BANK_ACCOUNTS.bank_account_id%TYPE;

1810: | CALLED BY |
1811: | CE_AUTO_BANK_REC.statement |
1812: --------------------------------------------------------------------- */
1813: PROCEDURE import_process IS
1814: aba_bank_account_id CE_BANK_ACCOUNTS.bank_account_id%TYPE;
1815: aba_bank_currency CE_BANK_ACCOUNTS.currency_code%TYPE;
1816: aba_bank_account_name CE_BANK_ACCOUNTS.bank_account_name%TYPE;
1817: aba_bank_check_digits CE_BANK_ACCOUNTS.check_digits%TYPE;
1818: csli_line_number CE_STATEMENT_LINES_INTERFACE.line_number%TYPE;

Line 1815: aba_bank_currency CE_BANK_ACCOUNTS.currency_code%TYPE;

1811: | CE_AUTO_BANK_REC.statement |
1812: --------------------------------------------------------------------- */
1813: PROCEDURE import_process IS
1814: aba_bank_account_id CE_BANK_ACCOUNTS.bank_account_id%TYPE;
1815: aba_bank_currency CE_BANK_ACCOUNTS.currency_code%TYPE;
1816: aba_bank_account_name CE_BANK_ACCOUNTS.bank_account_name%TYPE;
1817: aba_bank_check_digits CE_BANK_ACCOUNTS.check_digits%TYPE;
1818: csli_line_number CE_STATEMENT_LINES_INTERFACE.line_number%TYPE;
1819: csli_amount CE_STATEMENT_LINES_INTERFACE.amount%TYPE;

Line 1816: aba_bank_account_name CE_BANK_ACCOUNTS.bank_account_name%TYPE;

1812: --------------------------------------------------------------------- */
1813: PROCEDURE import_process IS
1814: aba_bank_account_id CE_BANK_ACCOUNTS.bank_account_id%TYPE;
1815: aba_bank_currency CE_BANK_ACCOUNTS.currency_code%TYPE;
1816: aba_bank_account_name CE_BANK_ACCOUNTS.bank_account_name%TYPE;
1817: aba_bank_check_digits CE_BANK_ACCOUNTS.check_digits%TYPE;
1818: csli_line_number CE_STATEMENT_LINES_INTERFACE.line_number%TYPE;
1819: csli_amount CE_STATEMENT_LINES_INTERFACE.amount%TYPE;
1820: csli_trx_code CE_STATEMENT_LINES_INTERFACE.trx_code%TYPE;

Line 1817: aba_bank_check_digits CE_BANK_ACCOUNTS.check_digits%TYPE;

1813: PROCEDURE import_process IS
1814: aba_bank_account_id CE_BANK_ACCOUNTS.bank_account_id%TYPE;
1815: aba_bank_currency CE_BANK_ACCOUNTS.currency_code%TYPE;
1816: aba_bank_account_name CE_BANK_ACCOUNTS.bank_account_name%TYPE;
1817: aba_bank_check_digits CE_BANK_ACCOUNTS.check_digits%TYPE;
1818: csli_line_number CE_STATEMENT_LINES_INTERFACE.line_number%TYPE;
1819: csli_amount CE_STATEMENT_LINES_INTERFACE.amount%TYPE;
1820: csli_trx_code CE_STATEMENT_LINES_INTERFACE.trx_code%TYPE;
1821: csli_user_exchange_rate_type CE_STATEMENT_LINES_INTERFACE.user_exchange_rate_type%TYPE;

Line 1872: from ce_BANK_ACCOUNTS

1868: -- BUG 4914608
1869: /* IF (CE_AUTO_BANK_REC.G_legal_entity_id is null and CE_AUTO_BANK_REC.G_org_id is null) THEN
1870: select ACCOUNT_OWNER_ORG_ID
1871: into X_le_id
1872: from ce_BANK_ACCOUNTS
1873: where BANK_ACCOUNT_ID = aba_bank_account_id; */
1874: --IF (CE_AUTO_BANK_REC.G_legal_entity_id is null and CE_AUTO_BANK_REC.G_org_id is null) THEN
1875: IF (CE_AUTO_BANK_REC.G_legal_entity_id is null) and
1876: (CE_AUTO_BANK_IMPORT.BA_OWNER_LE_ID is not null) THEN