[Home] [Help]
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
Name |
INSTRID |
BANKACCOUNTID |
FINAME |
BRANCHID |
ACCTTYPE |
INSTRBUF |
INSTRNAME |
ACCOUNT_HOLDER_NAME |
BANKID |
OWNERID |
OWNERTYPE |
CHECK_DIGITS |