Vertex XML Request and Response Query for AP, AR, PO and OM

Vertex Query for Request and Response XML file extract for Payables Invoice (AP).

SELECT *
FROM apps.VERTEX_OIC_DEBUG_XML
where request_id in (
select distinct vt.request_id
from   apps.ap_invoices_all ap
       ,apps.vertex_txn_tax_resp vt
where  1=1
and    ap.invoice_id= vt.transaction_id
and    ap.invoice_num =:P_Invoice_Num);


Vertex Query for Request and Response XML file extract for Receivables Invoice (AR).

SELECT *
FROM apps.VERTEX_OIC_DEBUG_XML
where request_id in (
select distinct vt.request_id
from   apps.ra_customer_trx_all ar
       ,apps.vertex_txn_tax_resp vt
where  1=1
and    ar.customer_trx_id= vt.transaction_id
and    ar.trx_number = :P_Trx_Number);

Vertex Query for Request and Response XML file extract for Purchase Order (PO).

SELECT *
FROM apps.VERTEX_OIC_DEBUG_XML
where request_id in (
select distinct vt.request_id
from   apps.po_headers_all po
       ,apps.vertex_txn_tax_resp vt
where  1=1
and    po.po_header_id= vt.transaction_id
and    Po.Segment1= :P_Po_Number);

Vertex Query for Request and Response XML file extract for Sales Order (OM).

SELECT *
FROM apps.VERTEX_OIC_DEBUG_XML
where request_id in (
select distinct vt.request_id
from   apps.oe_order_headers_all ooh
       ,apps.vertex_txn_tax_resp vt
where  1=1
and    ooh.header_id = vt.transaction_id
and    ooh.order_number= :P_Order_Number;