Purchase Requisition Vertex debug xml query in Oracle EBS
PO Requisition Vertex debug xml Oracle apps
Vertex debug Oracle R12
--PO Requisition Debug XML
SELECT por.segment1 REQ_NUMBER,
por.requisition_header_id,
porl.line_num,
VT.REQUEST_ID,
debug.REQUEST_NAME,
debug.MESSAGE_TYPE,
debug.xml
--,vt.*
FROM apps.po_requisition_headers_all por,
apps.po_requisition_lines_all porl,
apps.vertex_txn_tax_resp vt,
apps.vertex_oic_debug_xml debug
WHERE 1 = 1
AND por.requisition_header_id = vt.transaction_id
AND por.requisition_header_id = porl.requisition_header_id
AND vt.transaction_line_id = porl.requisition_line_id
AND por.segment1 = '1000600653'
AND porl.line_num = 1
AND vt.request_id = debug.request_id(+);
---
Related posts:
- How to Retrieve Period to Date (PTD) and Year to Date (YTD) Balances of GL Account in Oracle R12
- Supervisor Hierarchy and Approval Limits in Oracle EBS R12
- Query to find all Expense report entry delegations
- Query to find vacation rules in Oracle R12
- Purchase Order Receipt details query in Oracle apps
- Oracle apps query to find approval limits
- View accounting query in oracle apps R12
- Query to get AR invoice SLA and GL details
- Accounting entries not transferred to the General Ledger
- Query to find all APIs of Oracle Apps modules
- R12 AR cash receipt SLA and GL details query
- Oracle apps AR Applications and SLA details
- Oracle EBS query to get AP Invoice SLA Details
- Oracle EBS query to get AR Invoice SLA Details
- Oracle AR Remit to address query
- Oracle Apps iExpense credit card details query
- Query to get customer tax registration details in R12
- Purchase Requisition Vertex debug xml query in Oracle EBS
- Purchase Order Vertex debug xml query in Oracle EBS
- AP Invoice Vertex debug xml query in Oracle EBS
- AR Invoice Vertex debug xml query in Oracle EBS
- Query to find AP invoice workflow item key in oracle apps
- Query to find serial number material transactions details
- Query to find period status for Inventory General Ledger Purchasing Payables Receivables Fixed Assets
- Oracle apps EBS sql to get Fixed Asset (FA) details with Net Book Value (NBV) and Depreciation
- Query to find Sales Orders that are shipped but not invoiced
- Query to get Customer Bank Account Details
- Query to get description of GL Code Combination
- Query to find Purchase Order and Invoice Details
- Query to find AP Invoices matched with receipts
- Query to find Supplier Bank Details
- Query to find Credit Memos on an AP invoice
- Query to find the AP invoices that are applied to multiple Purchase Orders
- AR Invoice grouping rule from RA_INTERFACE_LINES_ALL
- Query to find shipset and fulfilment set