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_LAUNCH_UPP_MAIN dependencies on PA_OBJECT_RELATIONSHIPS

Line 1089: from PA_OBJECT_RELATIONSHIPS prt_parent,

1085: pvt_parent1.proj_element_id ,
1086: prt_parent.object_id_from1,
1087: prt_parent.relationship_type,
1088: ver.prg_level
1089: from PA_OBJECT_RELATIONSHIPS prt_parent,
1090: PA_PROJ_ELEMENT_VERSIONS ver ,
1091: PA_PROJ_ELEMENT_VERSIONS pvt_parent1 ,
1092: pa_proj_element_versions PRG_NODE
1093: where 1=1

Line 2174: SELECT /+ ordered index(a PA_PROJ_ELEMENT_VERSIONS_N6) index(b PA_OBJECT_RELATIONSHIPS_N4) /

2170: l_prg_parent := 0;
2171:
2172: FOR PRG_PARENT_NODE IN
2173: (
2174: SELECT /*+ ordered index(a PA_PROJ_ELEMENT_VERSIONS_N6) index(b PA_OBJECT_RELATIONSHIPS_N4) */
2175: DISTINCT
2176: a0.project_id child_proj_id , a.prg_level child_prg_level,
2177: c.project_id parent_proj_id , c.prg_group , c.prg_level parent_prg_level
2178: FROM pji_launch_incr a0,

Line 2180: pa_object_relationships b,

2176: a0.project_id child_proj_id , a.prg_level child_prg_level,
2177: c.project_id parent_proj_id , c.prg_group , c.prg_level parent_prg_level
2178: FROM pji_launch_incr a0,
2179: pa_proj_element_versions a,
2180: pa_object_relationships b,
2181: pa_proj_element_versions c
2182: WHERE a0.incr_type in ( 'PROJ_WRK', 'PROJ_WRK_NEW' )
2183: AND a.project_id = a0.project_id --51956 --5062 --5269 --51954
2184: AND a.prg_group IS NOT NULL

Line 2625: SELECT /+ ordered index(a PA_PROJ_ELEMENT_VERSIONS_N6) index(b PA_OBJECT_RELATIONSHIPS_N4) /

2621: l_prg_parent := 0;
2622:
2623: FOR PRG_PARENT_NODE IN
2624: (
2625: SELECT /*+ ordered index(a PA_PROJ_ELEMENT_VERSIONS_N6) index(b PA_OBJECT_RELATIONSHIPS_N4) */
2626: DISTINCT
2627: a0.project_id child_proj_id , a.prg_level child_prg_level,
2628: c.project_id parent_proj_id , c.prg_group , c.prg_level parent_prg_level
2629: FROM pji_launch_incr a0,

Line 2631: pa_object_relationships b,

2627: a0.project_id child_proj_id , a.prg_level child_prg_level,
2628: c.project_id parent_proj_id , c.prg_group , c.prg_level parent_prg_level
2629: FROM pji_launch_incr a0,
2630: pa_proj_element_versions a,
2631: pa_object_relationships b,
2632: pa_proj_element_versions c
2633: WHERE a0.incr_type in ( 'PROJ_WRK', 'PROJ_WRK_NEW' )
2634: AND a.project_id = a0.project_id --51956 --5062 --5269 --51954
2635: AND a.prg_group IS NOT NULL