[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select proj_element_id, object_type
from pa_proj_element_versions
where element_version_id = c_element_version_id;
select '1'
from pa_object_relationships
where object_id_from1 = c_element_version_id
and object_type_from = 'PA_TASKS'
and relationship_type = 'L';
select '1'
from pa_object_relationships
where object_id_from1 = c_element_version_id
and object_type_from = 'PA_STRUCTURES';
select parent_structure_version_id, project_id
from pa_proj_element_versions
where element_version_id = c_element_version_id;
select '1'
from PA_TASKS
where task_id = c_task_id;
select '1'
from pa_proj_elements pe1,
pa_proj_element_versions pev1a,
pa_proj_element_versions pev1b,
pa_proj_element_versions pev2a,
pa_proj_element_versions pev2b
where pev1b.element_version_id = c_elem_ver_from
and pev1b.parent_structure_version_id = pev1a.element_version_id
and pev1a.proj_element_id = pe1.proj_element_id
and pev2b.element_version_id = c_elem_ver_to
and pev2b.parent_structure_version_id = pev2a.element_version_id
and pev2a.proj_element_id = pe1.proj_element_id;
select '1'
from pa_proj_elements pe1,
pa_proj_element_versions pev1a,
pa_proj_element_versions pev1b,
pa_object_relationships r
where pev1a.element_version_id = c_elem_ver_from
and pev1a.proj_element_id = pe1.proj_element_id
and pe1.project_id = pev1b.project_id
and pe1.proj_element_id = pev1b.proj_element_id
and pev1b.element_version_id = r.object_id_to1
and r.object_id_from1 IN
(select pev2b.element_version_id
from pa_proj_elements pe2,
pa_proj_element_versions pev2a,
pa_proj_element_versions pev2b
where pev2a.element_version_id = c_elem_ver_to
and pev2a.proj_element_id = pe2.proj_element_id
and pe2.project_id = pev2b.project_id
and pe2.proj_element_id = pev2b.proj_element_id);
select '1'
from pa_proj_elements pe1,
pa_proj_element_versions pev1a,
pa_proj_element_versions pev1b,
pa_object_relationships r
where pev1a.element_version_id = c_elem_ver_from
and pev1a.proj_element_id = pe1.proj_element_id
and pe1.project_id = pev1b.project_id
and pe1.proj_element_id = pev1b.proj_element_id
and pev1b.element_version_id = r.object_id_to1
and EXISTS
(select pev2b.element_version_id
from pa_proj_elements pe2,
pa_proj_element_versions pev2a,
pa_proj_element_versions pev2b
where pev2a.element_version_id = c_elem_ver_to
and pev2a.proj_element_id = pe2.proj_element_id
and pe2.project_id = pev2b.project_id
and pe2.proj_element_id = pev2b.proj_element_id
and r.object_id_from1 = pev2b.element_version_id);
select '1'
from pa_proj_element_versions a,
pa_proj_element_versions b
where a.element_version_id = c_from
and a.proj_element_id = b.proj_element_id
and a.project_id = b.project_id
and b.element_version_id IN (
select object_id_to1
from pa_object_relationships
start with object_id_from1 IN (
select b.element_version_id
from pa_proj_element_versions a,
pa_proj_element_versions b
where a.element_version_id = c_to
and a.proj_element_id = b.proj_element_id
and a.project_id = b.project_id
)
and object_type_from IN ('PA_TASKS','PA_STRUCTURES')
and object_type_to IN ('PA_TASKS','PA_STRUCTURES')
and relationship_type IN ('S','L')
connect by prior object_id_to1 = object_id_from1
and object_type_from IN ('PA_TASKS','PA_STRUCTURES')
and prior object_type_to IN ('PA_TASKS','PA_STRUCTURES')
and prior relationship_type IN ('S','L')
);
select a.object_id_from1
from pa_object_relationships a
where NOT EXISTS (select '1' from pa_object_relationships b
where b.object_id_to1 = a.object_id_from1)
start with a.object_id_to1 = c_element_version_id
and a.object_type_to IN ('PA_STRUCTURES','PA_TASKS')
connect by prior a.object_id_from1 = a.object_id_to1
and a.relationship_type IN ('S','L')
union
select a.object_id_from1
from pa_object_relationships a
where a.object_id_from1 = c_element_version_id
and object_type_from IN ('PA_STRUCTURES', 'PA_TASKS')
and relationship_type = 'S';
select object_id_to1
from pa_object_relationships
where relationship_type IN ('S', 'L')
start with object_id_from1 = c_top_node_id
and object_type_from IN ('PA_STRUCTURES','PA_TASKS')
connect by object_id_from1 = prior object_id_to1
and relationship_type IN ('L','S')
intersect
(
select pev1b.element_version_id
from pa_proj_element_versions pev1b,
pa_proj_elements pe1,
pa_proj_element_versions pev1a
where pev1b.project_id = pe1.project_id
and pev1b.proj_element_id = pe1.proj_element_id
and pev1a.proj_element_id = pe1.proj_element_id
and pev1a.element_version_id IN
( select object_id_to1
from pa_object_relationships
where relationship_type IN ('S','L')
start with object_id_from1 = c_linking_node_id
and object_type_from IN ('PA_STRUCTURES','PA_TASKS')
connect by object_id_from1 = prior object_id_to1
and relationship_type IN('L','S')
-- UNION
-- select object_id_from1
-- from pa_object_relationships
-- where relationship_type IN ('S','L')
-- start with object_id_to1 = c_linking_node_id
-- and object_type_to IN ('PA_STRUCTURES','PA_TASKS')
-- connect by prior object_id_from1 = object_id_to1
-- and relationship_type IN ('S','L')
UNION
select element_version_id
from pa_proj_element_versions
where element_version_id = c_linking_node_id
)
);
SELECT 'Y'
FROM pa_proj_elements ppe
,pa_proj_element_versions ppv1 /* to get link task version id */
,pa_proj_element_versions ppv2 /* to get sub project structure version ids */
,pa_object_relationships por
WHERE ppe.project_id = p_parent_project_id
AND ppe.link_task_flag = 'Y'
AND ppe.project_id = ppv1.project_id
AND ppe.proj_element_id = ppv1.proj_element_id
AND ppv1.parent_structure_version_id IN ( SELECT ppevs.element_version_id
FROM pa_proj_elem_ver_structure ppevs
WHERE ppevs.project_id = p_parent_project_id
AND ppevs.status_code = 'STRUCTURE_PUBLISHED'
AND ppevs.latest_eff_published_flag = 'Y' )
AND ppv2.project_id = p_sub_project_id
AND ppv2.object_type = 'PA_STRUCTURES'
AND ppv1.element_version_id = por.object_id_from1
AND por.relationship_type in ( 'LW', 'LF' ) -- ( 'WL', 'FL' ) -- Bug # 4760126.
AND ppv2.element_version_id = por.object_id_to1
AND object_type_from = 'PA_TASKS' --Bug 6429264
AND object_type_to = 'PA_STRUCTURES' --Bug 6429264
;
SELECT 'x'
FROM pa_object_relationships
WHERE object_id_from1 = p_task_ver_id
AND object_id_from2 = p_project_id
AND object_id_to1 = p_pre_task_ver_id
AND object_id_to2 = p_pre_project_id
AND relationship_type = 'D'
;
SELECT 'x'
FROM (
SELECT object_id_to1
FROM pa_object_relationships por2
WHERE relationship_type = 'D'
AND por2.object_id_from2 = por2.object_id_to2 --Bug 3629024
START WITH por2.object_id_from1 = p_pre_task_ver_id
AND relationship_type = 'D' --bug 3944567
CONNECT BY por2.object_id_from1 = PRIOR por2.object_id_to1
AND relationship_type = PRIOR relationship_type
AND relationship_type = 'D'
AND por2.object_id_from2 = PRIOR por2.object_id_from2 ) --Bug 3629024
where object_id_to1 = p_task_ver_id;
SELECT 'x'
FROM pa_object_relationships por1
WHERE por1.relationship_type = 'D'
AND por1.object_id_to1 = p_task_ver_id
AND por1.object_id_from1 IN
( SELECT por2.object_id_to1
FROM pa_object_relationships por2
START WITH por2.object_id_from1 = p_pre_task_ver_id
CONNECT BY por2.object_id_from1 = prior por2.object_id_to1
AND por2.relationship_type = prior por2.relationship_type
AND por2.relationship_type = 'S')
;
SELECT object_id_from1
FROM pa_object_relationships
where object_id_to1 = c_child_task_ver_id
and relationship_type = 'S'
;
SELECT 'x'
FROM pa_object_relationships
WHERE object_id_from1 = p_task_ver_id
AND object_id_from2 = p_project_id
AND object_id_to1 = p_pre_task_ver_id
AND object_id_to2 = p_pre_project_id
AND relationship_type = 'D'
;
SELECT 'x'
FROM pa_proj_element_versions
WHERE project_id = p_project_id
AND element_version_id = p_task_ver_id
;
SELECT 'x'
FROM pa_proj_element_versions
WHERE project_id = p_pre_project_id
AND element_version_id = p_pre_task_ver_id
;
select por.object_id_from1 task_ver_id, por.object_id_from2 project_id
from pa_object_relationships por
where por.relationship_type in ('LW', 'LF')
start with por.object_id_to2 = c_pre_project_id
connect by prior por.object_id_from2 = por.object_id_to2
and prior por.relationship_type = por.relationship_type
and por.relationship_type in ('LW', 'LF')
AND object_type_from = 'PA_TASKS' --Bug 6429264
AND object_type_to = 'PA_STRUCTURES' --Bug 6429264
union all
-- This query selects all the child projects of the predecessor project.
select por.object_id_to1 task_ver_id, por.object_id_to2 project_id
from pa_object_relationships por
where por.relationship_type in ('LW', 'LF')
start with por.object_id_from2 = c_pre_project_id
connect by prior por.object_id_to2 = por.object_id_from2
and prior por.relationship_type = por.relationship_type
and por.relationship_type in ('LW', 'LF')
AND object_type_from = 'PA_TASKS' --Bug 6429264
AND object_type_to = 'PA_STRUCTURES' --Bug 6429264
;
select 'Y'
from pa_object_relationships por
where por.object_id_from1 = c_task_ver_id
and por.object_id_to1 = c_linking_task_ver_id
and por.relationship_type = 'S';
SELECT ppe.name task_name
FROM pa_proj_element_versions ppev,
pa_proj_elements ppe
WHERE ppev.proj_element_id = ppe.proj_element_id
and ppev.project_id = ppe.project_id
AND ppev.element_version_id IN (SELECT object_id_to1
FROM pa_object_relationships por
WHERE por.object_id_from1 = c_element_version_id
--Bug8534395: Commented below predicate to allow tasks from other project to be shown as predecessors.
--AND por.object_id_from2 = por.object_id_to2
AND por.object_type_from = 'PA_TASKS' --4141109 Replaced LIKE with Equijoin
AND por.object_type_to = 'PA_TASKS' --4141109 Replaced LIKE with Equijoin
AND por.relationship_type = 'D'); --4141109 Replaced LIKE with Equijoin
SELECT 1 from pa_object_relationships
where relationship_type = 'D'
and (object_id_from1 = p_element_version_id OR
object_id_to1 = p_element_version_id);
select 1
from pa_object_relationships
where relationship_type IN ('LW', 'LF')
and object_id_to2 = p_project_id;*/
select 1
from pa_object_relationships por,
pa_proj_element_versions ppev
where por.relationship_type IN ('LW', 'LF')
and ppev.element_version_id = por.object_id_to1
and por.object_id_to2 = ppev.project_id
and por.object_id_to2 = p_project_id
AND object_type_from = 'PA_TASKS' --Bug 6429264
AND object_type_to = 'PA_STRUCTURES'; --Bug 6429264
select 1
from pa_object_relationships
where relationship_type IN ('LW', 'LF')
and object_id_from2 = p_project_id
AND object_type_from = 'PA_TASKS' --Bug 6429264
AND object_type_to = 'PA_STRUCTURES'; --Bug 6429264
select 1
from pa_object_relationships
where relationship_type IN ('LW', 'LF')
and object_id_to2 = p_project_id;*/
select 1
from pa_object_relationships por,
pa_proj_element_versions ppev
where por.relationship_type IN ('LW', 'LF')
and ppev.element_version_id = por.object_id_to1
and por.object_id_to2 = ppev.project_id
and por.object_id_to2 = p_project_id
AND object_type_from = 'PA_TASKS' --Bug 6429264
AND object_type_to = 'PA_STRUCTURES'; --Bug 6429264
select 1
from pa_object_relationships
where relationship_type IN ('LW', 'LF')
and object_id_from2 = p_project_id;
select count(1)
from pa_object_relationships
where relationship_type IN ('LW', 'LF')
and object_id_to2 = c_child_project_id
and object_id_from1 <> c_parent_project_id;*/
select count(1)
from pa_object_relationships por,
pa_proj_element_versions ppev
where relationship_type IN ('LW', 'LF')
and ppev.element_version_id = object_id_to1
and por.object_id_to2 = ppev.project_id
and object_id_to2 = c_child_project_id
and object_id_from2 <> c_parent_project_id;--bug 4244482
select object_id_from2, object_Id_to2
from pa_object_relationships
where relationship_type IN ('LW') --bug 3962849
start with object_id_from2 = p_project_id
and relationship_type = 'LW'
connect by prior object_id_to2 = object_id_from2
and prior relationship_type = relationship_type;
select object_id_from2, object_Id_to2
from pa_object_relationships
where relationship_type IN ('LF') --bug 3962849
start with object_id_from2 = p_project_id
and relationship_type = 'LF'
connect by prior object_id_to2 = object_id_from2
and prior relationship_type = relationship_type;
select project_id
from pa_proj_element_versions
where element_version_id = c_element_version_id;
select object_Id_to2, object_id_from2 -- Fix for Bug # 4297715.
from pa_object_relationships
where relationship_type IN ('LW')
start with object_id_from2 = c_project_id
connect by prior object_id_to2 = object_id_from2
and prior relationship_type = relationship_type
and relationship_type = 'LW';
select object_Id_to2, object_id_from2 -- Fix for Bug # 4297715.
from pa_object_relationships
where relationship_type IN ('LF')
start with object_id_from2 = c_project_id
connect by prior object_id_to2 = object_id_from2
and prior relationship_type = relationship_type
and relationship_type = 'LF';
SELECT sys_program_flag
FROM pa_projects_all
WHERE project_id =c_project_id;
SELECT ppa.sys_program_flag
FROM pa_proj_element_versions ppev,
pa_proj_elements ppe,
pa_projects_all ppa
WHERE ppe.project_id = ppev.project_id
AND ppe.proj_element_id = ppev.proj_element_id
AND ppev.object_type = 'PA_TASKS'
AND ppe.object_type = 'PA_TASKS'
AND ppe.project_id = ppa.project_id
AND ppev.element_version_id IN (
SELECT object_id_from1
FROM pa_object_relationships
WHERE relationship_type IN ('LW','LF')
START WITH object_id_to2 = c_project_id
AND object_type_to = 'PA_STRUCTURES'
CONNECT BY object_id_from2 = prior object_id_to2
and prior relationship_type = relationship_type
AND relationship_type IN ('LW','LF')
AND object_type_from = 'PA_TASKS');
select nvl(ALLOW_MULTI_PROGRAM_ROLLUP,'N')
from pa_projects_all
where project_id = c_project_id;
select distinct(object_id_from2)
from pa_object_relationships a
where a.relationship_type IN ('LW','LF')
and a.object_id_to2 = c_project_id
and a.object_id_from2 <> c_parent_proj_id -- Fix for Bug # 4297715.
and exists (select 1 from PA_PROJ_ELEMENT_VERSIONS elv /* Added the exists for Bug 6148092 */
where elv.element_version_id = a.object_id_from1
and ((elv.PARENT_STRUCTURE_VERSION_ID =
PA_PROJECT_STRUCTURE_UTILS.get_current_working_ver_id(elv.project_id))
or (elv.PARENT_STRUCTURE_VERSION_ID =
PA_PROJECT_STRUCTURE_UTILS.get_latest_wp_version(elv.project_id))
)
);
select ppevs.status_code
from pa_proj_elem_ver_structure ppevs, pa_proj_element_versions ppev
where ppev.element_version_id = c_task_version_id
and ppev.project_id = ppevs.project_id -- Bug # 4868867.
and ppev.parent_structure_version_id = ppevs.element_version_id;
select por.object_id_from2 project_id
from pa_object_relationships por
where por.relationship_type = 'D'
start with por.object_id_to1 = c_src_task_ver_id
-- connect by prior por.object_id_from2 = por.object_id_to2 -- Fix for Bug # 4256435.
connect by prior por.object_id_from1 = por.object_id_to1 -- Fix for Bug # 4256435.
and prior por.relationship_type = por.relationship_type
and por.relationship_type = 'D'
union all
-- This query selects all the predecessor projects of the source project.
select por.object_id_to2 project_id
from pa_object_relationships por
where por.relationship_type = 'D'
start with por.object_id_from1 = c_src_task_ver_id
-- connect by prior por.object_id_to2 = por.object_id_from2 -- Fix for Bug # 4256435.
connect by prior por.object_id_to1 = por.object_id_from1 -- Fix for Bug # 4256435.
and prior por.relationship_type = por.relationship_type
and por.relationship_type = 'D';
select ppwa.AUTO_ROLLUP_SUBPROJ_FLAG
from pa_proj_workplan_attr ppwa,
pa_proj_elements ppe,
pa_proj_structure_types ppst,
pa_structure_types pst
where ppe.project_id = p_project_id
and ppe.object_type = 'PA_STRUCTURES'
and ppe.proj_element_id = ppst.proj_element_id
and ppst.structure_type_id = pst.structure_type_id
and pst.structure_type = 'WORKPLAN'
and ppe.project_id = ppwa.project_id
and ppe.proj_element_id = ppwa.proj_element_id;
select por2.object_relationship_id, por2.relationship_type, ppev.element_version_id
from pa_object_relationships por1,
pa_object_relationships por2,
pa_proj_element_versions ppev,
pa_proj_elements ppe
where ppe.proj_element_id = p_task_id
and ppe.proj_element_id = ppev.proj_element_id
and ppe.project_id = ppev.project_id
and ppev.element_version_id = por1.object_id_from1
and por1.relationship_type = 'S'
and por2.object_id_to1 = p_structure_ver_id
and por2.object_id_from1 = por1.object_id_to1
and por2.relationship_type = p_relationship_type -- IN ('LF', 'LW') -- Fix for Bug # 4471484.
-- and rownum < 2 -- Fix for Bug # 4477118.
order by ppev.element_version_id desc ; -- por2.relationship_type desc, -- Fix for Bug # 4477118.
select por1.object_id_from1
from pa_object_relationships por1,
pa_object_relationships por2
where por2.object_id_to1 = p_structure_ver_id
and por2.object_id_from1 = por1.object_id_to1
and por2.relationship_type IN ('LF', 'LW')
and rownum < 2
order by por1.object_id_from1 desc;
select por2.object_relationship_id, por2.relationship_type, ppev.element_version_id
from pa_object_relationships por1,
pa_object_relationships por2,
pa_proj_element_versions ppev,
pa_proj_elements ppe
where ppe.proj_element_id = p_task_id
and ppe.proj_element_id = ppev.proj_element_id
and ppe.project_id = ppev.project_id
and ppev.element_version_id = por1.object_id_from1
and por1.relationship_type = 'S'
and por2.object_id_to1 = p_structure_ver_id
and por2.object_id_from1 = por1.object_id_to1
and por2.relationship_type = p_relationship_type
order by ppev.element_version_id desc ;
select por2.object_id_to1
from pa_object_relationships por1,
pa_object_relationships por2
where por1.object_id_from1 = p_task_ver_id
and por1.object_id_to1 = por2.object_id_from1
and por2.relationship_type IN ('LF', 'LW')
and rownum < 2
order by por2.object_id_to1 desc;
SELECT por1.object_id_to1 RELATED_TASK
FROM pa_object_relationships por1
WHERE por1.relationship_type = 'D'
AND LEVEL = 1
AND por1.object_id_from2 = por1.object_id_to2
START WITH por1.object_id_from1 = p_src_task_ver_id
CONNECT BY PRIOR por1.object_id_to1 = por1.object_id_from1
AND PRIOR por1.relationship_type = por1.relationship_type
AND PRIOR por1.object_id_from2 = por1.object_id_from2
;
SELECT por1.object_id_to1 RELATED_TASK
FROM pa_object_relationships por1
WHERE por1.relationship_type = 'S'
AND por1.relationship_subtype = 'TASK_TO_TASK'
START WITH por1.object_id_from1 = p_src_task_ver_id
AND relationship_type = 'S' --bug 3944567
CONNECT BY PRIOR por1.object_id_to1 = por1.object_id_from1
AND PRIOR por1.relationship_type = por1.relationship_type
UNION
SELECT por2.object_id_from1 RELATED_TASK
FROM pa_object_relationships por2
WHERE por2.relationship_type = 'S'
AND por2.relationship_subtype = 'TASK_TO_TASK'
START WITH por2.object_id_to1 = p_src_task_ver_id
AND relationship_type = 'S' --bug 3944567
CONNECT BY PRIOR por2.object_id_from1 = por2.object_id_to1
AND PRIOR por2.relationship_type = por2.relationship_type
UNION
SELECT p_src_task_ver_id RELATED_TASK
FROM dual
;
select object_id_from1 elem_ver_id
from pa_object_relationships
start with object_id_to1 = p_orig_succ_task_ver_id
and relationship_type = 'D'
connect by object_id_to1 = prior object_id_from1
and relationship_type = prior relationship_type
and object_id_to2 = object_id_from2
INTERSECT
select object_id_to1
from pa_object_relationships
start with object_id_to1 = p_src_task_ver_id
and relationship_type = 'S'
connect by prior object_id_to1 = object_id_from1
and relationship_type = prior relationship_type;
Select count(1) from pa_object_relationships
where relationship_type IN ('LW', 'LF')
and (object_id_from2 = p_project_id or object_id_to2 = p_project_id);
Select count(1) from pa_object_relationships
where relationship_type = 'LF'
and (object_id_from2 = p_project_id or object_id_to2 = p_project_id);
Select count(1) from pa_object_relationships
where relationship_type = 'LW'
and (object_id_from2 = p_project_id or object_id_to2 = p_project_id);
select project_currency_code
from pa_projects_all
where project_id = C_project_id;
select count(1)
from pa_object_relationships
where relationship_type = 'D'
and object_id_from1 IN ( --get all tasks in upper branch
select object_id_to1
from pa_object_relationships
start with object_id_to1 = p_new_parent_task_ver_id
and relationship_type = 'S'
connect by prior object_id_from1 = object_id_to1
and relationship_type = prior relationship_type
and prior object_type_from = object_type_to)
and object_id_to1 IN ( --get all tasks in lower branch
select object_id_to1
from pa_object_relationships
start with object_id_to1 = p_task_ver_id
and relationship_type = 'S'
connect by prior object_id_to1 = object_id_from1
and relationship_type = prior relationship_type
and prior object_type_to = object_type_from);
select count(1)
from pa_object_relationships
where relationship_type = 'D'
and object_id_from1 IN ( --get tasks in lower branch
select object_id_to1
from pa_object_relationships
start with object_id_to1 = p_task_ver_id
and relationship_type = 'S'
connect by prior object_id_to1 = object_id_from1
and relationship_type = prior relationship_type
and prior object_type_to = object_type_from)
and object_id_to1 IN ( --get tasks in upper branch
select object_id_to1
from pa_object_relationships
start with object_id_to1 = p_new_parent_task_ver_id
and relationship_type = 'S'
connect by prior object_id_from1 = object_id_to1
and relationship_type = prior relationship_type
and prior object_type_from = object_type_to);
select count(pslv.sub_project_id)
from pa_structures_links_v pslv
where pslv.parent_project_id = c_project_id
and pslv.parent_task_id = c_task_id
and pslv.parent_task_version_id = c_task_version_id;
select ppev.element_version_id
from pa_proj_element_versions ppev
where ppev.project_id = c_project_id
and ppev.proj_element_id = c_task_id
and ppev.parent_structure_version_id = c_structure_version_id;
select 1
from dual
where exists (select 1
from pa_proj_element_versions pev, pa_object_relationships por, pa_proj_elem_ver_structure ppevs
where pev.parent_structure_version_id = c_object_id_from
and pev.element_version_id = por.object_id_from1
and por.object_id_to1 = ppevs.element_version_id
-- Bug Fix 5077552
-- Adding the project id to avoid the FTS on ppevs.
and por.object_id_to2 = ppevs.project_id
and por.object_type_to = 'PA_STRUCTURES'
and por.relationship_type in (c_relationship_type, 'S')
and ppevs.status_code='STRUCTURE_WORKING');
select ppevs.status_code status_code
from (select por.object_id_to1
from pa_object_relationships por
where por.object_type_to = 'PA_STRUCTURES'
and relationship_type in (c_relationship_type, 'S')
start with por.object_id_from1 = c_object_id_from
connect by prior por.object_id_to1 = por.object_id_from1
and prior relationship_type in (c_relationship_type, 'S')) por
,pa_proj_elem_ver_structure ppevs
where
por.object_id_to1 = ppevs.element_version_id (+);
select ppevs.status_code status_code
from pa_object_relationships por, pa_proj_elem_ver_structure ppevs
where por.object_id_to1 = ppevs.element_version_id (+)
and por.object_type_to = 'PA_STRUCTURES'
and relationship_type in (c_relationship_type, 'S')
start with por.object_id_from1 = c_object_id_from
connect by prior por.object_id_to1 = por.object_id_from1
and prior relationship_type in (c_relationship_type, 'S');
SELECT '1'
from pa_object_relationships por
WHERE p_structure_ver_id = por.object_id_to1
and por.object_id_to2 = p_project_id
and por.relationship_type IN ('LW', 'LF');
SELECT '1'
from pa_object_relationships por
WHERE p_structure_ver_id = por.object_id_to1
and por.object_id_to2 = p_project_id
and por.relationship_type = 'LW';
SELECT '1'
from pa_object_relationships por
WHERE p_structure_ver_id = por.object_id_to1
and por.object_id_to2 = p_project_id
and por.relationship_type = 'LF';
Select count(1) from pa_object_relationships
where relationship_type IN ('LW', 'LF')
and object_id_from2 = p_project_id;
Select count(1) from pa_object_relationships
where relationship_type = 'LF'
and object_id_from2 = p_project_id;
Select count(1) from pa_object_relationships
where relationship_type = 'LW'
and (object_id_from2 = p_project_id);