View: IBY_UNCLEARED_PMT_XML_V

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

View Text

SELECT XMLCONCAT( XMLELEMENT("UNCLEAREDPAYMENT"
, XMLELEMENT("FNDAPPLICATIONID"
, REQ.CALLING_APP_ID)
, XMLELEMENT("PAYMENTID"
, PMT.PAYMENT_ID)
, XMLELEMENT("NEWSTATUS"
, PMT.PAYMENT_STATUS) ) )
, PMT.PAYMENT_ID
, PMT.PAYMENT_STATUS
FROM IBY_PAYMENTS_ALL PMT
, IBY_PAY_SERVICE_REQUESTS REQ
WHERE REQ.PAYMENT_SERVICE_REQUEST_ID = PMT.PAYMENT_SERVICE_REQUEST_ID
AND PMT.PAYMENT_STATUS != 'CREATED'
AND PMT.PAYMENT_INSTRUCTION_ID IS NOT NULL

Columns