SELECT p.item_id as project_item_id FROM pm_projectsx p WHERE p.project_id = :project_id 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 p.item_id, p.project_id, p.title as project_name, p.project_code, p.goal, p.description, to_char(p.planned_start_date,'Mon DD ''YY') as planned_start_date, to_char(p.planned_end_date,'Mon DD ''YY') as planned_end_date, p.ongoing_p, i.live_revision, to_char(p.estimated_finish_date,'Mon DD ''YY') as estimated_finish_date, to_char(p.earliest_finish_date,'Mon DD ''YY') as earliest_finish_date, to_char(p.latest_finish_date,'Mon DD ''YY') as latest_finish_date, p.actual_hours_completed, p.estimated_hours_total, p.parent_id FROM pm_projectsx p, cr_items i WHERE p.item_id = :project_item_id and p.project_id = :project_id and p.item_id = i.item_id SELECT p.item_id, p.project_id, p.title as project_name, p.project_code, p.goal, p.description, to_char(p.planned_start_date,'Mon DD ''YY') as planned_start_date, to_char(p.planned_end_date,'Mon DD ''YY') as planned_end_date, p.ongoing_p, i.live_revision, to_char(p.estimated_finish_date,'Mon DD ''YY') as estimated_finish_date, to_char(p.earliest_finish_date,'Mon DD ''YY') as earliest_finish_date, to_char(p.latest_finish_date,'Mon DD ''YY') as latest_finish_date, p.estimated_hours_total FROM pm_projectsx p, cr_items i WHERE p.item_id = :project_item_id and p.item_id = i.item_id ORDER BY p.project_id desc SELECT t.item_id as task_id, t.title, 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_finish,'Mon DD ''YY') as earliest_finish, to_char(t.latest_start,'Mon DD ''YY') as latest_start, to_char(t.latest_finish,'Mon DD ''YY') as latest_finish, to_char(t.latest_start-t.earliest_start,'DD') || ' days' as slack_time, u.first_names, u.last_name, t.percent_complete, d.parent_task_id, d.dependency_type, t.estimated_hours_work, t.estimated_hours_work_min, t.estimated_hours_work_max, t.actual_hours_worked FROM pm_tasks_revisionsx t LEFT JOIN pm_task_assignment a ON t.item_id = a.task_id, cr_items i LEFT JOIN pm_task_dependency d ON i.item_id = d.task_id, cc_users u WHERE t.parent_id = :project_item_id and t.revision_id = i.live_revision and a.party_id = u.party_id [template::list::orderby_clause -name tasks -orderby] select pm_project__get_root_folder (:package_id, 'f') SELECT p.item_id, p.project_id, p.parent_id as folder_id, p.object_type as content_type, p.title as project_name, p.project_code, to_char(p.planned_start_date, 'Mon DD ''YY') as planned_start_date, to_char(p.planned_end_date, 'Mon DD ''YY') as planned_end_date, p.ongoing_p, p.actual_hours_completed, p.estimated_hours_total FROM pm_projectsx p, cr_items i WHERE p.project_id = i.live_revision and p.parent_id = :project_item_id ORDER BY p.title select project_id, role_id, party_id from pm_task_assignment where project_id = :project_item_id