IBY_EXT_FD_DOC_ERR_1_0_V

Details

• Schema: FUSION

• Object owner: IBY

• Object type: VIEW

Columns

Name
DOCUMENT_PAYABLE_ID TRANSACTION_ERROR_ID ERROR_TYPE ERROR_TYPE_MEANING ERROR_CODE ERROR_MESSAGE ERROR_DATE ERROR_STATUS ERROR_STATUS_MEANING

Query

SQL_Statement

SELECT DOC.DOCUMENT_PAYABLE_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_DOCS_PAYABLE_ALL DOC,IBY_TRANSACTION_ERRORS ERR,FND_LOOKUPS FND_ERR_TYPE_LOOKUP,FND_LOOKUPS FND_ERR_ST_LOOKUP WHERE doc.document_payable_id = err.transaction_id AND err.transaction_type = 'DOCUMENT_PAYABLE' 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'