VIEW: APPS.IBY_EXT_FD_PMT_ERR_1_0_V

Source

View Text - Preformatted

SELECT PMT.PAYMENT_ID,ERR.TRANSACTION_ERROR_ID,ERR.ERROR_TYPE,FND_ERR_TYPE_LOOKUP.MEANING,ERR.ERROR_CODE,ERR.ERROR_MESSAGE,ERR.ERROR_DATE,ERR.ERROR_STATUS,FND_ERR_TYPE_LOOKUP.MEANING FROM IBY_PAYMENTS_ALL PMT,IBY_TRANSACTION_ERRORS ERR,FND_LOOKUPS FND_ERR_TYPE_LOOKUP,FND_LOOKUPS FND_ERR_ST_LOOKUP WHERE pmt.payment_id = err.transaction_id AND err.transaction_type = 'PAYMENT' AND err.error_type = fnd_err_type_lookup.lookup_code(+) AND fnd_err_type_lookup.lookup_type(+) = 'IBY_TRANSACTION_ERROR_TYPES' AND err.error_status = fnd_err_st_lookup.lookup_code AND fnd_err_st_lookup.lookup_type = 'IBY_TRANSACTION_ERROR_STATUSES'

View Text - HTML Formatted

SELECT PMT.PAYMENT_ID
, ERR.TRANSACTION_ERROR_ID
, ERR.ERROR_TYPE
, FND_ERR_TYPE_LOOKUP.MEANING
, ERR.ERROR_CODE
, ERR.ERROR_MESSAGE
, ERR.ERROR_DATE
, ERR.ERROR_STATUS
, FND_ERR_TYPE_LOOKUP.MEANING
FROM IBY_PAYMENTS_ALL PMT
, IBY_TRANSACTION_ERRORS ERR
, FND_LOOKUPS FND_ERR_TYPE_LOOKUP
, FND_LOOKUPS FND_ERR_ST_LOOKUP
WHERE PMT.PAYMENT_ID = ERR.TRANSACTION_ID
AND ERR.TRANSACTION_TYPE = 'PAYMENT'
AND ERR.ERROR_TYPE = FND_ERR_TYPE_LOOKUP.LOOKUP_CODE(+)
AND FND_ERR_TYPE_LOOKUP.LOOKUP_TYPE(+) = 'IBY_TRANSACTION_ERROR_TYPES'
AND ERR.ERROR_STATUS = FND_ERR_ST_LOOKUP.LOOKUP_CODE
AND FND_ERR_ST_LOOKUP.LOOKUP_TYPE = 'IBY_TRANSACTION_ERROR_STATUSES'