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_XBS_DENORM_TEMP

Line 668: from pa_xbs_denorm_temp temp

664: ,projv1s.element_version_id sup_id,projv1s.parent_structure_version_id struct_version_id
665: ,temp.sub_leaf_flag, temp.sup_level, temp.sub_level,temp.relationship_type
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

Line 695: insert into PA_XBS_DENORM_temp

691: sub_element_numbertab SYSTEM.PA_VARCHAR2_100_TBL_TYPE := SYSTEM.PA_VARCHAR2_100_TBL_TYPE();
692: subro_element_numbertab SYSTEM.PA_VARCHAR2_100_TBL_TYPE := SYSTEM.PA_VARCHAR2_100_TBL_TYPE();
693:
694: begin
695: insert into PA_XBS_DENORM_temp
696: (
697: struct_type, prg_group, sup_project_id,
698: sup_emt_id, sup_id, struct_version_id,
699: sub_leaf_flag, sup_level, sub_level,

Line 746: delete from pa_xbs_denorm_temp;

742: subro_idtab,
743: sub_element_numbertab,
744: subro_element_numbertab;
745:
746: delete from pa_xbs_denorm_temp;
747: IF struct_typetab.COUNT <>0 then
748: FORALL i IN struct_typetab.FIRST..struct_typetab.LAST
749: insert into PA_XBS_DENORM_temp
750: (

Line 749: insert into PA_XBS_DENORM_temp

745:
746: delete from pa_xbs_denorm_temp;
747: IF struct_typetab.COUNT <>0 then
748: FORALL i IN struct_typetab.FIRST..struct_typetab.LAST
749: insert into PA_XBS_DENORM_temp
750: (
751: struct_type
752: ,prg_group
753: ,sup_project_id

Line 812: from pa_xbs_denorm_temp temp

808: AND PROJE1.PROJ_ELEMENT_ID= PROJV1.PROJ_ELEMENT_ID
809: AND PROJV1.PARENT_STRUCTURE_VERSION_ID= TEMP.STRUCT_VERSION_ID
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