DBA Data[Home] [Help]

VIEW: APPS.IBY_NOTIFY_REQ_XML_V

Source

View Text - Preformatted

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

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