SELECT
t.item_id
FROM
pm_tasks_revisionsx t
WHERE
t.revision_id = :task_revision_id
SELECT
t.parent_id as project_item_id
FROM
pm_tasks_revisionsx t, cr_items i
WHERE
i.item_id = t.item_id and
t.item_id = :task_id
SELECT
t.item_id,
t.title as task_title,
t.description,
to_char(t.start_date,'MM/DD/YYYY') as start_date,
to_char(t.end_date,'MM/DD/YYYY') as end_date,
t.percent_complete
FROM
pm_tasks_revisionsx t, cr_items i
WHERE
t.item_id = :task_id and
t.revision_id = i.live_revision
SELECT
t.item_id,
t.revision_id,
i.live_revision,
t.title as task_title,
t.description,
to_char(t.start_date,'MM/DD/YYYY') as start_date,
to_char(t.end_date,'MM/DD/YYYY') as end_date,
t.percent_complete
FROM
pm_tasks_revisionsx t, cr_items i
WHERE
t.item_id = :task_id and
t.item_id = i.item_id
ORDER BY
t.revision_id