View: IBY_BANKACCT_V

Product:	IBY - Payments
Description:	View used to work with registered bank accounts.
Implementation/DBA Data:	APPS.IBY_BANKACCT_V

View Text

SELECT B.INSTRID
, B.BANKACCOUNTID
, B.FINAME
, B.BRANCHNAME BRANCHID
, Y.ACCTTYPE
, B.DESCRIPTION INSTRBUF
, B.INSTRNAME
, B.ACCOUNT_HOLDER_NAME
, B.ROUTINGNO BANKID
, H.OWNERID
, H.OWNERTYPE
, B.CHECK_DIGITS
FROM IBY_BANKACCT B
, IBY_INSTRHOLDER H
, IBY_ACCTTYPE Y
WHERE B.INSTRID = H.INSTRID
AND H.INSTRTYPE = 'BANKACCOUNT'
AND B.ACCTTYPEID = Y.ACCTTYPEID
AND H.ACTIVESTATUS = 1

Columns