[Home] [Help]
View: IBY_SINGLE_REJECTED_DOC_XML_V
View Text
SELECT XMLCONCAT( XMLELEMENT("DOCUMENTGROUP"
, XMLELEMENT("FNDAPPLICATIONID"
, REQ.CALLING_APP_ID)
, 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.CALLING_APP_ID
, DOCS.DOCUMENT_PAYABLE_ID
, DOCS.DOCUMENT_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'
Columns
Name |
DOCUMENT_CONTENT |
CALLING_APP_ID |
DOCUMENT_ID |
DOCUMENT_STATUS |