View: IBY_TRXN_EXT_AUTHS_V

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

View Text

SELECT X.TRXN_EXTENSION_ID
, P.PAYMENT_CHANNEL_CODE
, P.PAYMENT_CHANNEL_NAME
, X.INSTR_ASSIGNMENT_ID
, O.TRANSACTIONID
, DECODE(A.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' )
, A.STATUS
, A.UPDATEDATE
, A.AMOUNT
, DECODE( SIGN((A.UPDATEDATE+NVL(I.AUTHORIZATION_VALIDITY_PERIOD
, 0))- DECODE(I.AUTHORIZATION_VALIDITY_PERIOD
, NULL
, A.UPDATEDATE-10
, SYSDATE) )
, 0
, 0
, -1
, 0
, A.AMOUNT )
, A.PAYEEID
, A.PROCESS_PROFILE_CODE
, A.INSTRTYPE
, A.TANGIBLEID
, A.BEPCODE
, A.BEPMESSAGE
, C.AUTHCODE
, C.AVSCODE
, C.CVV2RESULT
, NVL(SEFT.SETTLE_REQUIRE_VRFY_FLAG
, 'N')
FROM IBY_FNDCPT_PMT_CHNNLS_VL P
, IBY_FNDCPT_TX_EXTENSIONS X
, IBY_FNDCPT_TX_OPERATIONS O
, IBY_TRXN_SUMMARIES_ALL A
, IBY_TRXN_CORE C
, IBY_CREDITCARD_ISSUERS_B I
, IBY_FNDCPT_SYS_EFT_PF_B SEFT
, IBY_FNDCPT_USER_EFT_PF_B UEFT
WHERE (X.PAYMENT_CHANNEL_CODE = P.PAYMENT_CHANNEL_CODE)
AND (X.TRXN_EXTENSION_ID = O.TRXN_EXTENSION_ID)
AND (O.TRANSACTIONID = A.TRANSACTIONID)
AND (A.INSTRSUBTYPE = I.CARD_ISSUER_CODE(+))
AND (DECODE(INSTRTYPE
, 'BANKACCOUNT'
, A.PROCESS_PROFILE_CODE
, NULL) = UEFT.USER_EFT_PROFILE_CODE(+))
AND (UEFT.SYS_EFT_PROFILE_CODE = SEFT.SYS_EFT_PROFILE_CODE(+))
AND (A.TRXNMID = C.TRXNMID)
AND (A.REQTYPE = 'ORAPMTREQ')
AND (A.TRXNTYPEID IN (2
, 3
, 20))

Columns