AR Invoice Vertex debug xml query in Oracle EBS

1--AR Invoice debug xml
2
3SELECT AR.TRX_NUMBER,
4       rctl.line_number     line#,
5       rctl.customer_trx_id trx_id,
6       VT.REQUEST_ID,
7       debug.REQUEST_NAME,
8       debug.MESSAGE_TYPE,
9       debug.xml
10  --,vt.*
11  FROM apps.ra_customer_trx_all       ar,
12       apps.ra_customer_trx_lines_all rctl,
13       apps.vertex_txn_tax_resp       vt,
14       apps.zx_lines_v                zl,
15       apps.vertex_oic_debug_xml      debug
16 WHERE     1 = 1
17       AND ar.customer_trx_id = vt.transaction_id
18       AND rctl.customer_trx_id = ar.customer_trx_id
19       AND rctl.customer_trx_line_id = vt.TRANSACTION_LINE_ID
20       AND ar.trx_number = '897904'
21       AND rctl.line_number IN (1)
22       AND zl.trx_line_id = rctl.customer_trx_line_id
23       AND vt.request_id = debug.request_id(+);
24
25--