Purchase Order Vertex debug xml query in Oracle EBS

By admin

Purchase Order Vertex debug xml query in Oracle EBS
PO Vertex debug xml Oracle apps
Vertex debug Oracle R12

SQL Querysql
1--PO Debug XML
2
3SELECT poh.segment1     PO_NUMBER,
4       poh.po_header_id po_header_id,
5       pol.line_num,
6       VT.REQUEST_ID,
7       debug.REQUEST_NAME,
8       debug.MESSAGE_TYPE,
9       debug.xml
10  FROM apps.po_headers_all        poh,
11       apps.po_lines_all          pol,
12       apps.po_line_locations_all pll,
13       apps.vertex_txn_tax_resp   vt,
14       apps.vertex_oic_debug_xml  debug
15 WHERE     1 = 1
16       AND poh.po_header_id = vt.transaction_id
17       AND poh.po_header_id = pol.po_header_id
18       AND pol.po_line_id = pll.po_line_id
19       AND vt.transaction_line_id = pll.line_location_id
20       AND poh.segment1 = '4334002898'
21       AND pll.shipment_num = 1
22       AND vt.request_id = debug.request_id(+);
23       
24       --

Related posts: