Oracle Apps

 Active project Managers Query SELECT DISTINCT hou.name org_name,        ppa.name project_name,        ppa.segment1 project_number,        ppa.project_type,    pe.full_name Project_Manager,    amount_limit Purchase_Requisition_approval,    pe.email_address,        ppa.start_date,        to_char(ppa.completion_date,'DD-MON-YYYY')completion_date ,        ppa.closed_date,        ppa.enabled_flag   FROM apps.pa_project_parties ppp,    apps.pa_projects_all ppa,    apps.pa_project_role_types pprt,    apps.per_all_people_f pe,    apps.pa_project_assignments pa,    apps.fnd_user u,        apps.hr_operating_units hou,   (SELECT paf.person_id,   paf.assignment_type,       pcr.amount_limit   ...