You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register
Get Started with Redwood: Oracle Cloud SCM and Purchasing

Trouble Querying For PO Delegation Details

edited Aug 2, 2025 12:19PM in Purchasing 1 comment

I am trying to query for delegation details of a PO. Currently only able to query for the approver name for each PO, but cant seem to join delegations table to properly query for who passed to delegate for approval.

SELECT
PRHA.PERFORMER_ID,
POH.SEGMENT1 PO_NUMBER,
PRH.REQUISITION_NUMBER,
PSV.VENDOR_NAME,
TO_CHAR(POH.CREATION_DATE, 'MM/DD/YYYY HH:MI AM') PO_CREATION_DATE,
TO_CHAR(POH.APPROVED_DATE, 'MM/DD/YYYY HH:MI AM') PO_APPROVED_DATE,
TO_CHAR(PRHA.ACTION_DATE, 'MM/DD/YYYY HH:MI AM') ACTION_DATE,
MAX(DECODE(PRHA.ACTION_CODE,

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!