View: IBY_XML_FD_PPR_1_0_V

Product:	IBY - Payments
Description:
Implementation/DBA Data:	APPS.IBY_XML_FD_PPR_1_0_V

View Text

SELECT XMLELEMENT("PAYMENTPROCESSREQUEST"
, XMLELEMENT("PAYMENTPROCESSREQUESTINFO"
, XMLELEMENT("SOURCEPRODUCTREFERENCE"
, PPR.CALL_APP_PAY_SERVICE_REQ_CODE)
, XMLELEMENT("PAYMENTPROCESSREQUESTREFERENCENUMBER"
, PPR.PAYMENT_SERVICE_REQUEST_ID)
, XMLELEMENT("SUBMISSIONDATE"
, TO_CHAR(PPR.CREATION_DATE
, 'YYYY-MM-DD"T"HH24:MI:SS'))
, 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))) )
, PPR.PAYMENT_SERVICE_REQUEST_ID
FROM IBY_EXT_FD_PPR_1_0_V PPR

Columns