VIEW: APPS.IBY_TRANS_FI_V

Source

View Text - Preformatted

SELECT b.TransactionId, b.PayeeId, b.BEPID, b.ECAppID, b.trxnMID, b.payerid, b.payerinstrid, b.payeeinstrid, 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, b.org_id, b.nlslang, p.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_payee p WHERE t.mtangibleid = b.mtangibleid and b.trxnMID = c.trxnMID and b.bepid = e.bepid and p.payeeid = b.payeeid and e.pmtschemename = 'FI'

View Text - HTML Formatted

SELECT B.TRANSACTIONID
, B.PAYEEID
, B.BEPID
, B.ECAPPID
, B.TRXNMID
, B.PAYERID
, B.PAYERINSTRID
, B.PAYEEINSTRID
, 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
, B.ORG_ID
, B.NLSLANG
, P.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_PAYEE P
WHERE T.MTANGIBLEID = B.MTANGIBLEID
AND B.TRXNMID = C.TRXNMID
AND B.BEPID = E.BEPID
AND P.PAYEEID = B.PAYEEID
AND E.PMTSCHEMENAME = 'FI'