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_ELEMENTS

Line 262: FROM pji_xbs_denorm denorm, pa_proj_elements emt,pa_proj_element_versions ver

258: SELECT denorm.sup_project_id,'N',denorm.sup_project_id,denorm.sup_emt_id,
259: denorm.sub_emt_id,'N',emt.name,DECODE(denorm.sub_level-sup_level,0,'N','Y'),DECODE(denorm.sub_leaf_flag,'Y','N','Y'),
260: SYSDATE, SYSDATE, 1, 1,
261: 0 ,p_element_version_id, ver.display_sequence,p_element_version_id, denorm.relationship_type
262: FROM pji_xbs_denorm denorm, pa_proj_elements emt,pa_proj_element_versions ver
263: WHERE 1=1
264: AND denorm.sup_project_id = p_project_id
265: AND denorm.struct_version_id = p_element_version_id
266: AND denorm.sub_level - denorm.sup_level<=1

Line 299: , pa_proj_elements emt

295: , ver.display_sequence
296: , p_element_version_id
297: , denorm.relationship_type
298: FROM pji_xbs_denorm denorm
299: , pa_proj_elements emt
300: ,pa_proj_element_versions ver
301: WHERE 1=1
302: AND denorm.sup_project_id = p_project_id
303: AND denorm.sub_emt_id = emt.proj_element_id

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 425: FROM pa_proj_elements emt, pji_xbs_denorm denorm,

421: ,p_element_version_id
422: , ver.display_sequence
423: ,denorm.struct_version_id
424: , denorm.relationship_type
425: FROM pa_proj_elements emt, pji_xbs_denorm denorm,
426: (SELECT sub_id wbs_version_id, sub_leaf_flag
427: FROM pji_xbs_denorm
428: WHERE 1=1
429: AND sup_project_id = p_project_id

Line 475: , pa_proj_elements emt

471: , ver.display_sequence
472: , denorm.struct_version_id
473: , denorm.relationship_type
474: FROM pji_xbs_denorm denorm
475: , pa_proj_elements emt
476: , (SELECT sub_id wbs_version_id, sub_leaf_flag
477: FROM pji_xbs_denorm
478: WHERE 1=1
479: AND sup_project_id = p_project_id

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 630: , pa_proj_elements elem

626: MAX(DECODE(header_p.plan_version_id,p_plan2_version_id,header.plan_version_id,NULL)),
627: MAX(DECODE(header_p.plan_version_id,p_current_version_id,header.wbs_version_id,NULL))
628: FROM
629: pji_xbs_denorm denorm
630: , pa_proj_elements elem
631: , pji_pjp_wbs_header header
632: , pji_pjp_wbs_header header_p
633: WHERE 1=1
634: AND header_p.project_id = p_project_id

Line 3359: FROM pa_proj_elements

3355:
3356: BEGIN
3357: SELECT object_type
3358: INTO l_object_type
3359: FROM pa_proj_elements
3360: WHERE proj_element_id = p_wbs_element_id;
3361: EXCEPTION
3362: WHEN NO_DATA_FOUND THEN
3363: l_object_type := 'PA_STRUCTURES';

Line 3626: pa_proj_elements ele,

3622: c_currency_code pa_projects_all.project_currency_code%TYPE)
3623: IS
3624: SELECT 1
3625: FROM pji_xbs_denorm denorm,
3626: pa_proj_elements ele,
3627: pa_projects_all proj
3628: WHERE denorm.sup_project_id = c_project_id
3629: AND denorm.sup_id = c_wbs_version_id
3630: AND denorm.struct_type = 'PRG'

Line 3642: pa_proj_elements ele,

3638: c_currency_code pa_projects_all.project_currency_code%TYPE)
3639: IS
3640: SELECT 1
3641: FROM pji_xbs_denorm denorm,
3642: pa_proj_elements ele,
3643: pa_projects_all proj
3644: WHERE denorm.sup_project_id = c_project_id
3645: AND denorm.sup_id = c_wbs_version_id
3646: AND denorm.struct_type = 'PRG'

Line 3847: pa_proj_elements ele

3843: c_published_flag VARCHAR2)
3844: IS
3845: SELECT 1
3846: FROM pji_xbs_denorm denorm,
3847: pa_proj_elements ele
3848: WHERE denorm.sup_project_id = c_project_id
3849: AND denorm.sup_id = c_wbs_version_id
3850: AND denorm.struct_type = 'PRG'
3851: AND denorm.struct_version_id IS NULL

Line 4748: , pa_proj_elements elem

4744: INTO l_num_of_gl_cal,
4745: l_num_of_pa_cal
4746: FROM
4747: pji_xbs_denorm denorm
4748: , pa_proj_elements elem
4749: , pa_projects_all proj
4750: , pji_org_extr_info info
4751: WHERE 1=1
4752: AND denorm.sup_project_id = p_project_id -- project_id

Line 4839: , pa_proj_elements elem

4835: SELECT COUNT(DISTINCT proj.projfunc_currency_code)
4836: INTO l_num_of_projfunc_curr
4837: FROM
4838: pji_xbs_denorm denorm
4839: , pa_proj_elements elem
4840: , pa_projects_all proj
4841: WHERE 1=1
4842: AND denorm.sup_project_id = p_project_id -- project_id
4843: AND denorm.sup_id = p_wbs_version_id -- wbs_version_id

Line 5683: , pa_proj_elements elem

5679: Select count(*)
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