View: IBY_TRXN_EXT_SETTLEMENTS_V

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

View Text

SELECT S.TRANSACTIONID
, X.TRXN_EXTENSION_ID
, S.MBATCHID
, X.PAYMENT_CHANNEL_CODE
, X.INSTR_ASSIGNMENT_ID
, DECODE(S.STATUS
, 0
, 'SETTLEMENT_SUCCESS'
, 1
, 'COMMUNICATION_ERROR'
, 2
, 'DUPLICATE_SETTLEMENT'
, 4
, 'GENERAL_INVALID_PARAM'
, 5
, 'PAYMENT_SYS_REJECT'
, 11
, 'SETTLEMENT_PENDING'
, 12
, 'SETTLEMENT_PENDING'
, 13
, 'SETTLEMENT_PENDING'
, 16
, 'PAYMENT_SYS_REJECT'
, 17
, 'PAYMENT_SYS_REJECT'
, 18
, 'SETTLEMENT_PENDING'
, 19
, 'GENERAL_INVALID_PARAM'
, 20
, 'PAYMENT_SYS_REJECT'
, 100
, 'SETTLEMENT_PENDING'
, 101
, 'COMMUNICATION_ERROR'
, 111
, 'SETTLEMENT_PENDING'
, 'GENERAL_SYS_ERROR' )
, S.UPDATEDATE
, S.BEPCODE
, S.BEPMESSAGE
, S.TANGIBLEID
, S.PAYEEID
, S.ORG_TYPE
, S.ORG_ID
FROM IBY_FNDCPT_TX_EXTENSIONS X
, IBY_FNDCPT_TX_OPERATIONS O
, IBY_TRXN_SUMMARIES_ALL S
WHERE (X.TRXN_EXTENSION_ID = O.TRXN_EXTENSION_ID)
AND (O.TRANSACTIONID = S.TRANSACTIONID)
AND ( (S.INSTRTYPE = 'CREDITCARD'
AND S.REQTYPE = 'ORAPMTCAPTURE') OR (S.INSTRTYPE = 'PINLESSDEBITCARD'
AND S.REQTYPE = 'ORAPMTREQ') OR (S.INSTRTYPE = 'BANKACCOUNT'
AND S.TRXNTYPEID IS NULL) )

Columns