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 907: ce_bank_accts_gt_v aba --ce_bank_accounts_v aba

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) =
910: aba.bank_account_id
911: AND csli.statement_number = G_cshi_statement_number

Line 1017: ce_bank_accts_gt_v aba --ce_bank_accounts_v aba

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
1019: --AND ctc.trx_code(+) = csli.trx_code
1020: --AND NVL(ctc.bank_account_id,aba.bank_account_id) =
1021: -- aba.bank_account_id

Line 1110: (select bank_account_id from ce_bank_accounts_v

1106: (select statement_header_id
1107: from ce_intra_stmt_headers
1108: where statement_number = G_cshi_statement_number
1109: and bank_account_id in
1110: (select bank_account_id from ce_bank_accounts_v
1111: where bank_account_num = G_cshi_bank_account_num));
1112: DELETE FROM CE_INTRA_STMT_HEADERS
1113: WHERE statement_number = G_cshi_statement_number
1114: AND bank_account_id in

Line 1115: (select bank_account_id from ce_bank_accounts_v

1111: where bank_account_num = G_cshi_bank_account_num));
1112: DELETE FROM CE_INTRA_STMT_HEADERS
1113: WHERE statement_number = G_cshi_statement_number
1114: AND bank_account_id in
1115: (select bank_account_id from ce_bank_accounts_v
1116: where bank_account_num = G_cshi_bank_account_num);
1117:
1118: select ce_intra_stmt_headers_s.nextval
1119: into G_cshi_statement_header_id

Line 1597: ce_bank_accts_gt_v aba --ce_bank_accounts_v aba

1593: --SELECT aba.account_type
1594: SELECT aba.account_classification
1595: INTO account_type
1596: FROM ce_bank_branches_v abb,
1597: ce_bank_accts_gt_v aba --ce_bank_accounts_v aba
1598: WHERE aba.bank_branch_id = abb.branch_party_id
1599: AND abb.bank_name = nvl(CE_AUTO_BANK_IMPORT.G_cshi_bank_name, abb.bank_name)
1600: AND abb.bank_branch_name = nvl(CE_AUTO_BANK_IMPORT.G_cshi_bank_branch_name,abb.bank_branch_name)
1601: AND aba.bank_account_num = CE_AUTO_BANK_IMPORT.G_cshi_bank_account_num

Line 1775: ce_bank_accts_gt_v ba --ce_bank_accounts_v ba

1771: CE_AUTO_BANK_REC.G_interface_purge_flag ,
1772: CE_AUTO_BANK_REC.G_interface_archive_flag
1773: FROM CE_SYSTEM_PARAMETERS_ALL s,
1774: GL_SETS_OF_BOOKS g,
1775: ce_bank_accts_gt_v ba --ce_bank_accounts_v ba
1776: WHERE ba.bank_account_id = CE_AUTO_BANK_IMPORT.G_bank_account_id
1777: and ba.ACCOUNT_OWNER_ORG_ID = s.legal_entity_id
1778: and s.set_of_books_id = g.set_of_books_id;
1779:

Line 1829: aba_bank_account_id CE_BANK_ACCOUNTS.bank_account_id%TYPE;

1825: | CALLED BY |
1826: | CE_AUTO_BANK_REC.statement |
1827: --------------------------------------------------------------------- */
1828: PROCEDURE import_process IS
1829: aba_bank_account_id CE_BANK_ACCOUNTS.bank_account_id%TYPE;
1830: aba_bank_currency CE_BANK_ACCOUNTS.currency_code%TYPE;
1831: aba_bank_account_name CE_BANK_ACCOUNTS.bank_account_name%TYPE;
1832: aba_bank_check_digits CE_BANK_ACCOUNTS.check_digits%TYPE;
1833: csli_line_number CE_STATEMENT_LINES_INTERFACE.line_number%TYPE;

Line 1830: aba_bank_currency CE_BANK_ACCOUNTS.currency_code%TYPE;

