Follow us: Connect on YouTube Connect on YouTube Connect on YouTube


Sunday, 5 February 2017

Details of Projects closed in particular period query

SELECT p.segment1 "Project NUMBER", h.NAME " ORGANIZATION",
       pa.full_name "Project Manger", p.start_date, p.closed_date
  FROM pa_projects_all p,
       hr_organization_units h,
       pa_project_players pp,
       per_all_people_f pa
 WHERE 1 = 1
   AND p.project_id = pp.project_id
   --AND p.segment1 = '179250'
   AND p.carrying_out_organization_id = h.organization_id
   AND pa.person_id = pp.person_id
   AND pp.project_role_type = 'PROJECT MANAGER'
---AND p.org_id = 5868

--AND TRUNC (p.closed_date) BETWEEN '01-JUL-2012' AND '31-JUL-2012'
Share this article :


  1. Oracle Apps R12 and Oracle Fusion Cloud Self Paced Online Training Videos Published on Udemy with Life Time Access & Live Meeting Support to Clear your Queries. Avail 25% to 80% discount. Please Check for Never Before Offers and Discount Coupon Codes.