DBA Data[Home] [Help]

VIEW: APPS.IBY_XML_FD_DOC_ERR_1_0_V

Source

View Text - Preformatted

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
View Text - HTML Formatted

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