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_BRANCHES_V

Line 87: from ce_bank_branches_v bb

83: AND sh.bank_account_num = ba.bank_account_num
84: AND ba.bank_account_id = NVL(p_bank_account_id,ba.bank_account_id)
85: AND EXISTS (
86: select null
87: from ce_bank_branches_v bb
88: where bb.branch_party_id = ba.bank_branch_id
89: and bb.bank_name = nvl(sh.bank_name, bb.bank_name)
90: and bb.bank_branch_name =
91: nvl(sh.bank_branch_name, bb.bank_branch_name))

Line 1596: FROM ce_bank_branches_v abb,

1592: /*
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)