VIEW: APPS.IBY_TRANS_ALL_V

Source

View Text - Preformatted

SELECT tall.TransactionId, tall.TangibleId, tall.PayeeId, tall.BEPID, tall.ECAppID, tall.trxnMID, tall.amount, tall.CurrencyNameCode, tall.ReqDate, tall.ReqType, tall.Status, tall.SettleDate, tall.UpdateDate, tall.TrxnTYpeid, tall.TrxnRef, tall.ErrorLocation, tall.BEPCode, tall.BEPMessage, tall.BatchID , tall.NeedsUpdt, tall.org_id, tall.paymentmethodname, tall.mtangibleid, tall.detaillookup, tall.reqseq, tall.desturl, tall.nlslang, tcore.terminalid, tcore.tracenumber, tcore.authcode, tcore.referencecode, tcore.operationcode, tcore.instrname, tcore.authtype, tcore.avscode, tcore.acquirer, tcore.auxmsg, tan.acctno, tan.refinfo, tan.memo, tan.order_medium, tan.eft_auth_method FROM IBY_TRXN_SUMMARIES_ALL TALL,IBY_TRXN_CORE TCORE,IBY_TANGIBLE TAN WHERE tall.trxnmid = tcore.trxnmid and tall.mtangibleid = tan.mtangibleid

View Text - HTML Formatted

SELECT TALL.TRANSACTIONID
, TALL.TANGIBLEID
, TALL.PAYEEID
, TALL.BEPID
, TALL.ECAPPID
, TALL.TRXNMID
, TALL.AMOUNT
, TALL.CURRENCYNAMECODE
, TALL.REQDATE
, TALL.REQTYPE
, TALL.STATUS
, TALL.SETTLEDATE
, TALL.UPDATEDATE
, TALL.TRXNTYPEID
, TALL.TRXNREF
, TALL.ERRORLOCATION
, TALL.BEPCODE
, TALL.BEPMESSAGE
, TALL.BATCHID
, TALL.NEEDSUPDT
, TALL.ORG_ID
, TALL.PAYMENTMETHODNAME
, TALL.MTANGIBLEID
, TALL.DETAILLOOKUP
, TALL.REQSEQ
, TALL.DESTURL
, TALL.NLSLANG
, TCORE.TERMINALID
, TCORE.TRACENUMBER
, TCORE.AUTHCODE
, TCORE.REFERENCECODE
, TCORE.OPERATIONCODE
, TCORE.INSTRNAME
, TCORE.AUTHTYPE
, TCORE.AVSCODE
, TCORE.ACQUIRER
, TCORE.AUXMSG
, TAN.ACCTNO
, TAN.REFINFO
, TAN.MEMO
, TAN.ORDER_MEDIUM
, TAN.EFT_AUTH_METHOD
FROM IBY_TRXN_SUMMARIES_ALL TALL
, IBY_TRXN_CORE TCORE
, IBY_TANGIBLE TAN
WHERE TALL.TRXNMID = TCORE.TRXNMID
AND TALL.MTANGIBLEID = TAN.MTANGIBLEID