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