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,
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,
t.latest_start-t.earliest_start as slack_time,
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, cr_items i LEFT JOIN pm_task_dependency d ON i.item_id = d.task_id
WHERE
t.parent_id = :project_item_id and
t.revision_id = i.live_revision
[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