Tuesday, June 2, 2015

Projects Publish WorkPlan Tables

The following SQLs identified the invalid / incorrect data:
 a) select * from pa_projects_all where project_id=;
 b) select * from pa_tasks where project_id=;
 c) select * from pa_proj_elements where project_id=;
 d) select * from pa_proj_elem_ver_structure where project_id=;
 e) select * from pa_proj_element_versions where project_id=;
 f) select * from pa_proj_workplan_attr where project_id=;
 g) select * from pa_proj_structure_types where proj_element_id in (select
 proj_element_id from
  pa_proj_elements where project_id = );
 h)select * from pa_object_relationships where object_id_from1 in (
  select element_version_id from pa_proj_element_versions where project_id =
 ) or object_id_to1 in (
  select element_version_id from pa_proj_element_versions where project_id =
 );
 i) select * from pa_budget_versions where project_id=;
 j)select * from dba_source where (substr(name,1,3)='PA_' or name like 'PJI%')
 and type in ('PACKAGE','PACKAGE BODY') and line=2;


a) select * from pa_projects_all where project_id=;
b) select * from pa_tasks where project_id=;
c) select * from pa_proj_elements where project_id=;
d) select * from pa_proj_elem_ver_structure where project_id=;
e) select * from pa_proj_element_versions where project_id=;

NOTE:  The project id of the project can be found from the following SQL query:
  SELECT project_id
  FROM   pa_projects_all
  WHERE  segment1='';

No comments: