VIEW: APPS.IBY_TRANS_SET_V

Source

View Text - Preformatted

SELECT b.TransactionId, b.TangibleId, b.PayeeId, b.BEPID, b.ECAppID, b.trxnMID, e.PmtSchemeId, round(b.amount,2) amount, b.CurrencyNameCode, b.ReqDate, b.ReqType, b.Status, b.SettleDate, b.UpdateDate, b.TrxnTYpeid, b.ErrorLocation, b.BEPCode, b.BEPMessage, b.BatchID , b.destURL, b.NeedsUpdt, c.SETTrxnID, c.CompletionCode, c.SplitID, c.TerminalID, c.SubAuthInd, c.Cardbin, c.BatchSeqNum, c.BatchTrxnStatus, c.SETReqType, c.PrevSplitID, c.SubsAuthType, c.SplitShipment, c.AuthCurrency, c.AuthPrice, c.InstallTotalTrxns, c.RecurringFreq, c.RecurringExpDate, c.CustRefNum, c.DestPostalCode, c.LocalTaxPrice, c.LocalTaxCurrency, c.CreditCounter, b.org_id from iby_trxn_summaries_all b, iby_trxn_extended c, iby_pmtschemes e WHERE b.trxnMID = c.trxnMID and b.bepid = e.bepid

View Text - HTML Formatted

SELECT B.TRANSACTIONID
, B.TANGIBLEID
, B.PAYEEID
, B.BEPID
, B.ECAPPID
, B.TRXNMID
, E.PMTSCHEMEID
, ROUND(B.AMOUNT
, 2) AMOUNT
, B.CURRENCYNAMECODE
, B.REQDATE
, B.REQTYPE
, B.STATUS
, B.SETTLEDATE
, B.UPDATEDATE
, B.TRXNTYPEID
, B.ERRORLOCATION
, B.BEPCODE
, B.BEPMESSAGE
, B.BATCHID
, B.DESTURL
, B.NEEDSUPDT
, C.SETTRXNID
, C.COMPLETIONCODE
, C.SPLITID
, C.TERMINALID
, C.SUBAUTHIND
, C.CARDBIN
, C.BATCHSEQNUM
, C.BATCHTRXNSTATUS
, C.SETREQTYPE
, C.PREVSPLITID
, C.SUBSAUTHTYPE
, C.SPLITSHIPMENT
, C.AUTHCURRENCY
, C.AUTHPRICE
, C.INSTALLTOTALTRXNS
, C.RECURRINGFREQ
, C.RECURRINGEXPDATE
, C.CUSTREFNUM
, C.DESTPOSTALCODE
, C.LOCALTAXPRICE
, C.LOCALTAXCURRENCY
, C.CREDITCOUNTER
, B.ORG_ID
FROM IBY_TRXN_SUMMARIES_ALL B
, IBY_TRXN_EXTENDED C
, IBY_PMTSCHEMES E
WHERE B.TRXNMID = C.TRXNMID
AND B.BEPID = E.BEPID