select t.task_revision_id, t.title as task_title, t.item_id, t.description, t.name, t.parent_id, to_char(t.end_date,'YYYY MM DD') as end_date, t.percent_complete FROM pm_tasks_revisionsx t, cr_items i WHERE t.item_id in ([join $task_id ", "]) and t.revision_id = i.live_revision select t.revision_id, t.title as task_title, t.item_id, t.description, t.name, t.parent_id, to_char(t.end_date,'Mon DD ''YY') as end_date, t.percent_complete FROM pm_tasks_revisionsx t, cr_items i WHERE t.revision_id in ([join $task_revisions ", "]) and i.item_id = t.item_id select item_id FROM pm_tasks_revisionsx WHERE revision_id = :tr select short_name, description FROM pm_task_dependency_types ORDER BY short_name select r.item_id, r.title as task_title FROM pm_tasks_revisionsx r, cr_items i WHERE r.parent_id = :project_item_id and r.revision_id = i.live_revision ORDER BY upper(r.title) INSERT INTO pm_task_dependency (dependency_id, task_id, parent_task_id, dependency_type) VALUES (:dependency_id, :tsk_id, :parent_tsk_id, :type_id) select parent_id FROM pm_tasks_revisionsx WHERE revision_id = '[lindex $task_revisions 0]'