SELECT p.item_id as project_item_id, p.parent_id, p.project_id, p.title as project_name, p.project_code, p.goal, p.description, p.customer_id, p.status_id, p.logger_project, to_char(p.planned_start_date,'YYYY-MM-DD') as planned_start_date, to_char(p.planned_end_date,'YYYY-MM-DD') as planned_end_date, p.ongoing_p FROM pm_projectsx p WHERE p.item_id = :project_item_id and p.project_id = :project_id SELECT sysdate from dual SELECT description, status_id FROM pm_project_status ORDER BY status_type desc, description asc