VIEW: APPS.IBY_EXTN_AUTHORIZATIONS_V

Source

View Text - Preformatted

SELECT op.trxn_extension_id, decode(summ.status, NULL, 'N', 'Y') , decode(summ.status, 0, 'AUTH_SUCCESS', 100, 'AUTH_PENDING', 111, 'AUTH_PENDING', NULL) FROM iby_trxn_summaries_all summ, iby_fndcpt_tx_operations op WHERE (summ.transactionid = op.transactionid) AND(reqtype = 'ORAPMTREQ') AND(status IN(0, 100, 111)) AND(op.transactionid = (SELECT MIN(transactionid) FROM iby_fndcpt_tx_operations WHERE trxn_extension_id = op.trxn_extension_id )) AND((trxntypeid IN(2, 3)) OR((trxntypeid = 20) AND(summ.trxnmid = (SELECT MAX(trxnmid) FROM iby_trxn_summaries_all WHERE transactionid = summ.transactionid AND(reqtype = 'ORAPMTREQ') AND(status IN(0, 100, 111)) AND(trxntypeid = 20) ))))

View Text - HTML Formatted

SELECT OP.TRXN_EXTENSION_ID
, DECODE(SUMM.STATUS
, NULL
, 'N'
, 'Y')
, DECODE(SUMM.STATUS
, 0
, 'AUTH_SUCCESS'
, 100
, 'AUTH_PENDING'
, 111
, 'AUTH_PENDING'
, NULL)
FROM IBY_TRXN_SUMMARIES_ALL SUMM
, IBY_FNDCPT_TX_OPERATIONS OP
WHERE (SUMM.TRANSACTIONID = OP.TRANSACTIONID) AND(REQTYPE = 'ORAPMTREQ') AND(STATUS IN(0
, 100
, 111)) AND(OP.TRANSACTIONID = (SELECT MIN(TRANSACTIONID)
FROM IBY_FNDCPT_TX_OPERATIONS
WHERE TRXN_EXTENSION_ID = OP.TRXN_EXTENSION_ID )) AND((TRXNTYPEID IN(2
, 3)) OR((TRXNTYPEID = 20) AND(SUMM.TRXNMID = (SELECT MAX(TRXNMID)
FROM IBY_TRXN_SUMMARIES_ALL
WHERE TRANSACTIONID = SUMM.TRANSACTIONID AND(REQTYPE = 'ORAPMTREQ') AND(STATUS IN(0
, 100
, 111)) AND(TRXNTYPEID = 20) ))))