1826: | CE_AUTO_BANK_REC.statement |
1827: --------------------------------------------------------------------- */
1828: PROCEDURE import_process IS
1829: aba_bank_account_id CE_BANK_ACCOUNTS.bank_account_id%TYPE;
1830: aba_bank_currency CE_BANK_ACCOUNTS.currency_code%TYPE;
1831: aba_bank_account_name CE_BANK_ACCOUNTS.bank_account_name%TYPE;
1832: aba_bank_check_digits CE_BANK_ACCOUNTS.check_digits%TYPE;
1833: csli_line_number CE_STATEMENT_LINES_INTERFACE.line_number%TYPE;
1834: csli_amount CE_STATEMENT_LINES_INTERFACE.amount%TYPE;

Line 1831: aba_bank_account_name CE_BANK_ACCOUNTS.bank_account_name%TYPE;

1827: --------------------------------------------------------------------- */
1828: PROCEDURE import_process IS
1829: aba_bank_account_id CE_BANK_ACCOUNTS.bank_account_id%TYPE;
1830: aba_bank_currency CE_BANK_ACCOUNTS.currency_code%TYPE;
1831: aba_bank_account_name CE_BANK_ACCOUNTS.bank_account_name%TYPE;
1832: aba_bank_check_digits CE_BANK_ACCOUNTS.check_digits%TYPE;
1833: csli_line_number CE_STATEMENT_LINES_INTERFACE.line_number%TYPE;
1834: csli_amount CE_STATEMENT_LINES_INTERFACE.amount%TYPE;
1835: csli_trx_code CE_STATEMENT_LINES_INTERFACE.trx_code%TYPE;

Line 1832: aba_bank_check_digits CE_BANK_ACCOUNTS.check_digits%TYPE;

1828: PROCEDURE import_process IS
1829: aba_bank_account_id CE_BANK_ACCOUNTS.bank_account_id%TYPE;
1830: aba_bank_currency CE_BANK_ACCOUNTS.currency_code%TYPE;
1831: aba_bank_account_name CE_BANK_ACCOUNTS.bank_account_name%TYPE;
1832: aba_bank_check_digits CE_BANK_ACCOUNTS.check_digits%TYPE;
1833: csli_line_number CE_STATEMENT_LINES_INTERFACE.line_number%TYPE;
1834: csli_amount CE_STATEMENT_LINES_INTERFACE.amount%TYPE;
1835: csli_trx_code CE_STATEMENT_LINES_INTERFACE.trx_code%TYPE;
1836: csli_user_exchange_rate_type CE_STATEMENT_LINES_INTERFACE.user_exchange_rate_type%TYPE;

Line 1895: from ce_BANK_ACCOUNTS

1891: -- BUG 4914608
1892: /* IF (CE_AUTO_BANK_REC.G_legal_entity_id is null and CE_AUTO_BANK_REC.G_org_id is null) THEN
1893: select ACCOUNT_OWNER_ORG_ID
1894: into X_le_id
1895: from ce_BANK_ACCOUNTS
1896: where BANK_ACCOUNT_ID = aba_bank_account_id; */
1897: --IF (CE_AUTO_BANK_REC.G_legal_entity_id is null and CE_AUTO_BANK_REC.G_org_id is null) THEN
1898: IF (CE_AUTO_BANK_REC.G_legal_entity_id is null) and
1899: (CE_AUTO_BANK_IMPORT.BA_OWNER_LE_ID is not null) THEN

Line 2094: CE_BANK_ACCOUNTS cba

2090: -- Bug 9278367
2091: SELECT xpi.party_code
2092: INTO p_xtr_company_code
2093: FROM XTR_PARTY_INFO xpi,
2094: CE_BANK_ACCOUNTS cba
2095: WHERE xpi.legal_entity_id = cba.account_owner_org_id
2096: AND cba.bank_account_id = aba_bank_account_id;
2097:
2098: select bank_branch_id

Line 2100: from ce_bank_accounts

2096: AND cba.bank_account_id = aba_bank_account_id;
2097:
2098: select bank_branch_id
2099: into p_branch_id
2100: from ce_bank_accounts
2101: where bank_account_id= aba_bank_account_id;
2102:
2103: XTR_REPLICATE_BANK_BALANCES.VALIDATE_OD_LIMIT_BALANCE(
2104: p_xtr_company_code,