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='';
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:
Post a Comment