View: IBY_TRANS_SET_V

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

View Text

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

Columns