[Home] [Help]
View: 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
Name |
DOCUMENT_PAYABLE_ID |
TRANSACTION_ERROR_ID |
ERROR_TYPE |
ERROR_TYPE_MEANING |
ERROR_CODE |
ERROR_MESSAGE |
ERROR_DATE |
ERROR_STATUS |
ERROR_STATUS_MEANING |