View: IBY_TRANS_CORE_V

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

View Text

SELECT B.TRANSACTIONID
, B.BEPKEY
, B.PAYEEID
, B.BEPID
, B.ECAPPID
, B.TRXNMID
, B.PAYERID
, B.PAYERINSTRID
, CR.CHNAME
, CR.CCNUMBER
, CR.EXPIRYDATE
, Y.ACCTTYPE
, 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
, C.AUTHCODE
, C.REFERENCECODE
, C.OPERATIONCODE
, C.INSTRNAME
, C.AUTHTYPE
, C.AVSCODE
, C.ACQUIRER
, C.AUXMSG
, L.ADDRESS1
, L.ADDRESS2
, L.ADDRESS3
, L.CITY
, L.STATE
, L.POSTAL_CODE ZIP
, L.COUNTY
, L.COUNTRY
, B.ORG_ID
, B.NLSLANG
, C.VOICEAUTHFLAG
, C.DEBIT_NETWORK_CODE
, C.SURCHARGE_AMOUNT
, C.PROC_TRACENUMBER
, T.ORDER_MEDIUM
, T.EFT_AUTH_METHOD
FROM IBY_TRXN_SUMMARIES_ALL B
, IBY_TRXN_CORE C
, IBY_TANGIBLE T
, IBY_CREDITCARD CR
, HZ_LOCATIONS L
, IBY_ACCTTYPE Y
WHERE B.TRXNMID = C.TRXNMID
AND T.MTANGIBLEID = B.MTANGIBLEID
AND B.PAYERINSTRID = CR.INSTRID
AND CR.ACCTTYPEID = Y.ACCTTYPEID
AND CR.SUBTYPE IS NULL
AND CR.ADDRESSID = L.LOCATION_ID(+)
AND B.BEPID IN (SELECT DISTINCT BEPID
FROM IBY_PMTSCHEMES
WHERE PMTSCHEMENAME = 'SSL')

Columns