SELECT
t.item_id
FROM
pm_tasks_revisionsx t
WHERE
t.revision_id = :task_revision_id
SELECT
t.revision_id as task_revision_id
FROM
pm_tasks_revisionsx t, cr_items i
WHERE
t.item_id = :task_id and
i.live_revision = t.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.revision_id = :task_revision_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,
i.live_revision
FROM
pm_tasks_revisionsx t, cr_items i
WHERE
t.item_id = :task_id and
t.revision_id = :task_revision_id and
t.item_id = i.item_id
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
[template::list::orderby_clause -name revisions -orderby]
SELECT
t.title as task_title,
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,
i.live_revision,
c.parent_task_id,
c.const_type
FROM
pm_tasks_revisionsx t, cr_items i, pm_task_constraints c
WHERE
c.task_id = :task_id and
c.parent_task_id = t.item_id and
t.revision_id = i.live_revision and
t.item_id = i.item_id
[template::list::orderby_clause -name consts -orderby]
SELECT
t.title as task_title,
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,
i.live_revision,
c.parent_task_id,
c.const_type,
c.task_id
FROM
pm_tasks_revisionsx t, cr_items i, pm_task_constraints c
WHERE
c.task_id = t.item_id and
c.parent_task_id = :task_id and
t.revision_id = i.live_revision and
t.item_id = i.item_id
[template::list::orderby_clause -name consts2 -orderby]