[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 |