VIEW: APPS.IBY_XML_FD_PPR_1_0_V

Source

View Text - Preformatted

SELECT XMLElement("PaymentProcessRequest", XMLElement("PaymentProcessRequestInfo", XMLElement("ApplicationInternalID", ppr.CALLING_APP_ID), XMLElement("ApplicationName", ppr.APPLICATION_NAME), XMLElement("SourceProductReference", ppr.call_app_pay_service_req_code), XMLElement("SubmissionDate", TO_CHAR(ppr.creation_date, 'YYYY-MM-DD"T"HH24:MI:SS')), XMLElement("MultiOrgAccessControl", XMLElement("HasBlockedData", IBY_FD_POST_PICP_PROGS_PVT.check_ppr_moac_blocking(ppr.payment_service_request_id)) ), XMLElement("PaymentProcessRequestStatus", XMLElement("Code", ppr.payment_service_request_status), XMLElement("Meaning", ppr.ppr_status_meaning) ), XMLElement("ProcessType", XMLElement("Code", ppr.process_type), XMLElement("Meaning", ppr.ppr_process_type_meaning) ), CASE WHEN ppr.ppr_attr_cat IS NULL THEN NULL ELSE XMLElement("DescriptiveFlexField", IBY_EXTRACTGEN_PVT.Get_Dffs( 'IBY_PAY_SERVICE_REQUESTS', ppr.payment_service_request_id, NULL)) END ), IBY_FD_EXTRACT_GEN_PVT.Get_Ppr_PmtAgg(ppr.payment_service_request_id), XMLElement("PaymentCount", IBY_FD_EXTRACT_GEN_PVT.Get_Ppr_PmtCount(ppr.payment_service_request_id)), XMLElement("PreBuildDocumentsPayable", IBY_FD_EXTRACT_GEN_PVT.Get_Ppr_PreBuildDocAgg(ppr.payment_service_request_id), XMLElement("DocumentCount", IBY_FD_EXTRACT_GEN_PVT.Get_Ppr_PreBuildDocCount(ppr.payment_service_request_id))), IBY_EXT_WRAP_PUB.Get_Ppr_Ext_Agg(ppr.payment_service_request_id) ), ppr.payment_service_request_id FROM iby_ext_fd_ppr_1_0_v ppr

View Text - HTML Formatted

SELECT XMLELEMENT("PAYMENTPROCESSREQUEST"
, XMLELEMENT("PAYMENTPROCESSREQUESTINFO"
, XMLELEMENT("APPLICATIONINTERNALID"
, PPR.CALLING_APP_ID)
, XMLELEMENT("APPLICATIONNAME"
, PPR.APPLICATION_NAME)
, XMLELEMENT("SOURCEPRODUCTREFERENCE"
, PPR.CALL_APP_PAY_SERVICE_REQ_CODE)
, XMLELEMENT("SUBMISSIONDATE"
, TO_CHAR(PPR.CREATION_DATE
, 'YYYY-MM-DD"T"HH24:MI:SS'))
, XMLELEMENT("MULTIORGACCESSCONTROL"
, XMLELEMENT("HASBLOCKEDDATA"
, IBY_FD_POST_PICP_PROGS_PVT.CHECK_PPR_MOAC_BLOCKING(PPR.PAYMENT_SERVICE_REQUEST_ID)) )
, XMLELEMENT("PAYMENTPROCESSREQUESTSTATUS"
, XMLELEMENT("CODE"
, PPR.PAYMENT_SERVICE_REQUEST_STATUS)
, XMLELEMENT("MEANING"
, PPR.PPR_STATUS_MEANING) )
, XMLELEMENT("PROCESSTYPE"
, XMLELEMENT("CODE"
, PPR.PROCESS_TYPE)
, XMLELEMENT("MEANING"
, PPR.PPR_PROCESS_TYPE_MEANING) )
, CASE WHEN PPR.PPR_ATTR_CAT IS NULL THEN NULL ELSE XMLELEMENT("DESCRIPTIVEFLEXFIELD"
, IBY_EXTRACTGEN_PVT.GET_DFFS( 'IBY_PAY_SERVICE_REQUESTS'
, PPR.PAYMENT_SERVICE_REQUEST_ID
, NULL)) END )
, IBY_FD_EXTRACT_GEN_PVT.GET_PPR_PMTAGG(PPR.PAYMENT_SERVICE_REQUEST_ID)
, XMLELEMENT("PAYMENTCOUNT"
, IBY_FD_EXTRACT_GEN_PVT.GET_PPR_PMTCOUNT(PPR.PAYMENT_SERVICE_REQUEST_ID))
, XMLELEMENT("PREBUILDDOCUMENTSPAYABLE"
, IBY_FD_EXTRACT_GEN_PVT.GET_PPR_PREBUILDDOCAGG(PPR.PAYMENT_SERVICE_REQUEST_ID)
, XMLELEMENT("DOCUMENTCOUNT"
, IBY_FD_EXTRACT_GEN_PVT.GET_PPR_PREBUILDDOCCOUNT(PPR.PAYMENT_SERVICE_REQUEST_ID)))
, IBY_EXT_WRAP_PUB.GET_PPR_EXT_AGG(PPR.PAYMENT_SERVICE_REQUEST_ID) )
, PPR.PAYMENT_SERVICE_REQUEST_ID
FROM IBY_EXT_FD_PPR_1_0_V PPR