SELECT XMLElement("PaymentInstruction", XMLElement("PaymentInstructionID", ins.payment_instruction_id) ), ins.payment_instruction_id, ins.payment_instruction_status FROM iby_pay_instructions_all ins WHERE ins.payment_instruction_status != 'CREATED'
SELECT XMLELEMENT("PAYMENTINSTRUCTION"
, XMLELEMENT("PAYMENTINSTRUCTIONID"
, INS.PAYMENT_INSTRUCTION_ID) )
, INS.PAYMENT_INSTRUCTION_ID
, INS.PAYMENT_INSTRUCTION_STATUS
FROM IBY_PAY_INSTRUCTIONS_ALL INS
WHERE INS.PAYMENT_INSTRUCTION_STATUS != 'CREATED'
|
|
|