SELECT p.item_id as project_item_id, p.title as project_name, p.description as description, p.mime_type, o.organization_id as customer_id, o.name as customer_name FROM pm_projectsx p LEFT JOIN organizations o on p.customer_id = o.organization_id, cr_items i, pm_project_status s WHERE p.project_id = i.live_revision and p.parent_id = :root_folder and p.status_id = s.status_id [template::list::filter_where_clauses -and -name projects] [template::list::orderby_clause -orderby -name projects] SELECT pm_project.get_root_folder (:package_id, 'f') FROM dual