View: IBY_REJECTED_DOCS_XML_V

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

View Text

SELECT XMLCONCAT( XMLELEMENT("DOCUMENTGROUP"
, XMLELEMENT("FNDAPPLICATIONID"
, REQ.CALLING_APP_ID)
, XMLAGG( XMLELEMENT("REJECTEDDOCUMENTS"
, XMLFOREST( DOCS.PAY_PROC_TRXN_TYPE_CODE AS "PAYMENTPROCESSTRXNTYPECODE"
, REQ.CALLING_APP_ID AS "CALLINGAPPID"
, DOCS.CALLING_APP_DOC_UNIQUE_REF1 AS "CALLINGAPPDOCUNIQUEREF1"
, DOCS.CALLING_APP_DOC_UNIQUE_REF2 AS "CALLINGAPPDOCUNIQUEREF2"
, DOCS.CALLING_APP_DOC_UNIQUE_REF3 AS "CALLINGAPPDOCUNIQUEREF3"
, DOCS.CALLING_APP_DOC_UNIQUE_REF4 AS "CALLINGAPPDOCUNIQUEREF4"
, DOCS.CALLING_APP_DOC_UNIQUE_REF5 AS "CALLINGAPPDOCUNIQUEREF5" ) ) ) ) )
, REQ.PAYMENT_SERVICE_REQUEST_ID
, REQ.PAYMENT_SERVICE_REQUEST_STATUS
FROM IBY_DOCS_PAYABLE_ALL DOCS
, IBY_PAY_SERVICE_REQUESTS REQ
WHERE REQ.PAYMENT_SERVICE_REQUEST_ID = DOCS.PAYMENT_SERVICE_REQUEST_ID
AND DOCS.DOCUMENT_STATUS != 'VALIDATED'
AND DOCS.PAYMENT_ID IS NULL GROUP BY REQ.CALLING_APP_ID
, REQ.PAYMENT_SERVICE_REQUEST_ID
, REQ.PAYMENT_SERVICE_REQUEST_STATUS

Columns