FND Design Data [Home] [Help]

View: CE_STATEMENT_BANKS_V

Product: CE - Cash Management
Description:
Implementation/DBA Data: ViewAPPS.CE_STATEMENT_BANKS_V
View Text

SELECT STATEMENT_NUMBER
, BANK_ACCOUNT_NUM
FROM CE_STATEMENT_HEADERS_INT UNION SELECT CSH.STATEMENT_NUMBER
, ABA.BANK_ACCOUNT_NUM
FROM CE_BANK_ACCOUNTS ABA
, CE_STATEMENT_HEADERS CSH
WHERE CSH.BANK_ACCOUNT_ID = ABA.BANK_ACCOUNT_ID

Columns

Name
STATEMENT_NUMBER
BANK_ACCOUNT_NUM