SELECT
p.item_id
FROM
pm_projectsx p
WHERE
p.project_id = :project_id
SELECT
p.item_id,
p.project_id,
p.project_name,
p.project_code,
p.goal,
p.description,
p.deadline_scheduling,
to_char(p.planned_start_date,'MM/DD/YYYY') as planned_start_date,
to_char(p.planned_end_date,'MM/DD/YYYY') as planned_end_date,
p.ongoing_p,
i.live_revision
FROM
pm_projectsx p, cr_items i
WHERE
p.item_id = :item_id and
p.project_id = :project_id and
p.item_id = i.item_id
SELECT
p.item_id,
p.project_id,
p.project_name,
p.project_code,
p.goal,
p.description,
p.deadline_scheduling,
to_char(p.planned_start_date,'MM/DD/YYYY') as planned_start_date,
to_char(p.planned_end_date,'MM/DD/YYYY') as planned_end_date,
p.ongoing_p,
i.live_revision
FROM
pm_projectsx p, cr_items i
WHERE
p.item_id = :item_id and
p.item_id = i.item_id
ORDER BY
p.project_id desc
SELECT
t.item_id,
t.title,
to_char(t.start_date,'MM/DD/YYYY') as start_date,
to_char(t.end_date,'MM/DD/YYYY') as end_date
FROM
pm_tasks_revisionsx t, cr_items i
WHERE
t.parent_id = :item_id and
t.revision_id = i.live_revision
ORDER BY
t.end_date,t.title