Introduction P2P Procure-to-Pay in Oracle E-Business Suite (EBS) is a fully integrated business process followed by any organization that handles from requesting goods or services to paying the supplier and accounting for the transaction. In this article i discuss commonly used P2P queries for reporting and analysis. 1. Purchase Order Details Purpose: Fetch PO header and line details along with the linked supplier SELECT pha.segment1 AS po_number, pha.type_lookup_code AS po_type, pha.authorization_status, pha.creation_date, aps.vendor_name, aps.segment1 AS supplier_number, pla.line_num, pla.item_description, pla.quantity, ...