AP Invoice Vertex debug xml query in Oracle EBS

1--AP Invoice debug xml
2
3SELECT ap.invoice_num,
4       ap.invoice_id trx_id,
5       VT.REQUEST_ID,
6       debug.REQUEST_NAME,
7       debug.MESSAGE_TYPE,
8       debug.xml
9     --,vt.*
10  FROM apps.ap_invoices_all      ap,
11       apps.vertex_txn_tax_resp  vt,
12       apps.vertex_oic_debug_xml debug
13 WHERE     1 = 1
14       AND ap.invoice_id = vt.transaction_id
15       AND ap.invoice_num = '1231234'
16       AND vt.request_id = debug.request_id(+);
17
18
19--