eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKE_PA_CHECKS_PUB dependencies on PA_TASKS

Line 166: WHERE object_type_from = 'PA_TASKS'

162: SELECT *
163: FROM pa_object_relationships
164: WHERE NOT (object_id_from2=p_delf_proj AND object_id_from1=p_delf_task AND object_id_to1=p_delt_proj)
165: )
166: WHERE object_type_from = 'PA_TASKS'
167: AND object_type_to = 'PA_PROJECTS'
168: AND relationship_type = 'H'
169: START WITH (object_id_from2, object_id_from1)
170: IN (SELECT p_from_proj, task_id FROM pa_tasks

Line 170: IN (SELECT p_from_proj, task_id FROM pa_tasks

166: WHERE object_type_from = 'PA_TASKS'
167: AND object_type_to = 'PA_PROJECTS'
168: AND relationship_type = 'H'
169: START WITH (object_id_from2, object_id_from1)
170: IN (SELECT p_from_proj, task_id FROM pa_tasks
171: WHERE project_id = p_from_proj
172: AND top_task_id = nvl(p_from_task, top_task_id))
173: CONNECT BY object_id_from2 = PRIOR object_id_to1
174: UNION ALL

Line 178: WHERE NOT (object_id_to2=p_delt_proj AND object_type_from = 'PA_TASKS'

174: UNION ALL
175: SELECT object_id_to2 prj_id FROM (
176: SELECT *
177: FROM pa_object_relationships p
178: WHERE NOT (object_id_to2=p_delt_proj AND object_type_from = 'PA_TASKS'
179: AND object_id_from1 IN (SELECT ppev.element_version_id
180: FROM pa_tasks pt, pa_proj_element_versions ppev, pa_proj_elem_ver_structure ppevs
181: WHERE ppev.proj_element_id = pt.task_id
182: AND pt.top_task_id = nvl(p_delf_task, pt.top_task_id)

Line 180: FROM pa_tasks pt, pa_proj_element_versions ppev, pa_proj_elem_ver_structure ppevs

176: SELECT *
177: FROM pa_object_relationships p
178: WHERE NOT (object_id_to2=p_delt_proj AND object_type_from = 'PA_TASKS'
179: AND object_id_from1 IN (SELECT ppev.element_version_id
180: FROM pa_tasks pt, pa_proj_element_versions ppev, pa_proj_elem_ver_structure ppevs
181: WHERE ppev.proj_element_id = pt.task_id
182: AND pt.top_task_id = nvl(p_delf_task, pt.top_task_id)
183: AND pt.task_id = pt.top_task_id
184: AND pt.project_id = p_delf_proj

Line 190: START WITH object_type_from = 'PA_TASKS' AND object_id_from1

186: AND ppev.parent_structure_version_id = ppevs.element_version_id
187: AND ppevs.status_code = 'STRUCTURE_PUBLISHED'
188: AND ppevs.latest_eff_published_flag = 'Y' ))
189: )
190: START WITH object_type_from = 'PA_TASKS' AND object_id_from1
191: IN (SELECT ppev.element_version_id
192: FROM pa_tasks pt, pa_proj_element_versions ppev, pa_proj_elem_ver_structure ppevs
193: WHERE ppev.proj_element_id = pt.task_id
194: AND pt.top_task_id = nvl(p_from_task, pt.top_task_id)

Line 192: FROM pa_tasks pt, pa_proj_element_versions ppev, pa_proj_elem_ver_structure ppevs

188: AND ppevs.latest_eff_published_flag = 'Y' ))
189: )
190: START WITH object_type_from = 'PA_TASKS' AND object_id_from1
191: IN (SELECT ppev.element_version_id
192: FROM pa_tasks pt, pa_proj_element_versions ppev, pa_proj_elem_ver_structure ppevs
193: WHERE ppev.proj_element_id = pt.task_id
194: AND pt.top_task_id = nvl(p_from_task, pt.top_task_id)
195: AND pt.task_id = pt.top_task_id
196: AND pt.project_id = p_from_proj

Line 266: WHERE object_type_from = 'PA_TASKS'

262: SELECT k_header_id header_id, NULL, bill_project_id FROM oke_k_billing_events
263: ) WHERE project_id IN (
264: SELECT to_number(object_id_to1) project_id
265: FROM pa_object_relationships
266: WHERE object_type_from = 'PA_TASKS'
267: AND object_type_to = 'PA_PROJECTS'
268: AND relationship_type = 'H'
269: START WITH object_id_from2 = p_project_ID
270: CONNECT BY object_id_from2 = PRIOR object_id_to1