Projects
1. List of all active projects ------------------------------------------- SELECT proj.Project_id, proj.name project_name, proj.segment1 projec_number, status.project_status_name project_status, proj.project_type, proj.start_date project_start_date, proj.completion_date project_finish_date FROM apps.pa_projects_all proj, apps.pa_project_statuses status WHERE proj.project_status_code= status.project_status_code AND status.status_type='PROJECT' AND status.project_status_code not in ('CLOSED','PENDING_CLOSE') AND proj.template_flag='N'; 2 : Active projects , ta...