DELETE FROM pm_task_assignment WHERE task_id = :task_item_id DELETE FROM pm_task_assignment WHERE task_id = :task_item_id and party_id = :party_id SELECT r.title FROM cr_items i, cr_revisions r WHERE i.item_id = r.item_id and i.item_id = :task_item_id and i.live_revision = r.revision_id SELECT i.item_id FROM cr_items i, cr_revisions r WHERE i.item_id = r.item_id and r.revision_id = :task_id SELECT live_revision FROM cr_items i WHERE i.item_id = :task_item_id select status from pm_tasks where task_id = :task_item_id SELECT case when status_type = 'c' then 0 else 1 end as open_p FROM pm_tasks t, pm_task_status s WHERE task_id = :task_item_id and t.status = s.status_id DELETE FROM pm_task_dependency WHERE task_id = :task_item_id SELECT task.item_id as t_item_id FROM cr_items task, cr_items project WHERE task.parent_id = project.item_id and project.item_id = :project_item_id SElECT d.task_id as dep_task, d.parent_task_id as dep_task_parent FROM pm_task_dependency d WHERE d.task_id in ([join $project_tasks ", "]) INSERT INTO pm_task_dependency (dependency_id, task_id, parent_task_id, dependency_type) values (:dependency_id, :task_item_id, :parent_id, 'finish_before_start') 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_clause ORDER BY task_title 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_clause ORDER BY task_title UPDATE logger_entries SET project_id = :logger_project WHERE entry_id in (select logger_entry from pm_task_logger_proj_map where task_item_id = :task_item_id) SELECT p.email as from_address, p2.first_names || ' ' || p2.last_name as mod_username FROM parties p, persons p2 WHERE p.party_id = :user_id and p.party_id = p2.person_id SELECT t.title as subject, t.description, t.mime_type as description_mime_type, to_char(t.earliest_start,'MM-DD-YYYY') as earliest_start, to_char(t.earliest_finish,'MM-DD-YYYY') as earliest_finish, to_char(t.latest_start,'MM-DD-YYYY') as latest_start, to_char(t.latest_finish,'MM-DD-YYYY') as latest_finish, t.estimated_hours_work as work, t.estimated_hours_work_min as work_min, t.estimated_hours_work_max as work_max, t.percent_complete, p.title as project_name, t.parent_id as project_item_id, a.process_instance FROM pm_tasks_revisionsx t, pm_tasks_active a, cr_items i, cr_items project, pm_projectsx p WHERE t.item_id = :task_item_id and t.item_id = a.task_id and t.revision_id = i.live_revision and t.item_id = i.item_id and t.parent_id = project.item_id and project.item_id = p.item_id and project.live_revision = p.revision_id SELECT p.email as to_address, r.one_line as role, r.is_lead_p FROM pm_task_assignment a, parties p, pm_roles r WHERE task_id = :task_item_id and a.party_id = p.party_id and a.role_id = r.role_id SELECT party_id, role_id FROM pm_task_assignment WHERE task_id = :task_item_id UPDATE pm_tasks SET status = :status_code WHERE task_id = :task_item_id UPDATE pm_tasks SET status = :status_code WHERE task_id = :task_item_id SELECT p.first_names || ' ' || p.last_name FROM pm_task_assignment a, persons p WHERE task_id = :task_item_id and a.party_id = p.person_id update pm_tasks set deleted_p = 't' where task_id = :task_item_id select parent_id from cr_items where item_id = :task_item_id SELECT sum(le.value) FROM logger_entries le WHERE entry_id in (select logger_entry from pm_task_logger_proj_map where task_item_id = :task_item_id) AND le.variable_id = '[logger::variable::get_default_variable_id]' UPDATE pm_tasks_revisions SET actual_hours_worked = :total_logged_hours WHERE task_revision_id = :task_revision_id INSERT INTO pm_task_xref (task_id_1, task_id_2) VALUES (:task_item_id_1, :task_item_id_2) INSERT INTO pm_task_xref (task_id_1, task_id_2) VALUES (:task_item_id_2, :task_item_id_1) delete from pm_task_assignment where task_id = :task_item_id and party_id = :party_id insert into pm_task_assignment (task_id, role_id, party_id) values (:task_item_id, :role_id, :party_id) select email from parties where party_id = :party UPDATE pm_tasks_revisions SET percent_complete = :percent_complete WHERE task_revision_id = (select live_revision from cr_items where item_id = :task_item_id) SELECT p.email FROM parties p, pm_task_assignment a WHERE a.task_id = :task_item_id and a.party_id = p.party_id SELECT distinct(first_names || ' ' || last_name) as fullname, u.person_id FROM persons u, pm_task_assignment a, pm_tasks_active ts WHERE u.person_id = a.party_id and ts.task_id = a.task_id and ts.status = :status_id ORDER BY fullname SELECT t.title as one_line, t.description, t.mime_type as description_mime_type, t.estimated_hours_work as estimated_hours_work, t.estimated_hours_work_min as estimated_hours_work_min, t.estimated_hours_work_max as estimated_hours_work_max, t.percent_complete, to_char(t.end_date, 'DD') as end_date_day, to_char(t.end_date, 'MM') as end_date_month, to_char(t.end_date, 'YYYY') as end_date_year, d.parent_task_id, i.item_id as tid, t.parent_id as project, t.priority FROM pm_tasks_revisionsx t, cr_items i LEFT JOIN pm_task_dependency d ON i.item_id = d.task_id WHERE t.revision_id = i.live_revision and t.item_id = i.item_id $task_where_clause select to_char(current_timestamp,'J') from dual SELECT ts.task_id, ts.task_id as item_id, ts.task_number, t.task_revision_id, t.title, to_char(t.earliest_start,'J') as earliest_start_j, to_char(current_timestamp,'J') as today_j, to_char(t.latest_start,'J') as latest_start_j, to_char(t.latest_start,'YYYY-MM-DD HH24:MI') as latest_start, to_char(t.latest_finish,'YYYY-MM-DD HH24:MI') as latest_finish, t.percent_complete, t.estimated_hours_work, t.estimated_hours_work_min, t.estimated_hours_work_max, case when t.actual_hours_worked is null then 0 else t.actual_hours_worked end as actual_hours_worked, to_char(t.earliest_start,'YYYY-MM-DD HH24:MI') as earliest_start, to_char(t.earliest_finish,'YYYY-MM-DD HH24:MI') as earliest_finish, to_char(t.latest_start,'YYYY-MM-DD HH24:MI') as latest_start, to_char(t.latest_finish,'YYYY-MM-DD HH24:MI') as latest_finish, p.first_names || ' ' || p.last_name as full_name, p.party_id, (select one_line from pm_roles r where ta.role_id = r.role_id) as role FROM pm_tasks_active ts, pm_tasks_revisionsx t, pm_task_assignment ta, acs_users_all p, cr_items i, pm_task_status s WHERE ts.task_id = t.item_id and i.item_id = t.item_id and t.task_revision_id = i.live_revision and ts.status = s.status_id and s.status_type = 'o' and t.item_id = ta.task_id and ta.party_id = p.party_id ORDER BY t.latest_start asc select package_id from cr_folders cf, cr_items ci1, cr_items ci2 where cf.folder_id = ci1.parent_id and ci1.item_id = ci2.parent_id and ci2.item_id = :object_id