View: IBY_INS_LVL_PMT_STS_CHG_XML_V

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

View Text

SELECT XMLCONCAT( XMLELEMENT("PAYMENTGROUP"
, XMLELEMENT("FNDAPPLICATIONID"
, REQ.CALLING_APP_ID)
, (SELECT XMLELEMENT("PAYMENTINSTRUCTION"
, XMLAGG( XMLFOREST( INSTR.PAYMENT_INSTRUCTION_ID AS "PAYMENTINSTRUCTIONID"
, 'DUMMY' AS "NEWSTATUS"
, 'DUMMY' AS "DIRECTIONOFCHANGE" ) ) )
FROM IBY_PAY_INSTRUCTIONS_ALL I
WHERE I.PAYMENT_INSTRUCTION_ID=INSTR.PAYMENT_INSTRUCTION_ID ) ) )
, INSTR.PAYMENT_INSTRUCTION_ID
, INSTR.PAYMENT_INSTRUCTION_STATUS
FROM IBY_PAYMENTS_ALL PMT
, IBY_PAY_SERVICE_REQUESTS REQ
, IBY_PAY_INSTRUCTIONS_ALL INSTR
WHERE REQ.PAYMENT_SERVICE_REQUEST_ID = PMT.PAYMENT_SERVICE_REQUEST_ID
AND INSTR.PAYMENT_INSTRUCTION_ID = PMT.PAYMENT_INSTRUCTION_ID GROUP BY REQ.CALLING_APP_ID
, INSTR.PAYMENT_INSTRUCTION_ID
, INSTR.PAYMENT_INSTRUCTION_STATUS

Columns