SELECT t.process_task_id as process_tid, t.one_line, t.description, t.estimated_hours_work, t.estimated_hours_work_min, t.estimated_hours_work_max, d.dependency_id, d.parent_task_id as process_parent_task FROM pm_process_task t LEFT JOIN pm_process_task_dependency d ON t.process_task_id = d.process_task_id WHERE t.process_id = :process_id ORDER BY t.process_task_id select current_timestamp select t.task_revision_id, t.title as my_task_title, t.description as my_description, t.mime_type as my_mime_type, to_char(t.end_date,'YYYY MM DD') as my_end_date, t.percent_complete as my_percent_complete, t.estimated_hours_work as my_estimated_work, t.estimated_hours_work_min as my_estimated_work_min, t.estimated_hours_work_max as my_estimated_work_max, t.actual_hours_worked as my_actual_hours_worked, d.parent_task_id as my_dependency FROM pm_tasks_revisionsx t, cr_items i LEFT JOIN pm_task_dependency d ON i.item_id = d.task_id WHERE t.item_id in ([join $task_id ","]) and t.revision_id = i.live_revision SELECT p.project_id FROM pm_projectsx p, cr_items i WHERE p.item_id = :project_item_id and p.revision_id = i.live_revision 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, pm_tasks t, pm_task_status s WHERE r.parent_id = :project_item_id and r.revision_id = i.live_revision and i.item_id = t.task_id and t.status = s.status_id and s.status_type = 'o' UNION SELECT r.item_id, r.title as task_title FROM pm_tasks_revisionsx r, cr_items i, pm_tasks t WHERE r.parent_id = :project_item_id and r.revision_id = i.live_revision and i.item_id = t.task_id and t.task_id in ([join $my_dependencies ","]) ORDER BY task_title select item_id FROM pm_tasks_revisionsx WHERE revision_id = :this_revision_id