SQL query to find pending PO for approval in Oracle EBS R12
SELECT fu.user_name po_created_by,pha.org_id , (SELECT NAME || ' ( ' || short_code || ' )' FROM hr_operating_units WHERE organization_id = pha.org_id) ou_name, pha.segment1 po_num, pha.revision_num, SUM(pla.quantity) po_qty, SUM(pla.unit_price) po_price, pha.authorization_status, pha.creation_date po_creation_date, wn.to_user, wn.subject, wn.original_recipient, wn.begin_date, TRUNC (SYSDATE - wn.begin_date) no_days_pending,d.name Approval_path ,wn.from_role forrwad_by,wn.notification_id,pha.po_header_id FROM wf_notifications wn, po_headers_all pha, fnd_user fu, po_lines_all pla, ...