VIEW: APPS.IBY_BANKACCT_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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