eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: IBY_TRANS_ALL_V

Product:	IBY - Payments
Description:	View used to work with transactions.
Implementation/DBA Data:	APPS.IBY_TRANS_ALL_V

View Text

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

Columns

Name
TRANSACTIONID
TANGIBLEID
PAYEEID
BEPID
ECAPPID
TRXNMID
AMOUNT
CURRENCYNAMECODE
REQDATE
REQTYPE
STATUS
SETTLEDATE
UPDATEDATE
TRXNTYPEID
TRXNREF
ERRORLOCATION
BEPCODE
BEPMESSAGE
BATCHID
NEEDSUPDT
ORG_ID
PAYMENTMETHODNAME
MTANGIBLEID
DETAILLOOKUP
REQSEQ
DESTURL
NLSLANG
TERMINALID
TRACENUMBER
AUTHCODE
REFERENCECODE
OPERATIONCODE
INSTRNAME
AUTHTYPE
AVSCODE
ACQUIRER
AUXMSG
ACCTNO
REFINFO
MEMO
ORDER_MEDIUM
EFT_AUTH_METHOD