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_PJP_SUM_DENORM dependencies on PA_PROJ_ELEMENTS

Line 670: ,pa_proj_elements proje1s

666: , decode( temp.struct_type,'WBS',l_top_proj_element_id,null) struct_emt_id
667: ,temp.sub_rollup_id,0,0,0,temp.sub_element_number,temp.subro_element_number
668: from pa_xbs_denorm_temp temp
669: ,PA_PROJ_ELEMENT_VERSIONS projv1s
670: ,pa_proj_elements proje1s
671: where proje1s.element_number= temp.sup_element_number
672: and proje1s.proj_element_id =projv1s.proj_element_id
673: and projv1s.parent_structure_version_id=temp.struct_version_id
674: and projv1s.parent_structure_version_id=p_wbs_version_id_to;

Line 713: ,(select projeb.element_number from pa_proj_elements projeb

709: ,xbs.sup_emt_id,xbs.sup_id,p_wbs_version_id_to struct_version_id
710: , xbs.sub_leaf_flag,xbs.sup_level, xbs.sub_level
711: , xbs.relationship_type,xbs.struct_emt_id,xbs.sub_rollup_id
712: ,xbs.sub_id,xbs.sub_emt_id,xbs.subro_id
713: ,(select projeb.element_number from pa_proj_elements projeb
714: where projeb.proj_element_id= xbs.sub_emt_id ) sub_element_number
715: ,(select decode( proje.object_type,'PA_TASKS',proje.element_number,'PA_STRUCTURES',to_char(l_top_proj_element_id ),null) from pa_proj_elements proje
716: where proje.proj_element_id= xbs.sup_emt_id ) sup_element_number
717: ,(select projec.element_number from pa_proj_elements projec

Line 715: ,(select decode( proje.object_type,'PA_TASKS',proje.element_number,'PA_STRUCTURES',to_char(l_top_proj_element_id ),null) from pa_proj_elements proje

711: , xbs.relationship_type,xbs.struct_emt_id,xbs.sub_rollup_id
712: ,xbs.sub_id,xbs.sub_emt_id,xbs.subro_id
713: ,(select projeb.element_number from pa_proj_elements projeb
714: where projeb.proj_element_id= xbs.sub_emt_id ) sub_element_number
715: ,(select decode( proje.object_type,'PA_TASKS',proje.element_number,'PA_STRUCTURES',to_char(l_top_proj_element_id ),null) from pa_proj_elements proje
716: where proje.proj_element_id= xbs.sup_emt_id ) sup_element_number
717: ,(select projec.element_number from pa_proj_elements projec
718: where projec.proj_element_id= xbs.subro_id) subro_element_number
719: from pa_xbs_denorm xbs

Line 717: ,(select projec.element_number from pa_proj_elements projec

713: ,(select projeb.element_number from pa_proj_elements projeb
714: where projeb.proj_element_id= xbs.sub_emt_id ) sub_element_number
715: ,(select decode( proje.object_type,'PA_TASKS',proje.element_number,'PA_STRUCTURES',to_char(l_top_proj_element_id ),null) from pa_proj_elements proje
716: where proje.proj_element_id= xbs.sup_emt_id ) sup_element_number
717: ,(select projec.element_number from pa_proj_elements projec
718: where projec.proj_element_id= xbs.subro_id) subro_element_number
719: from pa_xbs_denorm xbs
720: ,PA_PROJ_ELEMENT_VERSIONS projsup
721: where xbs.sup_emt_id =projsup.proj_element_id

Line 803: ,(select proje1.proj_element_id from pa_proj_elements proje1

799: ,temp.sup_id ,projv1b.element_version_id sub_id
800: ,temp.sup_level, temp.sub_level
801: ,temp.relationship_type ,temp.sub_leaf_flag
802: ,temp.struct_emt_id,temp.sub_rollup_id
803: ,(select proje1.proj_element_id from pa_proj_elements proje1
804: ,PA_PROJ_ELEMENT_VERSIONS projv1
805: WHERE PROJE1.PROJECT_ID=TEMP.SUP_PROJECT_ID
806: AND PROJE1.OBJECT_TYPE='PA_TASKS'
807: AND PROJE1.ELEMENT_NUMBER= TEMP.SUBRO_ELEMENT_NUMBER

Line 814: ,pa_proj_elements proje1b

810: AND PROJV1.PARENT_STRUCTURE_VERSION_ID=p_wbs_version_id_to
811: ) subro_id
812: from pa_xbs_denorm_temp temp
813: ,PA_PROJ_ELEMENT_VERSIONS projv1b
814: ,pa_proj_elements proje1b
815: where proje1b.element_number= temp.sub_element_number
816: and proje1b.proj_element_id =projv1b.proj_element_id
817: and projv1b.parent_structure_version_id=temp.struct_version_id
818: and projv1b.parent_structure_version_id=p_wbs_version_id_to;

Line 2172: from pa_proj_elements

2168:
2169: -- l_prg_dummy_task_flag -- ###dummy###
2170: select link_task_flag
2171: into l_prg_dummy_task_flag
2172: from pa_proj_elements
2173: where 1=1
2174: and proj_element_id = l_prg_dummy_rollup;
2175:
2176: -- l_prg_temp_rollup

Line 2635: from pa_proj_elements ele

2631: and wvt_nodes.object_type = 'PA_TASKS'
2632: and exists -- ###dummy###
2633: (
2634: select 1
2635: from pa_proj_elements ele
2636: where link_task_flag = 'N'
2637: and ele.project_id = l_project_id
2638: and ele.proj_element_id = wvt_nodes.proj_element_id
2639: and rownum <= 1

Line 3363: from pa_proj_elements

3359:
3360: -- l_prg_dummy_task_flag -- ###dummy###
3361: select link_task_flag
3362: into l_prg_dummy_task_flag
3363: from pa_proj_elements
3364: where 1=1
3365: and proj_element_id = l_prg_dummy_rollup;
3366:
3367: -- l_prg_temp_rollup

Line 3720: from pa_proj_elements

3716: and wvt_count.object_type = 'PA_TASKS'
3717: and wvt_count.proj_element_id in -- ###dummy###
3718: (
3719: select proj_element_id
3720: from pa_proj_elements
3721: where link_task_flag = 'N'
3722: )
3723: and wvt_count.parent_structure_version_id = P_WBS_VERSION_ID
3724: and rownum = 1;

Line 3758: from pa_proj_elements

3754: and wvt_level.object_type = 'PA_TASKS'
3755: and wvt_level.proj_element_id in -- ###dummy###
3756: (
3757: select proj_element_id
3758: from pa_proj_elements
3759: where link_task_flag = 'N'
3760: )
3761: and wvt_level.parent_structure_version_id = P_WBS_VERSION_ID;
3762:

Line 3853: from pa_proj_elements

3849: and wvt_nodes.object_type = 'PA_TASKS'
3850: and wvt_nodes.proj_element_id in -- ###dummy###
3851: (
3852: select proj_element_id
3853: from pa_proj_elements
3854: where link_task_flag = 'N'
3855: )
3856: and wvt_nodes.parent_structure_version_id = P_WBS_VERSION_ID
3857: and wvt_nodes.wbs_level = l_wbs_level_id