View: IBY_EXT_FD_DOC_ERR_1_0_V

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

View Text

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'

Columns