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