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.

[Home] [Help]

APPS.PJI_LAUNCH_UPP_MAIN dependencies on PA_PROJ_ELEMENT_VERSIONS

Line 896: from pa_proj_element_versions ver

892: pragma autonomous_transaction;
893:
894: Cursor c_program_count is
895: select prg_group, count(distinct project_id) cnt, 'ALL' prg_type
896: from pa_proj_element_versions ver
897: where g_launch_type = 'UPPD' and -- sridhar_phase_1 p_wbs_temp_table_size <> 666666 and -- sridhar refresh
898: nvl(p_incremental_mode,'N') = 'N'
899: and object_type = 'PA_STRUCTURES'
900: and prg_group is not null

Line 907: select /+ ordered index(ver PA_PROJ_ELEMENT_VERSIONS_N5) /

903: where p1.project_id = ver.project_id
904: and nvl(p1.org_id,-1) = nvl(P_OPERATING_UNIT,nvl(p1.org_id,-1)))
905: group by prg_group
906: union all
907: select /*+ ordered index(ver PA_PROJ_ELEMENT_VERSIONS_N5) */
908: ver.PRG_GROUP , count( distinct ver.project_id ) cnt, 'PRG_CHANGE' prg_type
909: from
910: PJI_LAUNCH_INCR grp ,
911: PA_PROJ_ELEMENT_VERSIONS ver

Line 911: PA_PROJ_ELEMENT_VERSIONS ver

907: select /*+ ordered index(ver PA_PROJ_ELEMENT_VERSIONS_N5) */
908: ver.PRG_GROUP , count( distinct ver.project_id ) cnt, 'PRG_CHANGE' prg_type
909: from
910: PJI_LAUNCH_INCR grp ,
911: PA_PROJ_ELEMENT_VERSIONS ver
912: where ( nvl(p_incremental_mode,'N') = 'Y' or g_launch_type = 'RPPD' ) and -- sridhar_phase_1 p_wbs_temp_table_size = 666666 ) and -- sridhar refresh and
913: ver.object_type = 'PA_STRUCTURES' and
914: grp.incr_type in ( 'PRG_BASE', 'REFRESH') and
915: ver.prg_group = grp.prg_group

Line 928: from pa_proj_element_versions

924: group by grp.prg_group;
925:
926: cursor c_program(x_prg_group number, x_prg_type varchar2 ) is
927: select prg_group, prg_level, project_id
928: from pa_proj_element_versions
929: where x_prg_type <> 'PRG_PARENT'
930: and object_type = 'PA_STRUCTURES'
931: and prg_group IS NOT NULL
932: and prg_group = x_prg_group

Line 1064: from pa_proj_element_versions A

1060: end;
1061:
1062: select count(*)
1063: into l_wbs_count
1064: from pa_proj_element_versions A
1065: where l_prg_event_exists = 'Y' and
1066: a.parent_structure_version_id in
1067: ( select B.element_version_id
1068: from pa_proj_element_versions B

Line 1068: from pa_proj_element_versions B

1064: from pa_proj_element_versions A
1065: where l_prg_event_exists = 'Y' and
1066: a.parent_structure_version_id in
1067: ( select B.element_version_id
1068: from pa_proj_element_versions B
1069: where B.prg_group = i.prg_group
1070: and B.object_type = 'PA_STRUCTURES'
1071: )
1072: and A.object_type = 'PA_TASKS';

Line 1090: PA_PROJ_ELEMENT_VERSIONS ver ,

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
1094: and PRG_NODE.prg_group = i.prg_group

Line 1091: PA_PROJ_ELEMENT_VERSIONS pvt_parent1 ,

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
1094: and PRG_NODE.prg_group = i.prg_group
1095: and prt_parent.object_id_to1 = PRG_NODE.element_version_id

Line 1092: pa_proj_element_versions PRG_NODE

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
1094: and PRG_NODE.prg_group = i.prg_group
1095: and prt_parent.object_id_to1 = PRG_NODE.element_version_id
1096: and PRG_NODE.object_type = 'PA_STRUCTURES'

Line 1110: from pa_proj_element_versions a

1106: )
1107: where l_prg_event_exists = 'Y' ) lw_lf,
1108: (
1109: select count(*) pa_struct_count
1110: from pa_proj_element_versions a
1111: where l_prg_event_exists = 'Y'
1112: and a.prg_group = i.prg_group
1113: and a.object_type = 'PA_STRUCTURES'
1114: ) pa_struct ;

Line 1892: from pa_proj_element_versions e

1888: AND rbs_version_id = -1 AND time_id = -1
1889: AND rbs_aggr_level = 'T' AND wbs_rollup_flag = 'Y' AND prg_rollup_flag = 'N'
1890: AND bitand(curr_record_type_id,4) = 4
1891: AND project_element_id = (SELECT proj_element_id
1892: from pa_proj_element_versions e
1893: where e.project_id = f.project_id
1894: and element_version_id =
1895: PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_WP_VERSION(f.project_id))
1896: GROUP BY project_id) rep,

Line 2162: from pa_proj_element_versions c

2158: SET a.INCR_TYPE = 'PROJ_WRK'
2159: WHERE
2160: exists
2161: ( select 'x'
2162: from pa_proj_element_versions c
2163: where a.project_id = c.project_id
2164: and c.object_type = 'PA_STRUCTURES'
2165: AND c.prg_group IS NOT NULL ) ;
2166:

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 2179: pa_proj_element_versions a,

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,
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

