Procurement - EBS (MOSC)

MOSC Banner

Unassigned to Buyer PRs

edited May 13, 2014 12:00PM in Procurement - EBS (MOSC) 1 commentAnswered

Dear Team,

How we can modify this query , to find out below PRs unassigned to buyer. below data only for unassigned PRs to buyer.

SELECT segment1 pr_number,

       description pr_description,

       approved_date pr_approved_date,

       (SELECT SUM (NVL (quantity * unit_price, 0))

FROM po_requisition_lines_all

WHERE requisition_header_id =

prh.requisition_header_id) pr_total_amount,

       (select full_name from per_people_x where person_id = preparer_id) requester,

       attribute5 department_name

  FROM PO_REQUISITION_HEADERS_ALL prh order by prh.requisition_header_id desc

Please check and advise.

Thanks

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center