[Home] [Help]
View: IBY_XML_FD_PMT_ERR_1_0_V
View Text
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
Columns
Name |
PAYMENT_ERROR |
PAYMENT_ID |