Product: | IBY - Payments |
---|---|
Description: | |
Implementation/DBA Data: | APPS.IBY_TRANSACTIONS_V |
SELECT TANGIBLEID ORDER_ID
, BEPKEY
, PAYEEID MERCHANT_ID
, BEPID VENDOR_ID
, TRXNTYPEID TRXN_TYPE
, AMOUNT
, CURRENCYNAMECODE CURRENCY
, UPDATEDATE TIME
, STATUS
, PAYMENTMETHODNAME PAYMENT_TYPE
, BATCHID MERCHBATCHID
, INSTRNAME PAYMENT_NAME
, AUTHCODE
, AVSCODE
, REFERENCECODE
, ERRORLOCATION ERROR_LOCATION
, BEPCODE VENDOR_CODE
, ACQUIRER
, BEPMESSAGE VENDOR_MESSAGE
, AUXMSG
, TERMINALID
, TRACENUMBER
, ORG_ID
FROM IBY_TRXN_SUMMARIES_ALL
, IBY_TRXN_CORE
WHERE IBY_TRXN_SUMMARIES_ALL.TRXNMID = IBY_TRXN_CORE .TRXNMID