[Home] [Help]
View: IBY_NOTIFY_XMISSION_FAIL_XML_V
View Text
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'
Columns
Name |
INSTRUCTION_CONTENT |
INSTRUCTION_ID |
INSTRUCTION_STATUS |