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.mime_type, p.customer_id, p.status_id, to_char(p.planned_start_date,'YYYY-MM-DD') as planned_start_date, to_char(p.planned_end_date,'YYYY-MM-DD HH24:MI:SS') as planned_end_date, p.ongoing_p, p.dform FROM pm_projectsx p WHERE p.item_id = :project_item_id and p.project_id = :project_id SELECT current_timestamp select customer_id from pm_projects where project_id = :project_id SELECT description, status_id FROM pm_project_status ORDER BY status_type desc, description asc