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 2232: from pa_proj_elements

2228:
2229: -- l_prg_dummy_task_flag -- ###dummy###
2230: select link_task_flag
2231: into l_prg_dummy_task_flag
2232: from pa_proj_elements
2233: where 1=1
2234: and proj_element_id = l_prg_dummy_rollup;
2235:
2236: -- l_prg_temp_rollup

Line 2695: from pa_proj_elements ele

2691: and wvt_nodes.object_type = 'PA_TASKS'
2692: and exists -- ###dummy###
2693: (
2694: select 1
2695: from pa_proj_elements ele
2696: where link_task_flag = 'N'
2697: and ele.project_id = l_project_id
2698: and ele.proj_element_id = wvt_nodes.proj_element_id
2699: and rownum <= 1

Line 3428: from pa_proj_elements

3424:
3425: -- l_prg_dummy_task_flag -- ###dummy###
3426: select link_task_flag
3427: into l_prg_dummy_task_flag
3428: from pa_proj_elements
3429: where 1=1
3430: and proj_element_id = l_prg_dummy_rollup;
3431:
3432: -- l_prg_temp_rollup

Line 3785: from pa_proj_elements

3781: and wvt_count.object_type = 'PA_TASKS'
3782: and wvt_count.proj_element_id in -- ###dummy###
3783: (
3784: select proj_element_id
3785: from pa_proj_elements
3786: where link_task_flag = 'N'
3787: )
3788: and wvt_count.parent_structure_version_id = P_WBS_VERSION_ID
3789: and rownum = 1;

Line 3823: from pa_proj_elements

3819: and wvt_level.object_type = 'PA_TASKS'
3820: and wvt_level.proj_element_id in -- ###dummy###
3821: (
3822: select proj_element_id
3823: from pa_proj_elements
3824: where link_task_flag = 'N'
3825: )
3826: and wvt_level.parent_structure_version_id = P_WBS_VERSION_ID;
3827:

Line 3918: from pa_proj_elements

3914: and wvt_nodes.object_type = 'PA_TASKS'
3915: and wvt_nodes.proj_element_id in -- ###dummy###
3916: (
3917: select proj_element_id
3918: from pa_proj_elements
3919: where link_task_flag = 'N'
3920: )
3921: and wvt_nodes.parent_structure_version_id = P_WBS_VERSION_ID
3922: and wvt_nodes.wbs_level = l_wbs_level_id