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
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
|
|
|