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

Trouble Querying For PO Delegation Details

edited Jun 24, 2025 1:12PM in Reporting and Analytics for ERP

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!