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]