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.PA_PROGRESS_PVT dependencies on PA_OBJECT_RELATIONSHIPS

Line 112: from pa_object_relationships

108: CURSOR cur_reverse_tree_update IS
109: SELECT proj_element_id, object_id_to1, object_type
110: FROM
111: ( select object_id_from1, object_id_to1
112: from pa_object_relationships
113: where relationship_type ='S'
114: and object_type_from in ('PA_STRUCTURES','PA_TASKS') -- Bug 6429275
115: and object_type_to = 'PA_TASKS'
116: and p_rollup_entire_wbs='N'

Line 596: pa_object_relationships pobj,

592: ,'N' create_required
593: ,'N' update_required
594: , ppr.base_percent_complete -- 4392189 : Program Reporting Changes - Phase 2
595: FROM
596: pa_object_relationships pobj,
597: pa_proj_element_versions ppev1,
598: pa_proj_element_versions ppev2,
599: pa_progress_rollup ppr,
600: pa_proj_elements ppe,

Line 839: pa_object_relationships pobj,

835: ,'N' create_required
836: ,'N' update_required
837: , to_number(null) base_percent_complete -- 4392189 : Program Reporting Changes - Phase 2
838: FROM
839: pa_object_relationships pobj,
840: pa_proj_element_versions ppev1,
841: pa_proj_element_versions ppev2,
842: pa_proj_elements ppe,
843: pa_project_statuses pps4,

Line 1194: , pa_object_relationships obj

1190: , ppr.base_percent_complete
1191: , pps2.project_status_weight override_weight ---override progress status code
1192: , pps3.project_status_weight base_weight --base prog status
1193: FROM pa_proj_elements elem
1194: , pa_object_relationships obj
1195: , pa_progress_rollup ppr
1196: , pa_project_statuses pps2
1197: , pa_project_statuses pps3
1198: WHERE obj.object_id_from2= c_task_proj_elem_id

Line 1221: from pa_object_relationships

1217: ;
1218:
1219: CURSOR c_mass_rollup_tasks IS
1220: select distinct object_id_from1
1221: from pa_object_relationships
1222: start with object_id_to1 IN (select object_id from pa_proj_rollup_temp where process_number = l_process_number_temp)
1223: and relationship_type = 'S'
1224: connect by prior object_id_from1 = object_id_to1
1225: and relationship_type = 'S'

Line 1284: from pa_object_relationships obj

1280: -- Bug 4242787 : Added Cursor cur_tree_rollup_dates
1281: CURSOR cur_tree_rollup_dates
1282: IS
1283: select /*+ leading (ROLLUP) */ ppr.as_of_date, ver2.proj_element_id child_task_id, ver2.element_version_id child_task_ver_id
1284: from pa_object_relationships obj
1285: , pa_proj_element_versions ver
1286: , pa_progress_rollup ppr
1287: , pa_proj_rollup_temp rollup
1288: , pa_proj_element_versions ver2

Line 1322: ,pa_object_relationships por1

1318: 'WORKPLAN','N') sub_project_bac_value
1319: FROM
1320: pa_proj_element_versions ppv2
1321: ,pa_proj_elem_ver_structure ppevs2
1322: ,pa_object_relationships por1
1323: ,pa_object_relationships por2
1324: WHERE
1325: por1.object_id_from1 = c_task_version_id
1326: AND por1.object_id_to1 = por2.object_id_from1

Line 1323: ,pa_object_relationships por2

1319: FROM
1320: pa_proj_element_versions ppv2
1321: ,pa_proj_elem_ver_structure ppevs2
1322: ,pa_object_relationships por1
1323: ,pa_object_relationships por2
1324: WHERE
1325: por1.object_id_from1 = c_task_version_id
1326: AND por1.object_id_to1 = por2.object_id_from1
1327: AND por2.object_id_to1 = ppv2.element_version_id

Line 1405: FROM pa_object_relationships

