View: IBY_EXT_FD_PMT_ERR_1_0_V

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

View Text

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'

Columns