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,
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
current_timestamp
SELECT
description, status_id
FROM
pm_project_status
ORDER BY
status_type desc, description asc