[Home] [Help]
View: IBY_XML_FD_DOC_ERR_1_0_V
View Text
SELECT XMLELEMENT("DOCUMENTERROR"
, XMLELEMENT("ERRORTYPE"
, XMLELEMENT("CODE"
, DOC_ERR.ERROR_TYPE)
, XMLELEMENT("MEANING"
, DOC_ERR.ERROR_TYPE_MEANING) )
, XMLELEMENT("ERRORCODE"
, DOC_ERR.ERROR_CODE)
, XMLELEMENT("ERRORMESSAGE"
, DOC_ERR.ERROR_MESSAGE)
, XMLELEMENT("ERRORMESSAGE"
, DOC_ERR.ERROR_DATE)
, XMLELEMENT("ERRORSTATUS"
, XMLELEMENT("CODE"
, DOC_ERR.ERROR_STATUS)
, XMLELEMENT("MEANING"
, DOC_ERR.ERROR_STATUS_MEANING) ) )
, DOC_ERR.DOCUMENT_PAYABLE_ID
FROM IBY_EXT_FD_DOC_ERR_1_0_V DOC_ERR
Columns
Name |
DOC_PAYABLE_ERROR |
DOCUMENT_PAYABLE_ID |