VIEW: APPS.IBY_EXTN_RETURNS_V

Source

View Text - Preformatted

SELECT returntrxn.trxn_extension_id, decode(returntrxn.status, NULL, 'N', 'Y') , decode(returntrxn.status, 0, 'RETURN_SUCCESS', 100, 'RETURN_PENDING', 111, 'RETURN_PENDING', NULL) FROM (SELECT op.trxn_extension_id, summ.status, Rank() over (PARTITION BY Op.Trxn_Extension_Id ORDER BY op.Transactionid ) rank FROM iby_trxn_summaries_all summ, iby_fndcpt_tx_operations op WHERE (summ.transactionid = op.transactionid) AND(reqtype = 'ORAPMTRETURN') AND(status IN(0, 100, 111))) returntrxn WHERE returntrxn.rank = 1

View Text - HTML Formatted

SELECT RETURNTRXN.TRXN_EXTENSION_ID
, DECODE(RETURNTRXN.STATUS
, NULL
, 'N'
, 'Y')
, DECODE(RETURNTRXN.STATUS
, 0
, 'RETURN_SUCCESS'
, 100
, 'RETURN_PENDING'
, 111
, 'RETURN_PENDING'
, NULL)
FROM (SELECT OP.TRXN_EXTENSION_ID
, SUMM.STATUS
, RANK() OVER (PARTITION BY OP.TRXN_EXTENSION_ID ORDER BY OP.TRANSACTIONID ) RANK
FROM IBY_TRXN_SUMMARIES_ALL SUMM
, IBY_FNDCPT_TX_OPERATIONS OP
WHERE (SUMM.TRANSACTIONID = OP.TRANSACTIONID) AND(REQTYPE = 'ORAPMTRETURN') AND(STATUS IN(0
, 100
, 111))) RETURNTRXN
WHERE RETURNTRXN.RANK = 1