DBA Data[Home] [Help]

VIEW: APPS.IBY_XML_FD_PMT_ERR_1_0_V

Source

View Text - Preformatted

SELECT XMLElement("PaymentError", XMLElement("ErrorType", XMLElement("Code", pmt_err.error_type), XMLElement("Meaning", pmt_err.error_type_meaning) ), XMLElement("ErrorCode", pmt_err.error_code), XMLElement("ErrorMessage", pmt_err.error_message), XMLElement("ErrorMessage", pmt_err.error_date), XMLElement("ErrorStatus", XMLElement("Code", pmt_err.error_status), XMLElement("Meaning", pmt_err.error_status_meaning) ) ), pmt_err.payment_id FROM iby_ext_fd_pmt_err_1_0_v pmt_err
View Text - HTML Formatted

SELECT XMLELEMENT("PAYMENTERROR"
, XMLELEMENT("ERRORTYPE"
, XMLELEMENT("CODE"
, PMT_ERR.ERROR_TYPE)
, XMLELEMENT("MEANING"
, PMT_ERR.ERROR_TYPE_MEANING) )
, XMLELEMENT("ERRORCODE"
, PMT_ERR.ERROR_CODE)
, XMLELEMENT("ERRORMESSAGE"
, PMT_ERR.ERROR_MESSAGE)
, XMLELEMENT("ERRORMESSAGE"
, PMT_ERR.ERROR_DATE)
, XMLELEMENT("ERRORSTATUS"
, XMLELEMENT("CODE"
, PMT_ERR.ERROR_STATUS)
, XMLELEMENT("MEANING"
, PMT_ERR.ERROR_STATUS_MEANING) ) )
, PMT_ERR.PAYMENT_ID
FROM IBY_EXT_FD_PMT_ERR_1_0_V PMT_ERR