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.

[Home] [Help]

View: AP_BANK_BRANCHES_V

Product:	AP - Payables
Description:	View of AP_BANK_BRANCHES used in report
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT BB.BANK_NAME || ' - ' || BB.BANK_BRANCH_NAME BANK_BRANCH
, BB.BANK_BRANCH_ID
FROM AP_BANK_BRANCHES BB
WHERE EXISTS (SELECT 'AN INTERNAL ACCOUNT EXISTS'
FROM AP_BANK_ACCOUNTS BA
WHERE BA.BANK_BRANCH_ID = BB.BANK_BRANCH_ID
AND BA.ACCOUNT_TYPE = 'INTERNAL')

Columns

Name
BANK_BRANCH
BANK_BRANCH_ID