SELECT XMLConcat( XMLElement("PaymentProcessRequest", XMLElement("FNDApplicationID", req.calling_app_id), XMLElement("CallingAppPayProcessRequestCode", req.call_app_pay_service_req_code) ) ), req.payment_service_request_id, req.payment_service_request_status FROM iby_pay_service_requests req
SELECT XMLCONCAT( XMLELEMENT("PAYMENTPROCESSREQUEST"
, XMLELEMENT("FNDAPPLICATIONID"
, REQ.CALLING_APP_ID)
, XMLELEMENT("CALLINGAPPPAYPROCESSREQUESTCODE"
, REQ.CALL_APP_PAY_SERVICE_REQ_CODE) ) )
, REQ.PAYMENT_SERVICE_REQUEST_ID
, REQ.PAYMENT_SERVICE_REQUEST_STATUS
FROM IBY_PAY_SERVICE_REQUESTS REQ
|
|
|