Monday, May 8, 2017

Query To Get Project Configuration Details

SELECT  
a.segment1 PROJECT_NUMBER, 
a.NAME PROJECT_NAME, 
a.long_name PROJECT_LONG_NAME,
a.project_type, 
b.customer_number, 
b.customer_name, 
e.name Owning_Organization,
a.project_status_code PORJECT_STATUS, 
a.start_date, 
a.completion_date,
c.full_name Project_Manager, 
d.full_name Operations_Manager

FROM 
pa_projects_all a, 
pa_project_customers_v b, 
pa_project_players_v c, 
pa_project_players_v d, 
hr_all_organization_units e

WHERE a.project_type IN ('Your Project Types')
AND a.project_id = b.project_id (+)
AND a.project_id = c.project_id (+)
AND c.ROLE LIKE 'Project Manager'
AND a.project_id = d.project_id (+)
AND d.ROLE LIKE 'Your Project Roles'
AND a.carrying_out_organization_id = e.organization_id
AND a.template_flag = 'N'
--AND a.creation_date BETWEEN '01-DEC-06' AND '31-DEC-06'

ORDER BY a.segment1

No comments:

Post a Comment

Best Blogger TipsGet Flower Effect