Open Project with Terminated PMs or PDs

Open Project with Terminated PMs or PDs

SELECT pou.NAME carrying_out_org_name ,ppa.NAME project_name          ,ppa.segment1 project_num ,ppa.segment1 project_number –,TO_CHAR(ppa.completion_date, ‘DD-MON-YYYY’, ‘NLS_DATE_LANGUAGE = american’) completion_date          –,ppa.description          –,TO_CHAR(ppp.end_date_active, ‘DD-MON-YYYY’,…