IBY_EXT_FD_PMT_ERR_1_0_V

Details

• Schema: FUSION

• Object owner: IBY

• Object type: VIEW

Columns

Name
PAYMENT_ID TRANSACTION_ERROR_ID ERROR_TYPE ERROR_TYPE_MEANING ERROR_CODE ERROR_MESSAGE ERROR_DATE ERROR_STATUS ERROR_STATUS_MEANING

Query

SQL_Statement

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'