Purchase Requisition Vertex debug xml query in Oracle EBS

1--PO Requisition Debug XML
2
3SELECT por.segment1 REQ_NUMBER,
4       por.requisition_header_id,
5       porl.line_num,
6       VT.REQUEST_ID,
7       debug.REQUEST_NAME,
8       debug.MESSAGE_TYPE,
9       debug.xml
10  --,vt.*
11  FROM apps.po_requisition_headers_all por,
12       apps.po_requisition_lines_all   porl,
13       apps.vertex_txn_tax_resp        vt,
14       apps.vertex_oic_debug_xml       debug
15 WHERE     1 = 1
16       AND por.requisition_header_id = vt.transaction_id
17       AND por.requisition_header_id = porl.requisition_header_id
18       AND vt.transaction_line_id = porl.requisition_line_id
19       AND por.segment1 = '1000600653'
20       AND porl.line_num = 1
21       AND vt.request_id = debug.request_id(+);
22
23---