Line 2181: pa_proj_element_versions c

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
2185: AND a.object_type = 'PA_STRUCTURES'

Line 2327: SELECT /+ ordered use_nl(log ver ) index(ver PA_PROJ_ELEMENT_VERSIONS_N5) /

2323: -- INSERT 001
2324: --
2325: INSERT INTO PJI_LAUNCH_INCR
2326: (incr_type, prg_group , project_id, prg_level )
2327: SELECT /*+ ordered use_nl(log ver ) index(ver PA_PROJ_ELEMENT_VERSIONS_N5) */
2328: DISTINCT
2329: 'PRG_BASE' incr_type ,
2330: ver.PRG_GROUP ,
2331: - 1 project_id ,

Line 2335: PA_PROJ_ELEMENT_VERSIONS ver

2331: - 1 project_id ,
2332: -1 prg_level
2333: FROM
2334: PA_PJI_PROJ_EVENTS_LOG LOG ,
2335: PA_PROJ_ELEMENT_VERSIONS ver
2336: WHERE
2337: ver.object_type = 'PA_STRUCTURES' AND
2338: log.EVENT_TYPE = 'PRG_CHANGE' AND
2339: log.EVENT_OBJECT <> - 1 AND

Line 2585: (SELECT /+ ordered index(c PA_PROJ_ELEMENT_VERSIONS_N6) / 'x'

2581: UPDATE PJI_LAUNCH_INCR a
2582: SET a.INCR_TYPE = 'PROJ_PRG'
2583: WHERE a.INCR_TYPE = 'PROJ_BASE'
2584: AND EXISTS
2585: (SELECT /*+ ordered index(c PA_PROJ_ELEMENT_VERSIONS_N6) */ 'x'
2586: FROM
2587: pa_proj_element_versions c,
2588: PJI_LAUNCH_INCR b
2589: WHERE a.project_id = c.project_id

Line 2587: pa_proj_element_versions c,

2583: WHERE a.INCR_TYPE = 'PROJ_BASE'
2584: AND EXISTS
2585: (SELECT /*+ ordered index(c PA_PROJ_ELEMENT_VERSIONS_N6) */ 'x'
2586: FROM
2587: pa_proj_element_versions c,
2588: PJI_LAUNCH_INCR b
2589: WHERE a.project_id = c.project_id
2590: and c.object_type = 'PA_STRUCTURES'
2591: AND c.prg_group IS NOT NULL

Line 2611: from pa_proj_element_versions c

2607: SET a.INCR_TYPE = 'PROJ_WRK'
2608: WHERE a.INCR_TYPE = 'PROJ_BASE' and
2609: exists
2610: ( select 'x'
2611: from pa_proj_element_versions c
2612: where a.project_id = c.project_id
2613: and c.object_type = 'PA_STRUCTURES'
2614: AND c.prg_group IS NOT NULL ) ;
2615:

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 2630: pa_proj_element_versions a,

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,
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

Line 2632: pa_proj_element_versions c

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
2636: AND a.object_type = 'PA_STRUCTURES'

Line 2694: SELECT /+ ordered index(ver PA_PROJ_ELEMENT_VERSIONS_N6) /

2690: --
2691: --
2692: INSERT INTO PJI_LAUNCH_INCR
2693: (incr_type, prg_group , project_id ,prg_level)
2694: SELECT /*+ ordered index(ver PA_PROJ_ELEMENT_VERSIONS_N6) */
2695: DISTINCT
2696: 'PROJ_BASE_MAP' incr_type ,
2697: nvl(ver.PRG_GROUP,-1) ,
2698: map1.project_id project_id ,

Line 2702: PA_PROJ_ELEMENT_VERSIONS ver

2698: map1.project_id project_id ,
2699: nvl(ver.prg_level,-1)
2700: FROM
2701: PJI_PJP_PROJ_BATCH_MAP map1 ,
2702: PA_PROJ_ELEMENT_VERSIONS ver
2703: WHERE
2704: ver.object_type = 'PA_STRUCTURES' AND
2705: ver.project_id = map1.project_id ;
2706: --AND

Line 2739: -- SELECT /+ ordered index(ver PA_PROJ_ELEMENT_VERSIONS_N3) /

2735: -- INSERT 009
2736: --
2737: -- INSERT INTO PJI_LAUNCH_INCR
2738: -- (incr_type, prg_group , project_id )
2739: -- SELECT /*+ ordered index(ver PA_PROJ_ELEMENT_VERSIONS_N3) */
2740: -- DISTINCT
2741: -- 'PRG_BASE' incr_type ,
2742: -- ver.PRG_GROUP ,
2743: -- - 1 project_id

Line 2746: -- PA_PROJ_ELEMENT_VERSIONS ver

2742: -- ver.PRG_GROUP ,
2743: -- - 1 project_id
2744: -- FROM
2745: -- PJI_LAUNCH_INCR grp ,
2746: -- PA_PROJ_ELEMENT_VERSIONS ver
2747: -- WHERE
2748: -- ver.object_type = 'PA_STRUCTURES' AND
2749: -- grp.incr_type = 'PROJ_BASE' AND
2750: -- grp.prg_group = - 1 AND