View: IBY_TRANS_PCARD_V

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

View Text

SELECT B.TRANSACTIONID
, B.BEPKEY
, B.PAYEEID
, B.BEPID
, B.ECAPPID
, B.TRXNMID
, B.PAYERID
, B.PAYERINSTRID
, PR.CHNAME
, PR.CCNUMBER PCNUMBER
, PR.EXPIRYDATE
, PR.SUBTYPE
, 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
, C.PONUMBER
, C.TAXAMOUNT
, C.SHIPTOZIP
, C.SHIPFROMZIP
, 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
, T.ORDER_MEDIUM
, T.EFT_AUTH_METHOD
FROM IBY_TRXN_SUMMARIES_ALL B
, IBY_TRXN_CORE C
, IBY_TANGIBLE T
, IBY_CREDITCARD PR
, HZ_LOCATIONS L
, IBY_ACCTTYPE Y
WHERE B.TRXNMID = C.TRXNMID
AND T.MTANGIBLEID = B.MTANGIBLEID
AND B.PAYERINSTRID = PR.INSTRID
AND PR.ACCTTYPEID = Y.ACCTTYPEID
AND PR.ADDRESSID = L.LOCATION_ID(+)
AND B.INSTRTYPE = 'PURCHASECARD'
AND B.BEPID IN (SELECT DISTINCT BEPID
FROM IBY_PMTSCHEMES
WHERE PMTSCHEMENAME = 'PURCHASECARD')

Columns