PO Approval

Find Purchase Order from Requisition

     Query to find Purchase Order from a Requisition Using SQL   Introduction / Issue In Oracle E-Business Suite (EBS), the Procure-to-Pay (P2P) process begins with creating a Purchase Requisition…

Read More

Script used to fetch important details about blanket purchase order (PO) approvals status

Use-Case: This SQL query is used to fetch important details about blanket purchase order (PO) approvals. It pulls information like approval actions, dates, revision numbers, PO amounts, and checks if…

Read More

SQL to Find Employee – Supervisor Hierarchy details

Background The Purchase order or Requisitions are not valid unless it is approved. In any of the procurement process, most of the issues occur in the approval of the purchasing…

Read More