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_PROJ_ELEM_VER_STRUCTURE

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 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 276: FROM pa_proj_elem_ver_structure ppevs

272: SELECT TO_NUMBER(OBJECT_ID_TO2) PROJECT_ID
273: FROM PA_OBJECT_RELATIONSHIPS p
274: START WITH OBJECT_TYPE_FROM = 'PA_STRUCTURES' AND object_id_from1 IN
275: (SELECT element_version_id
276: FROM pa_proj_elem_ver_structure ppevs
277: WHERE ppevs.project_id=p_project_ID
278: AND status_code = 'STRUCTURE_PUBLISHED'
279: AND ppevs.latest_eff_published_flag = 'Y')
280: CONNECT BY object_id_from1 = PRIOR object_id_to1