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.INV_EGO_REVISION_VALIDATE dependencies on PA_PROJ_ELEMENT_VERSIONS

Line 144: FROM pa_proj_element_versions pev_l

140: CURSOR c_Check_Lifecyle_Phase ( p_lifecycle_id NUMBER,
141: p_lifecycle_phase_id NUMBER) IS
142: --4932389 : Perf fixes for lifecycle-phase-status queries.
143: SELECT 'x'
144: FROM pa_proj_element_versions pev_l
145: ,pa_lifecycle_usages plu
146: ,pa_proj_element_versions pev_p
147: ,pa_proj_elements ppe_p
148: ,pa_project_statuses pc

Line 146: ,pa_proj_element_versions pev_p

142: --4932389 : Perf fixes for lifecycle-phase-status queries.
143: SELECT 'x'
144: FROM pa_proj_element_versions pev_l
145: ,pa_lifecycle_usages plu
146: ,pa_proj_element_versions pev_p
147: ,pa_proj_elements ppe_p
148: ,pa_project_statuses pc
149: WHERE pev_l.object_type = 'PA_STRUCTURES'
150: AND pev_l.proj_element_id = p_lifecycle_id

Line 201: FROM pa_proj_element_versions pev_l

197:
198: CURSOR c_Get_Lifecyle_Phase ( p_lifecycle_id NUMBER) IS
199: --4932389 : Perf fixes for lifecycle-phase-status queries.
200: SELECT pev_p.proj_element_id
201: FROM pa_proj_element_versions pev_l
202: ,pa_lifecycle_usages plu
203: ,pa_proj_element_versions pev_p
204: ,pa_proj_elements ppe_p
205: ,pa_project_statuses pc

Line 203: ,pa_proj_element_versions pev_p

199: --4932389 : Perf fixes for lifecycle-phase-status queries.
200: SELECT pev_p.proj_element_id
201: FROM pa_proj_element_versions pev_l
202: ,pa_lifecycle_usages plu
203: ,pa_proj_element_versions pev_p
204: ,pa_proj_elements ppe_p
205: ,pa_project_statuses pc
206: WHERE pev_l.object_type = 'PA_STRUCTURES'
207: AND pev_l.proj_element_id = p_lifecycle_id