View: IBY_TRANS_BANKACCT_V

Product:	IBY - Payments
Description:
Implementation/DBA Data:	APPS.IBY_TRANS_BANKACCT_V

View Text

SELECT B.BEPKEY
, B.TRANSACTIONID
, B.PAYEEID
, B.BEPID
, B.ECAPPID
, B.TRXNMID
, B.PAYERID
, B.PAYERINSTRID
, B.REQDATE
, B.REQTYPE
, B.STATUS
, B.SETTLEDATE
, B.UPDATEDATE
, B.TRXNTYPEID
, B.ERRORLOCATION
, B.BEPCODE
, B.BEPMESSAGE
, B.BATCHID
, B.NEEDSUPDT
, B.DESTURL
, B.PAYMENTMETHODNAME
, ROUND(T.AMOUNT
, 2) AMOUNT
, T.CURRENCYNAMECODE
, T.ACCTNO
, T.REFINFO
, T.MEMO
, T.TANGIBLEID
, E.PMTSCHEMEID
, C.REFERENCECODE
, C.SRVID
, C.PSREQID
, C.PROCESSFEE
, C.SPLITID
, BK.BANKACCOUNTID
, BK.ADDRESSID
, BK.FINAME
, BK.ACCTTYPEID
, BK.BRANCHNAME
, BK.ROUTINGNO
, BK.INSTRNAME
, BK.ACCOUNT_HOLDER_NAME
, B.ORG_ID
, B.NLSLANG
, P.KEY
, Y.ACCTTYPE
, PY.NAME
, T.ORDER_MEDIUM
, T.EFT_AUTH_METHOD
FROM IBY_TRXN_SUMMARIES_ALL B
, IBY_TRXN_FI C
, IBY_PMTSCHEMES E
, IBY_TANGIBLE T
, IBY_BANKACCT BK
, IBY_BEPKEYS P
, IBY_ACCTTYPE Y
, IBY_PAYEE PY
WHERE T.MTANGIBLEID = B.MTANGIBLEID
AND B.TRXNMID = C.TRXNMID
AND B.BEPID = E.BEPID
AND B.PAYERINSTRID = BK.INSTRID
AND B.PAYEEID = P.OWNERID
AND BK.ACCTTYPEID = Y.ACCTTYPEID
AND B.BEPID = P.BEPID
AND E.PMTSCHEMENAME = 'BANKACCOUNT'
AND PY.PAYEEID = B.PAYEEID

Columns