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.PJI_REP_UTIL dependencies on PA_PROJ_ELEM_VER_STRUCTURE

Line 98: SELECT ppa.project_id from PA_PROJECTS_ALL ppa, PA_PROJ_ELEM_VER_STRUCTURE ppevs WHERE

94: , last_updated_by, creation_date, created_by, last_update_login, attribute1, attribute2)
95: SELECT 'STRUCT_CHANGE',pa_pji_proj_events_log_s.NEXTVAL,'-99','X','X',SYSDATE,
96: Fnd_Global.USER_ID,SYSDATE,Fnd_Global.USER_ID,Fnd_Global.LOGIN_ID,p_wbs_version_id_tbl(l_i),'N'
97: FROM dual WHERE exists (
98: SELECT ppa.project_id from PA_PROJECTS_ALL ppa, PA_PROJ_ELEM_VER_STRUCTURE ppevs WHERE
99: ppa.project_id = ppevs.project_id AND
100: ppevs.ELEMENT_VERSION_ID = p_wbs_version_id_tbl(l_i) AND
101: ppa.template_flag <> 'Y'
102: );

Line 228: FROM pa_proj_elem_ver_structure struct_ver

224: SELECT p_project_id,'N',p_project_id,-1,struct_ver.proj_element_id,
225: 'N',struct_ver.NAME,'Y','Y' ,
226: SYSDATE, SYSDATE, 1, 1,
227: 0 ,p_element_version_id, -1, p_element_version_id, 'WF'
228: FROM pa_proj_elem_ver_structure struct_ver
229: WHERE 1=1
230: AND struct_ver.project_id = p_project_id
231: AND struct_ver.element_version_id = p_element_version_id;
232:

Line 245: FROM pa_proj_elem_ver_structure struct_ver

241: SELECT p_project_id,'N',p_project_id,struct_ver.proj_element_id,
242: struct_ver.proj_element_id,'N',struct_ver.NAME,'N','N' ,
243: SYSDATE, SYSDATE, 1, 1,
244: 0 ,p_element_version_id, 0, p_element_version_id, 'WF'
245: FROM pa_proj_elem_ver_structure struct_ver
246: WHERE 1=1
247: AND struct_ver.project_id = p_project_id
248: AND struct_ver.element_version_id = p_element_version_id;
249:

Line 356: FROM pa_proj_elem_ver_structure struct_ver

352: ,p_element_version_id
353: , -1
354: ,p_element_version_id
355: , 'WF'
356: FROM pa_proj_elem_ver_structure struct_ver
357: WHERE 1=1
358: AND struct_ver.project_id = p_project_id
359: AND struct_ver.element_version_id = p_element_version_id;
360:

Line 388: FROM pji_xbs_denorm denorm, pa_proj_elem_ver_structure struct_ver, pa_proj_elements emt

384: ,p_element_version_id
385: , 0
386: , denorm.sup_id
387: , 'WF'
388: FROM pji_xbs_denorm denorm, pa_proj_elem_ver_structure struct_ver, pa_proj_elements emt
389: WHERE 1=1
390: AND denorm.sup_project_id = p_project_id
391: AND denorm.sup_id = p_element_version_id
392: AND denorm.struct_version_id IS NULL

Line 521: FROM pji_xbs_denorm denorm, pa_proj_elem_ver_structure struct_ver,pa_proj_elements emt

517: ,p_element_version_id
518: , -1
519: , sub_id
520: , denorm.relationship_type
521: FROM pji_xbs_denorm denorm, pa_proj_elem_ver_structure struct_ver,pa_proj_elements emt
522: , (SELECT sub_id wbs_version_id, sub_leaf_flag
523: FROM pji_xbs_denorm
524: WHERE 1=1
525: AND sup_project_id = p_project_id

Line 1766: pa_proj_elem_ver_structure

1762: IS
1763: CURSOR c_wbs_params IS
1764: SELECT element_version_id, proj_element_id
1765: FROM
1766: pa_proj_elem_ver_structure
1767: WHERE
1768: project_id = p_project_id
1769: ORDER BY NVL(Latest_eff_published_flag,'N') DESC, NVL(current_working_flag,'N') DESC;
1770: BEGIN

Line 4130: FROM pa_proj_elem_ver_structure str,

4126: IS
4127: CURSOR get_baselined_version(c_project_id pa_projects_all.project_id%TYPE)
4128: IS
4129: SELECT header.plan_version_id
4130: FROM pa_proj_elem_ver_structure str,
4131: pji_pjp_wbs_header header
4132: WHERE str.project_id = c_project_id
4133: AND str.current_flag = 'Y'
4134: AND header.project_id = str.project_id

Line 4157: FROM pa_proj_elem_ver_structure str,

4153: IS
4154: CURSOR get_latest_published_version(c_project_id pa_projects_all.project_id%TYPE)
4155: IS
4156: SELECT header.plan_version_id
4157: FROM pa_proj_elem_ver_structure str,
4158: pji_pjp_wbs_header header
4159: WHERE str.project_id = c_project_id
4160: AND str.latest_eff_published_flag = 'Y'
4161: AND header.project_id = str.project_id

Line 5325: FROM pa_proj_elem_ver_structure vs

5321:
5322: CURSOR struct_list(c_structure_version_id pa_proj_element_versions.element_version_id%TYPE
5323: , c_structure_type VARCHAR2) IS
5324: SELECT vs.element_version_id, vs.project_id
5325: FROM pa_proj_elem_ver_structure vs
5326: , pji_xbs_denorm denorm
5327: WHERE denorm.struct_version_id IS NULL
5328: AND denorm.struct_type = 'PRG'
5329: AND NVL(denorm.relationship_type,'WF') IN ('WF',c_structure_type)

Line 5430: ,pa_proj_elem_ver_structure vs

5426:
5427: SELECT COUNT(DISTINCT UPPER(pt.project_type_class_code))
5428: INTO l_proj_type_count
5429: FROM pji_xbs_denorm denorm
5430: ,pa_proj_elem_ver_structure vs
5431: ,pa_projects_all proj
5432: ,pa_project_types_all pt
5433: WHERE struct_type = 'PRG'
5434: AND sup_project_id = p_project_id

Line 5684: , pa_proj_elem_ver_structure ppevs

5680: INTO l_count
5681: FROM
5682: pji_xbs_denorm denorm
5683: , pa_proj_elements elem
5684: , pa_proj_elem_ver_structure ppevs
5685: WHERE 1=1
5686: AND denorm.sup_project_id = p_project_id
5687: AND denorm.sup_id = p_structure_version_id
5688: AND denorm.struct_type = 'PRG'