VIEW: APPS.IBY_TRXN_EXT_SETTLEMENTS_V

Source

View Text - Preformatted

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, s.initiator_extension_id, x.origin_application_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 IN ('CREDITCARD', 'PURCHASECARD') AND s.reqtype = 'ORAPMTCAPTURE') OR (s.instrtype = 'PINLESSDEBITCARD' AND s.reqtype = 'ORAPMTREQ') OR (s.instrtype = 'BANKACCOUNT' AND s.trxntypeid IS NULL) )

View Text - HTML Formatted

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
, S.INITIATOR_EXTENSION_ID
, X.ORIGIN_APPLICATION_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 IN ('CREDITCARD'
, 'PURCHASECARD')
AND S.REQTYPE = 'ORAPMTCAPTURE') OR (S.INSTRTYPE = 'PINLESSDEBITCARD'
AND S.REQTYPE = 'ORAPMTREQ') OR (S.INSTRTYPE = 'BANKACCOUNT'
AND S.TRXNTYPEID IS NULL) )