[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT 'Y' FROM (
SELECT project_id FROM oke_k_headers
UNION ALL
SELECT project_id FROM oke_k_lines
UNION ALL
SELECT project_id FROM oke_k_fund_allocations
UNION ALL
SELECT project_id FROM oke_k_deliverables_b
UNION ALL
SELECT bill_project_id FROM oke_k_billing_events
) WHERE project_id=l_project_id;
SELECT 'Y' FROM (
SELECT task_id FROM oke_k_lines
UNION ALL
SELECT task_id FROM oke_k_fund_allocations
UNION ALL
SELECT task_id FROM oke_k_deliverables_b
UNION ALL
SELECT bill_task_id FROM oke_k_billing_events
) WHERE task_id=l_task_id;
SELECT PROJECT_ID, TASK_ID
FROM OKE_K_LINES E, OKC_ANCESTRYS A
WHERE K_LINE_ID = CLE_ID_ASCENDANT AND CLE_ID = P_LINE_ID AND PROJECT_ID IS NOT NULL
ORDER BY LEVEL_SEQUENCE desc
;
SELECT PROJECT_ID, TASK_ID, parent_line_id
FROM OKE_K_LINES
WHERE K_LINE_ID = CP_LINE_ID AND PROJECT_ID IS NOT NULL
;
SELECT PROJECT_ID FROM oke_k_headers WHERE k_header_id = p_head_id
;
SELECT 'x' FROM dual
WHERE p_to_proj IN (
SELECT object_id_to1 prj_id FROM (
SELECT *
FROM pa_object_relationships
WHERE NOT (object_id_from2=p_delf_proj AND object_id_from1=p_delf_task AND object_id_to1=p_delt_proj)
)
WHERE object_type_from = 'PA_TASKS'
AND object_type_to = 'PA_PROJECTS'
AND relationship_type = 'H'
START WITH (object_id_from2, object_id_from1)
IN (SELECT p_from_proj, task_id FROM pa_tasks
WHERE project_id = p_from_proj
AND top_task_id = nvl(p_from_task, top_task_id))
CONNECT BY object_id_from2 = PRIOR object_id_to1
UNION ALL
SELECT object_id_to2 prj_id FROM (
SELECT *
FROM pa_object_relationships p
WHERE NOT (object_id_to2=p_delt_proj AND object_type_from = 'PA_TASKS'
AND object_id_from1 IN (SELECT ppev.element_version_id
FROM pa_tasks pt, pa_proj_element_versions ppev, pa_proj_elem_ver_structure ppevs
WHERE ppev.proj_element_id = pt.task_id
AND pt.top_task_id = nvl(p_delf_task, pt.top_task_id)
AND pt.task_id = pt.top_task_id
AND pt.project_id = p_delf_proj
AND ppev.project_id = ppevs.project_id
AND ppev.parent_structure_version_id = ppevs.element_version_id
AND ppevs.status_code = 'STRUCTURE_PUBLISHED'
AND ppevs.latest_eff_published_flag = 'Y' ))
)
START WITH object_type_from = 'PA_TASKS' AND object_id_from1
IN (SELECT ppev.element_version_id
FROM pa_tasks pt, pa_proj_element_versions ppev, pa_proj_elem_ver_structure ppevs
WHERE ppev.proj_element_id = pt.task_id
AND pt.top_task_id = nvl(p_from_task, pt.top_task_id)
AND pt.task_id = pt.top_task_id
AND pt.project_id = p_from_proj
AND ppev.project_id = ppevs.project_id
AND ppev.parent_structure_version_id = ppevs.element_version_id
AND ppevs.status_code = 'STRUCTURE_PUBLISHED'
AND ppevs.latest_eff_published_flag = 'Y' )
CONNECT BY object_id_from1 = PRIOR object_id_to1 AND relationship_type IN ('S','LF')
)
;
SELECT header_id, line_id, project_id FROM (
SELECT dnz_chr_id header_id, c.cle_id line_id, project_id
FROM oke_k_lines e, okc_k_lines_b c
WHERE e.k_line_id=c.id
UNION ALL
SELECT object_id header_id, k_line_id, project_id FROM oke_k_fund_allocations
UNION ALL
SELECT k_header_id header_id, k_line_id, project_id FROM oke_k_deliverables_b
UNION ALL
SELECT k_header_id header_id, NULL, bill_project_id FROM oke_k_billing_events
) WHERE project_id IN (
SELECT to_number(object_id_to1) project_id
FROM pa_object_relationships
WHERE object_type_from = 'PA_TASKS'
AND object_type_to = 'PA_PROJECTS'
AND relationship_type = 'H'
START WITH object_id_from2 = p_project_ID
CONNECT BY object_id_from2 = PRIOR object_id_to1
UNION ALL
SELECT TO_NUMBER(OBJECT_ID_TO2) PROJECT_ID
FROM PA_OBJECT_RELATIONSHIPS p
START WITH OBJECT_TYPE_FROM = 'PA_STRUCTURES' AND object_id_from1 IN
(SELECT element_version_id
FROM pa_proj_elem_ver_structure ppevs
WHERE ppevs.project_id=p_project_ID
AND status_code = 'STRUCTURE_PUBLISHED'
AND ppevs.latest_eff_published_flag = 'Y')
CONNECT BY object_id_from1 = PRIOR object_id_to1
AND relationship_type IN('S','LF')
UNION ALL
SELECT p_project_ID FROM DUAL
) ORDER BY project_id, line_id
;