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_TASKS

Line 151: FROM pa_tasks t1 , pa_proj_elements emt,pa_proj_element_versions ver,

147: SELECT t1.project_id , 'N', t1.project_id , nvl(t1.parent_task_id , p_elem_id ) parent_task_id ,
148: t1.task_id ,'N' ,emt.name,'Y' ,decode(nvl(t2.parent_task_id ,-1) , -1 , 'N', 'Y' ),
149: SYSDATE, SYSDATE, 1, 1,
150: 0 ,t_element_version_id, ver.display_sequence,t_element_version_id, 'WF'
151: FROM pa_tasks t1 , pa_proj_elements emt,pa_proj_element_versions ver,
152: ( select distinct parent_task_id from pa_tasks t3 where t3.project_id = p_project_id ) t2
153: where t1.project_id = p_project_id
154: and t1.task_id = t2.parent_task_id (+)
155: AND t1.task_id = emt.PROJ_ELEMENT_ID

Line 152: ( select distinct parent_task_id from pa_tasks t3 where t3.project_id = p_project_id ) t2

148: t1.task_id ,'N' ,emt.name,'Y' ,decode(nvl(t2.parent_task_id ,-1) , -1 , 'N', 'Y' ),
149: SYSDATE, SYSDATE, 1, 1,
150: 0 ,t_element_version_id, ver.display_sequence,t_element_version_id, 'WF'
151: FROM pa_tasks t1 , pa_proj_elements emt,pa_proj_element_versions ver,
152: ( select distinct parent_task_id from pa_tasks t3 where t3.project_id = p_project_id ) t2
153: where t1.project_id = p_project_id
154: and t1.task_id = t2.parent_task_id (+)
155: AND t1.task_id = emt.PROJ_ELEMENT_ID
156: AND ver.project_id =t1.project_id

Line 158: AND ver.object_type = 'PA_TASKS'

154: and t1.task_id = t2.parent_task_id (+)
155: AND t1.task_id = emt.PROJ_ELEMENT_ID
156: AND ver.project_id =t1.project_id
157: AND ver.parent_structure_version_id = t_element_version_id
158: AND ver.object_type = 'PA_TASKS'
159: AND ver.proj_element_id = t1.task_id;
160:
161:
162: null;

Line 442: and a.object_type = 'PA_TASKS'

438: -- a.proj_element_id , nvl(c.proj_element_id,p_element_version_id)
439: a.proj_element_id , nvl(c.proj_element_id,l_new_elem_id )
440: from PA_PROJ_ELEMENT_VERSIONS a , pa_object_relationships b , PA_PROJ_ELEMENT_VERSIONS c
441: where a.project_id = p_project_id
442: and a.object_type = 'PA_TASKS'
443: and a.parent_structure_version_id = l_struct_ver_id -- Bug 16507592
444: and a.element_version_id = b.object_id_to1 (+)
445: and b.object_type_From (+) = 'PA_TASKS'
446: and b.relationship_type (+) = 'S'

Line 445: and b.object_type_From (+) = 'PA_TASKS'

441: where a.project_id = p_project_id
442: and a.object_type = 'PA_TASKS'
443: and a.parent_structure_version_id = l_struct_ver_id -- Bug 16507592
444: and a.element_version_id = b.object_id_to1 (+)
445: and b.object_type_From (+) = 'PA_TASKS'
446: and b.relationship_type (+) = 'S'
447: and b.object_id_from1 = c.element_version_id (+) ;
448:
449: -- OLAP_BUG

Line 556: AND ver.object_type = 'PA_TASKS'

552: AND denorm.struct_type = 'WBS'
553: AND denorm.SUB_EMT_ID = emt.PROJ_ELEMENT_ID
554: AND ver.project_id = p_project_id
555: AND ver.parent_structure_version_id = p_element_version_id
556: AND ver.object_type = 'PA_TASKS'
557: AND ver.proj_element_id = denorm.sub_emt_id;
558:
559: INSERT INTO pji_rep_xbs_denorm
560: (SUP_PROJECT_ID, PRG_ROLLUP_FLAG, PROJECT_ID, PARENT_ELEMENT_ID,

Line 593: AND ver.object_type = 'PA_TASKS'

589: AND denorm.struct_version_id = p_element_version_id
590: AND denorm.struct_type = 'XBS'
591: AND ver.project_id = p_project_id
592: AND ver.parent_structure_version_id = p_element_version_id
593: AND ver.object_type = 'PA_TASKS'
594: AND ver.proj_element_id = denorm.sub_emt_id;
595:
596:
597:

Line 732: AND ver.object_type = 'PA_TASKS'

728: AND denorm.sub_emt_id = emt.proj_element_id
729: AND denorm.struct_version_id = structs.wbs_version_id
730: AND ver.project_id = emt.project_id
731: AND ver.parent_structure_version_id = denorm.struct_version_id
732: AND ver.object_type = 'PA_TASKS'
733: AND ver.proj_element_id = denorm.sub_emt_id;
734:
735: /*
736: ** Insert the link between structure and the top level elements

Line 781: AND ver.object_type = 'PA_TASKS'

777: AND denorm.struct_version_id = structs.wbs_version_id
778: AND denorm.struct_type = 'XBS'
779: AND ver.project_id = emt.project_id
780: AND ver.parent_structure_version_id = denorm.struct_version_id
781: AND ver.object_type = 'PA_TASKS'
782: AND ver.proj_element_id = denorm.sub_emt_id;
783:
784: /*
785: * Insert link from project to project