FND Design Data [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