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.end_date,'Mon DD ''YY') as end_date, to_char(t.earliest_start,'Mon DD ''YY') as earliest_start, to_char(t.earliest_start,'J') as earliest_start_j, to_char(t.earliest_finish,'Mon DD ''YY') as earliest_finish, to_char(t.latest_start,'Mon DD ''YY') as latest_start, to_char(t.latest_start,'J') as latest_start_j, to_char(t.latest_finish,'Mon DD ''YY') as latest_finish, to_char(current_date,'J') as today_j, t.estimated_hours_work, t.estimated_hours_work_min, t.estimated_hours_work_max, t.percent_complete, i.live_revision, p.first_names || ' ' || p.last_name as creation_user FROM pm_tasks_revisionsx t, cr_items i, persons p WHERE t.item_id = :task_id and t.revision_id = :task_revision_id and t.item_id = i.item_id and t.creation_user = p.person_id SELECT t.item_id, t.revision_id, i.live_revision, t.title as task_title, t.description || ' -- ' || p.first_names || ' ' || p.last_name as description, to_char(t.end_date,'MM/DD/YYYY') as end_date, t.percent_complete, t.estimated_hours_work_min, t.estimated_hours_work_max, t.actual_hours_worked FROM pm_tasks_revisionsx t, cr_items i, persons p WHERE t.item_id = :task_id and t.item_id = i.item_id and t.creation_user = p.person_id [template::list::orderby_clause -name revisions -orderby] SELECT t.title as task_title, to_char(t.end_date,'MM/DD/YYYY') as end_date, t.percent_complete, i.live_revision, d.parent_task_id, d.dependency_type FROM pm_tasks_revisionsx t, cr_items i, pm_task_dependency d WHERE d.task_id = :task_id and d.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 dependency -orderby] SELECT t.title as task_title, to_char(t.end_date,'MM/DD/YYYY') as end_date, t.percent_complete, i.live_revision, d.parent_task_id, d.dependency_type, d.task_id as d_task_id FROM pm_tasks_revisionsx t, cr_items i, pm_task_dependency d WHERE d.task_id = t.item_id and d.parent_task_id = :task_id and t.revision_id = i.live_revision and t.item_id = i.item_id [template::list::orderby_clause -name dependency2 -orderby] select r.one_line, u.first_names || ' ' || u.last_name || ' (' || u.email || ')' as user_info, r.role_id from pm_task_assignment a, cc_users u, pm_roles r where a.task_id = :task_id and u.party_id = a.party_id and a.role_id = r.role_id SELECT x.task_id_1 as x_task_id, r.title, to_char(r.earliest_start,'YYYY-MM-DD HH24:MI') as earliest_start, r.earliest_start - current_date as days_to_earliest_start, to_char(r.earliest_start,'J') as earliest_start_j, to_char(r.earliest_finish,'YYYY-MM-DD HH24:MI') as earliest_finish, r.earliest_finish - current_date as days_to_earliest_finish, to_char(r.latest_start,'YYYY-MM-DD HH24:MI') as latest_start, r.latest_start - current_date as days_to_latest_start, to_char(r.latest_start,'J') as latest_start_j, to_char(current_date,'J') as today_j, to_char(r.latest_finish,'YYYY-MM-DD HH24:MI') as latest_finish, r.latest_finish - current_date as days_to_latest_finish FROM pm_task_xref x, pm_tasks_revisionsx r, cr_items i WHERE x.task_id_2 = :task_id and x.task_id_2 = r.item_id and r.revision_id = i.live_revision UNION SELECT x2.task_id_2 as x_task_id, r2.title, to_char(r2.earliest_start,'YYYY-MM-DD HH24:MI') as earliest_start, r2.earliest_start - current_date as days_to_earliest_start, to_char(r2.earliest_start,'J') as earliest_start_j, to_char(r2.earliest_finish,'YYYY-MM-DD HH24:MI') as earliest_finish, r2.earliest_finish - current_date as days_to_earliest_finish, to_char(r2.latest_start,'YYYY-MM-DD HH24:MI') as latest_start, r2.latest_start - current_date as days_to_latest_start, to_char(r2.latest_start,'J') as latest_start_j, to_char(current_date,'J') as today_j, to_char(r2.latest_finish,'YYYY-MM-DD HH24:MI') as latest_finish, r2.latest_finish - current_date as days_to_latest_finish FROM pm_task_xref x2, pm_tasks_revisionsx r2, cr_items i2 WHERE x2.task_id_1 = :task_id and x2.task_id_1 = r2.item_id and i2.live_revision = r2.revision_id