1401:
1402: -- Bug 4506461 Begin
1403: CURSOR c_get_any_childs_have_subprj(c_task_version_id NUMBER) IS
1404: SELECT 'Y'
1405: FROM pa_object_relationships
1406: WHERE --relationship_type in ( 'LW', 'LF' )
1407: relationship_type = 'LW'
1408: AND object_id_from1 IN
1409: (SELECT object_id_to1

Line 1410: FROM pa_object_relationships

1406: WHERE --relationship_type in ( 'LW', 'LF' )
1407: relationship_type = 'LW'
1408: AND object_id_from1 IN
1409: (SELECT object_id_to1
1410: FROM pa_object_relationships
1411: START WITH object_id_from1 = c_task_version_id
1412: AND relationship_type = 'S'
1413: CONNECT BY PRIOR object_id_to1 = object_id_from1
1414: AND relationship_type = 'S')

Line 1547: FROM pa_object_relationships

1543:
1544: IF p_rollup_entire_wbs = 'N' THEN
1545: INSERT INTO pa_proj_rollup_temp(process_number, object_id, object_type, wbs_level)
1546: SELECT distinct l_process_number_temp, object_id_from1, 'PA_TASKS', 1
1547: FROM pa_object_relationships
1548: WHERE relationship_type = 'S'
1549: START WITH object_id_to1 = l_task_version_id
1550: AND relationship_type = 'S'
1551: CONNECT BY PRIOR object_id_from1 = object_id_to1

Line 4173: from pa_object_relationships

4169: IS
4170: SELECT proj_element_id, object_id_from1, object_id_to1, object_type
4171: FROM
4172: ( select object_id_from1, object_id_to1
4173: from pa_object_relationships
4174: where p_rollup_entire_wbs='N'
4175: AND relationship_type = 'S' -- FPM
4176: start with object_id_to1 = p_object_version_id
4177: --and relationship_type = 'S' -- Bug 3603636

Line 4187: , pa_object_relationships obj

4183: AND p_rollup_entire_wbs='N'
4184: UNION -- AMG Changes
4185: SELECT ever.proj_element_id, obj.object_id_from1 object_id_from1, ever.element_version_id object_id_to1, ever.object_type object_type
4186: FROM pa_proj_element_versions ever
4187: , pa_object_relationships obj
4188: WHERE ever.project_id = p_project_id
4189: and ever.parent_structure_version_id = p_structure_version_id
4190: -- 4490532 : changed from IS_LOWEST_TASK to is_summary_task_or_structure
4191: -- and PA_PROJ_ELEMENTS_UTILS.IS_LOWEST_TASK(ever.element_version_id) = 'N'

Line 4414: ,pa_object_relationships por1

4410: pa_proj_element_versions ppv1
4411: ,pa_proj_elem_ver_structure ppevs1
4412: ,pa_proj_element_versions ppv2
4413: ,pa_proj_elem_ver_structure ppevs2
4414: ,pa_object_relationships por1
4415: ,pa_object_relationships por2
4416: WHERE
4417: ppv2.element_version_id = por1.object_id_to1
4418: AND por1.object_id_from1 = por2.object_id_to1

Line 4415: ,pa_object_relationships por2

4411: ,pa_proj_elem_ver_structure ppevs1
4412: ,pa_proj_element_versions ppv2
4413: ,pa_proj_elem_ver_structure ppevs2
4414: ,pa_object_relationships por1
4415: ,pa_object_relationships por2
4416: WHERE
4417: ppv2.element_version_id = por1.object_id_to1
4418: AND por1.object_id_from1 = por2.object_id_to1
4419: AND por2.object_id_from1 = ppv1.element_version_id

Line 5719: pa_object_relationships obj,

5715: , ppr.Oth_etc_quantity
5716: -- 4533112 : Added base_progress_status_code
5717: , decode(ppr.base_progress_status_code, 'Y' , 'Y', 'N') base_progress_status_code
5718: FROM pa_proj_element_versions ppev,
5719: pa_object_relationships obj,
5720: pa_progress_rollup ppr,
5721: pa_project_statuses pps1,
5722: pa_project_statuses pps2,
5723: pa_project_statuses pps3,

Line 6024: pa_object_relationships obj,

6020: -- 4533112 : Added base_progress_status_code
6021: , decode(ppr.base_progress_status_code,'Y','Y','N') base_progress_status_code
6022: FROM pa_proj_element_versions ppev1,
6023: pa_proj_element_versions ppev2,
6024: pa_object_relationships obj,
6025: pa_progress_rollup ppr,
6026: pa_project_statuses pps1,
6027: pa_project_statuses pps2,
6028: pa_project_statuses pps3,

Line 6191: pa_object_relationships obj,

6187: -- 4533112 : Added base_progress_status_code
6188: , 'N' base_progress_status_code
6189: FROM pa_proj_element_versions ppev1,
6190: pa_proj_element_versions ppev2,
6191: pa_object_relationships obj,
6192: pji_fm_xbs_accum_tmp1 pfxat,
6193: pa_proj_elements ppe -- 4392189
6194: WHERE obj.object_id_from1 = c_task_ver_id
6195: AND obj.object_id_from1 = ppev1.element_version_id

Line 6505: , pa_object_relationships obj

6501: , ppr.base_percent_complete
6502: , pps2.project_status_weight override_weight ---override progress status code
6503: , pps3.project_status_weight base_weight --base prog status
6504: FROM pa_proj_elements elem
6505: , pa_object_relationships obj
6506: , pa_progress_rollup ppr
6507: , pa_project_statuses pps2
6508: , pa_project_statuses pps3
6509: WHERE obj.object_id_from2= c_task_proj_elem_id

Line 6762: ,pa_object_relationships por1

6758: 'WORKPLAN','N') sub_project_bac_value
6759: FROM
6760: pa_proj_element_versions ppv2
6761: ,pa_proj_elem_ver_structure ppevs2
6762: ,pa_object_relationships por1
6763: ,pa_object_relationships por2
6764: WHERE
6765: por1.object_id_from1 = c_task_version_id
6766: AND por1.object_id_to1 = por2.object_id_from1

Line 6763: ,pa_object_relationships por2

6759: FROM
6760: pa_proj_element_versions ppv2
6761: ,pa_proj_elem_ver_structure ppevs2
6762: ,pa_object_relationships por1
6763: ,pa_object_relationships por2
6764: WHERE
6765: por1.object_id_from1 = c_task_version_id
6766: AND por1.object_id_to1 = por2.object_id_from1
6767: AND por2.object_id_to1 = ppv2.element_version_id

Line 6895: FROM pa_object_relationships

6891:
6892: -- Bug 4506461 Begin
6893: CURSOR c_get_any_childs_have_subprj(c_task_version_id NUMBER) IS
6894: SELECT 'Y'
6895: FROM pa_object_relationships
6896: WHERE --relationship_type in ( 'LW', 'LF' )
6897: relationship_type = 'LW'
6898: AND object_id_from1 IN
6899: (SELECT object_id_to1

Line 6900: FROM pa_object_relationships

6896: WHERE --relationship_type in ( 'LW', 'LF' )
6897: relationship_type = 'LW'
6898: AND object_id_from1 IN
6899: (SELECT object_id_to1
6900: FROM pa_object_relationships
6901: START WITH object_id_from1 = c_task_version_id
6902: AND relationship_type = 'S'
6903: CONNECT BY PRIOR object_id_to1 = object_id_from1
6904: AND relationship_type = 'S')

Line 9107: from pa_object_relationships obj1

9103: CURSOR c_get_subproject IS
9104: SELECT obj2.object_id_to1 subprj_str_ver_id
9105: , obj2.object_id_to2 subprj_id
9106: , ver.proj_element_id subprj_proj_elem_id
9107: from pa_object_relationships obj1
9108: , pa_object_relationships obj2
9109: , pa_proj_element_versions ver
9110: WHERE obj1.object_id_from1 = p_object_version_id
9111: AND obj1.relationship_type = 'S'

Line 9108: , pa_object_relationships obj2

9104: SELECT obj2.object_id_to1 subprj_str_ver_id
9105: , obj2.object_id_to2 subprj_id
9106: , ver.proj_element_id subprj_proj_elem_id
9107: from pa_object_relationships obj1
9108: , pa_object_relationships obj2
9109: , pa_proj_element_versions ver
9110: WHERE obj1.object_id_from1 = p_object_version_id
9111: AND obj1.relationship_type = 'S'
9112: AND obj1.object_id_to1 = obj2.object_id_from1

Line 10319: FROM pa_object_relationships

10315: AND c.prg_group is not null --Bug 7607077
10316: AND (a.project_id = p_project_id OR a.project_id IN (
10317: -- Bottom up
10318: SELECT object_id_from2
10319: FROM pa_object_relationships
10320: START with object_id_to2 = p_project_id and relationship_type = 'LW'
10321: CONNECT BY PRIOR object_id_from2 = object_id_to2
10322: AND PRIOR relationship_type = relationship_type
10323: UNION

Line 10326: FROM pa_object_relationships

10322: AND PRIOR relationship_type = relationship_type
10323: UNION
10324: -- Top down
10325: SELECT object_id_to2
10326: FROM pa_object_relationships
10327: START with object_id_from2 = p_project_id and relationship_type = 'LW'
10328: CONNECT BY PRIOR object_id_to2 = object_id_from2
10329: AND PRIOR relationship_type = relationship_type
10330: ))

Line 10623: from pa_object_relationships

10619: CURSOR cur_reverse_tree_update IS
10620: SELECT proj_element_id, object_id_to1, object_type
10621: FROM
10622: ( select object_id_from1, object_id_to1
10623: from pa_object_relationships
10624: where relationship_type ='S'
10625: and object_type_from in ('PA_STRUCTURES','PA_TASKS') -- Bug 6429275
10626: and object_type_to = 'PA_TASKS'
10627: and p_rollup_entire_wbs='N'

Line 11107: pa_object_relationships pobj,

11103: ,'N' create_required
11104: ,'N' update_required
11105: , ppr.base_percent_complete -- 4392189 : Program Reporting Changes - Phase 2
11106: FROM
11107: pa_object_relationships pobj,
11108: pa_proj_element_versions ppev1,
11109: pa_proj_element_versions ppev2,
11110: pa_progress_rollup ppr,
11111: pa_proj_elements ppe,

Line 11350: pa_object_relationships pobj,

11346: ,'N' create_required
11347: ,'N' update_required
11348: , to_number(null) base_percent_complete -- 4392189 : Program Reporting Changes - Phase 2
11349: FROM
11350: pa_object_relationships pobj,
11351: pa_proj_element_versions ppev1,
11352: pa_proj_element_versions ppev2,
11353: pa_proj_elements ppe,
11354: pa_project_statuses pps4,

Line 11463: , pa_object_relationships obj

11459: , ppr.base_percent_complete
11460: , pps2.project_status_weight override_weight ---override progress status code
11461: , pps3.project_status_weight base_weight --base prog status
11462: FROM pa_proj_elements elem
11463: , pa_object_relationships obj
11464: , pa_progress_rollup ppr
11465: , pa_project_statuses pps2
11466: , pa_project_statuses pps3
11467: WHERE obj.object_id_from2= c_task_proj_elem_id

Line 11490: from pa_object_relationships

11486: ;
11487:
11488: CURSOR c_mass_rollup_tasks IS
11489: select distinct object_id_from1
11490: from pa_object_relationships
11491: start with object_id_to1 IN (select object_id from pa_proj_rollup_temp where process_number = l_process_number_temp)
11492: and relationship_type = 'S'
11493: connect by prior object_id_from1 = object_id_to1
11494: and relationship_type = 'S'

Line 11553: from pa_object_relationships obj

11549: -- Bug 4242787 : Added Cursor cur_tree_rollup_dates
11550: CURSOR cur_tree_rollup_dates
11551: IS
11552: select /*+ leading (ROLLUP) */ ppr.as_of_date, ver2.proj_element_id child_task_id, ver2.element_version_id child_task_ver_id
11553: from pa_object_relationships obj
11554: , pa_proj_element_versions ver
11555: , pa_progress_rollup ppr
11556: , pa_proj_rollup_temp rollup
11557: , pa_proj_element_versions ver2

Line 11591: ,pa_object_relationships por1

11587: 'WORKPLAN','N') sub_project_bac_value
11588: FROM
11589: pa_proj_element_versions ppv2
11590: ,pa_proj_elem_ver_structure ppevs2
11591: ,pa_object_relationships por1
11592: ,pa_object_relationships por2
11593: WHERE
11594: por1.object_id_from1 = c_task_version_id
11595: AND por1.object_id_to1 = por2.object_id_from1

Line 11592: ,pa_object_relationships por2

11588: FROM
11589: pa_proj_element_versions ppv2
11590: ,pa_proj_elem_ver_structure ppevs2
11591: ,pa_object_relationships por1
11592: ,pa_object_relationships por2
11593: WHERE
11594: por1.object_id_from1 = c_task_version_id
11595: AND por1.object_id_to1 = por2.object_id_from1
11596: AND por2.object_id_to1 = ppv2.element_version_id

Line 11674: FROM pa_object_relationships

11670:
11671: -- Bug 4506461 Begin
11672: CURSOR c_get_any_childs_have_subprj(c_task_version_id NUMBER) IS
11673: SELECT 'Y'
11674: FROM pa_object_relationships
11675: WHERE --relationship_type in ( 'LW', 'LF' )
11676: relationship_type = 'LW'
11677: AND object_id_from1 IN
11678: (SELECT object_id_to1

Line 11679: FROM pa_object_relationships

11675: WHERE --relationship_type in ( 'LW', 'LF' )
11676: relationship_type = 'LW'
11677: AND object_id_from1 IN
11678: (SELECT object_id_to1
11679: FROM pa_object_relationships
11680: START WITH object_id_from1 = c_task_version_id
11681: AND relationship_type = 'S'
11682: CONNECT BY PRIOR object_id_to1 = object_id_from1
11683: AND relationship_type = 'S')

Line 11705: FROM pa_object_relationships

11701:
11702: cursor c_progress_parent(c_project_id number)
11703: IS
11704: SELECT object_id_from1
11705: FROM pa_object_relationships
11706: WHERE relationship_type = 'S'
11707: START WITH object_id_to1 in (select p.element_version_id
11708: from PA_PROJ_ELEMENT_VERSIONS p where p.project_id = c_project_id and defer_code in ( 'P','S'))
11709: AND relationship_type = 'S'

Line 11851: FROM pa_object_relationships

11847:
11848: IF p_rollup_entire_wbs = 'N' THEN
11849: INSERT INTO pa_proj_rollup_temp(process_number, object_id, object_type, wbs_level)
11850: SELECT distinct l_process_number_temp, object_id_from1, 'PA_TASKS', 1
11851: FROM pa_object_relationships
11852: WHERE relationship_type = 'S'
11853: START WITH object_id_to1 = l_task_version_id
11854: AND relationship_type = 'S'
11855: CONNECT BY PRIOR object_id_from1 = object_id_to1

Line 14183: from pa_object_relationships

14179: CURSOR cur_reverse_tree_update IS
14180: SELECT proj_element_id, object_id_to1, object_type
14181: FROM
14182: ( select object_id_from1, object_id_to1
14183: from pa_object_relationships
14184: where relationship_type ='S'
14185: and object_type_from in ('PA_STRUCTURES','PA_TASKS') -- Bug 6429275
14186: and object_type_to = 'PA_TASKS'
14187: and p_rollup_entire_wbs='N'

Line 14667: pa_object_relationships pobj,

14663: ,'N' create_required
14664: ,'N' update_required
14665: , ppr.base_percent_complete -- 4392189 : Program Reporting Changes - Phase 2
14666: FROM
14667: pa_object_relationships pobj,
14668: pa_proj_element_versions ppev1,
14669: pa_proj_element_versions ppev2,
14670: pa_progress_rollup ppr,
14671: pa_proj_elements ppe,

Line 14910: pa_object_relationships pobj,

14906: ,'N' create_required
14907: ,'N' update_required
14908: , to_number(null) base_percent_complete -- 4392189 : Program Reporting Changes - Phase 2
14909: FROM
14910: pa_object_relationships pobj,
14911: pa_proj_element_versions ppev1,
14912: pa_proj_element_versions ppev2,
14913: pa_proj_elements ppe,
14914: pa_project_statuses pps4,

Line 15024: , pa_object_relationships obj

15020: , ppr.base_percent_complete
15021: , pps2.project_status_weight override_weight ---override progress status code
15022: , pps3.project_status_weight base_weight --base prog status
15023: FROM pa_proj_elements elem
15024: , pa_object_relationships obj
15025: , pa_progress_rollup ppr
15026: , pa_project_statuses pps2
15027: , pa_project_statuses pps3
15028: WHERE obj.object_id_from2= c_task_proj_elem_id

Line 15051: from pa_object_relationships

15047: ;
15048:
15049: CURSOR c_mass_rollup_tasks IS
15050: select distinct object_id_from1
15051: from pa_object_relationships
15052: start with object_id_to1 IN (select object_id from pa_proj_rollup_temp where process_number = l_process_number_temp)
15053: and relationship_type = 'S'
15054: connect by prior object_id_from1 = object_id_to1
15055: and relationship_type = 'S'

Line 15114: from pa_object_relationships obj

15110: -- Bug 4242787 : Added Cursor cur_tree_rollup_dates
15111: CURSOR cur_tree_rollup_dates
15112: IS
15113: select /*+ leading (ROLLUP) */ ppr.as_of_date, ver2.proj_element_id child_task_id, ver2.element_version_id child_task_ver_id
15114: from pa_object_relationships obj
15115: , pa_proj_element_versions ver
15116: , pa_progress_rollup ppr
15117: , pa_proj_rollup_temp rollup
15118: , pa_proj_element_versions ver2

Line 15152: ,pa_object_relationships por1

15148: 'WORKPLAN','N') sub_project_bac_value
15149: FROM
15150: pa_proj_element_versions ppv2
15151: ,pa_proj_elem_ver_structure ppevs2
15152: ,pa_object_relationships por1
15153: ,pa_object_relationships por2
15154: WHERE
15155: por1.object_id_from1 = c_task_version_id
15156: AND por1.object_id_to1 = por2.object_id_from1

Line 15153: ,pa_object_relationships por2

15149: FROM
15150: pa_proj_element_versions ppv2
15151: ,pa_proj_elem_ver_structure ppevs2
15152: ,pa_object_relationships por1
15153: ,pa_object_relationships por2
15154: WHERE
15155: por1.object_id_from1 = c_task_version_id
15156: AND por1.object_id_to1 = por2.object_id_from1
15157: AND por2.object_id_to1 = ppv2.element_version_id

Line 15236: FROM pa_object_relationships

15232:
15233: -- Bug 4506461 Begin
15234: CURSOR c_get_any_childs_have_subprj(c_task_version_id NUMBER) IS
15235: SELECT 'Y'
15236: FROM pa_object_relationships
15237: WHERE --relationship_type in ( 'LW', 'LF' )
15238: relationship_type = 'LW'
15239: AND object_id_from1 IN
15240: (SELECT object_id_to1

Line 15241: FROM pa_object_relationships

15237: WHERE --relationship_type in ( 'LW', 'LF' )
15238: relationship_type = 'LW'
15239: AND object_id_from1 IN
15240: (SELECT object_id_to1
15241: FROM pa_object_relationships
15242: START WITH object_id_from1 = c_task_version_id
15243: AND relationship_type = 'S'
15244: CONNECT BY PRIOR object_id_to1 = object_id_from1
15245: AND relationship_type = 'S')

Line 15268: FROM pa_object_relationships

15264: /*
15265: cursor c_progress_parent(c_project_id number)
15266: IS
15267: SELECT object_id_from1
15268: FROM pa_object_relationships
15269: WHERE relationship_type = 'S'
15270: START WITH object_id_to1 in (select p.element_version_id
15271: from PA_PROJ_ELEMENT_VERSIONS p where p.project_id = c_project_id and defer_code in ( 'P','S'))
15272: AND relationship_type = 'S'