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 FROM pm_projectsx p WHERE p.item_id = :item_id and p.project_id = :project_id 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