IBY_XML_FD_PPR_1_0

Details

Schema: FUSION
Object owner: IBY
Object type: VIEW

Columns

Name
PAYMENT_PROCESS_REQUEST PAYMENT_SERVICE_REQUEST_ID

Name

PAYMENT_PROCESS_REQUEST

PAYMENT_SERVICE_REQUEST_ID

Query

SQL_Statement
SELECT XMLElement("PaymentProcessRequest", XMLElement("RecordHistory",XMLElement("CreatedBy",ppr.created_by),XMLElement("CreationDate",TO_CHAR(ppr.creation_date, 'YYYY-MM-DD"T"HH24:MI:SS')),XMLElement("LastUpdateDate",to_char(ppr.last_update_date, 'YYYY-MM-DD"T"HH24:MI:SS')),XMLElement("LastUpdateLogin",ppr.last_update_login),XMLElement("LastUpdatedBy",ppr.last_updated_by)),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_FD_EXTRACT_EXT_PUB.Get_Ppr_Ext_Agg(ppr.payment_service_request_id) ), ppr.payment_service_request_id FROM iby_ext_fd_ppr_1_0_v ppr

SQL_Statement

SELECT XMLElement("PaymentProcessRequest", XMLElement("RecordHistory",XMLElement("CreatedBy",ppr.created_by),XMLElement("CreationDate",TO_CHAR(ppr.creation_date, 'YYYY-MM-DD"T"HH24:MI:SS')),XMLElement("LastUpdateDate",to_char(ppr.last_update_date, 'YYYY-MM-DD"T"HH24:MI:SS')),XMLElement("LastUpdateLogin",ppr.last_update_login),XMLElement("LastUpdatedBy",ppr.last_updated_by)),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_FD_EXTRACT_EXT_PUB.Get_Ppr_Ext_Agg(ppr.payment_service_request_id) ), ppr.payment_service_request_id FROM iby_ext_fd_ppr_1_0_v ppr