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 111: from pa_object_relationships

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

Line 594: pa_object_relationships pobj,

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

Line 835: pa_object_relationships pobj,

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

Line 1189: , pa_object_relationships obj

1185: , ppr.base_percent_complete
1186: , pps2.project_status_weight override_weight ---override progress status code
1187: , pps3.project_status_weight base_weight --base prog status
1188: FROM pa_proj_elements elem
1189: , pa_object_relationships obj
1190: , pa_progress_rollup ppr
1191: , pa_project_statuses pps2
1192: , pa_project_statuses pps3
1193: WHERE obj.object_id_from2= c_task_proj_elem_id

Line 1216: from pa_object_relationships

1212: ;
1213:
1214: CURSOR c_mass_rollup_tasks IS
1215: select distinct object_id_from1
1216: from pa_object_relationships
1217: start with object_id_to1 IN (select object_id from pa_proj_rollup_temp where process_number = l_process_number_temp)
1218: and relationship_type = 'S'
1219: connect by prior object_id_from1 = object_id_to1
1220: and relationship_type = 'S'

Line 1279: from pa_object_relationships obj

1275: -- Bug 4242787 : Added Cursor cur_tree_rollup_dates
1276: CURSOR cur_tree_rollup_dates
1277: IS
1278: select ppr.as_of_date, ver2.proj_element_id child_task_id, ver2.element_version_id child_task_ver_id
1279: from pa_object_relationships obj
1280: , pa_proj_element_versions ver
1281: , pa_progress_rollup ppr
1282: , pa_proj_rollup_temp rollup
1283: , pa_proj_element_versions ver2

Line 1316: ,pa_object_relationships por1

1312: 'WORKPLAN','N') sub_project_bac_value
1313: FROM
1314: pa_proj_element_versions ppv2
1315: ,pa_proj_elem_ver_structure ppevs2
1316: ,pa_object_relationships por1
1317: ,pa_object_relationships por2
1318: WHERE
1319: por1.object_id_from1 = c_task_version_id
1320: AND por1.object_id_to1 = por2.object_id_from1

Line 1317: ,pa_object_relationships por2

1313: FROM
1314: pa_proj_element_versions ppv2
1315: ,pa_proj_elem_ver_structure ppevs2
1316: ,pa_object_relationships por1
1317: ,pa_object_relationships por2
1318: WHERE
1319: por1.object_id_from1 = c_task_version_id
1320: AND por1.object_id_to1 = por2.object_id_from1
1321: AND por2.object_id_to1 = ppv2.element_version_id

Line 1398: FROM pa_object_relationships

1394:
1395: -- Bug 4506461 Begin
1396: CURSOR c_get_any_childs_have_subprj(c_task_version_id NUMBER) IS
1397: SELECT 'Y'
1398: FROM pa_object_relationships
1399: WHERE --relationship_type in ( 'LW', 'LF' )
1400: relationship_type = 'LW'
1401: AND object_id_from1 IN
1402: (SELECT object_id_to1

Line 1403: FROM pa_object_relationships

1399: WHERE --relationship_type in ( 'LW', 'LF' )
1400: relationship_type = 'LW'
1401: AND object_id_from1 IN
1402: (SELECT object_id_to1
1403: FROM pa_object_relationships
1404: START WITH object_id_from1 = c_task_version_id
1405: AND relationship_type = 'S'
1406: CONNECT BY PRIOR object_id_to1 = object_id_from1
1407: AND relationship_type = 'S')

Line 1538: FROM pa_object_relationships

1534:
1535: IF p_rollup_entire_wbs = 'N' THEN
1536: INSERT INTO pa_proj_rollup_temp(process_number, object_id, object_type, wbs_level)
1537: SELECT distinct l_process_number_temp, object_id_from1, 'PA_TASKS', 1
1538: FROM pa_object_relationships
1539: WHERE relationship_type = 'S'
1540: START WITH object_id_to1 = l_task_version_id
1541: AND relationship_type = 'S'
1542: CONNECT BY PRIOR object_id_from1 = object_id_to1

Line 4130: from pa_object_relationships

4126: IS
4127: SELECT proj_element_id, object_id_from1, object_id_to1, object_type
4128: FROM
4129: ( select object_id_from1, object_id_to1
4130: from pa_object_relationships
4131: where p_rollup_entire_wbs='N'
4132: AND relationship_type = 'S' -- FPM
4133: start with object_id_to1 = p_object_version_id
4134: --and relationship_type = 'S' -- Bug 3603636

Line 4144: , pa_object_relationships obj

4140: AND p_rollup_entire_wbs='N'
4141: UNION -- AMG Changes
4142: SELECT ever.proj_element_id, obj.object_id_from1 object_id_from1, ever.element_version_id object_id_to1, ever.object_type object_type
4143: FROM pa_proj_element_versions ever
4144: , pa_object_relationships obj
4145: WHERE ever.project_id = p_project_id
4146: and ever.parent_structure_version_id = p_structure_version_id
4147: -- 4490532 : changed from IS_LOWEST_TASK to is_summary_task_or_structure
4148: -- and PA_PROJ_ELEMENTS_UTILS.IS_LOWEST_TASK(ever.element_version_id) = 'N'

Line 4371: ,pa_object_relationships por1

4367: pa_proj_element_versions ppv1
4368: ,pa_proj_elem_ver_structure ppevs1
4369: ,pa_proj_element_versions ppv2
4370: ,pa_proj_elem_ver_structure ppevs2
4371: ,pa_object_relationships por1
4372: ,pa_object_relationships por2
4373: WHERE
4374: ppv2.element_version_id = por1.object_id_to1
4375: AND por1.object_id_from1 = por2.object_id_to1

Line 4372: ,pa_object_relationships por2

4368: ,pa_proj_elem_ver_structure ppevs1
4369: ,pa_proj_element_versions ppv2
4370: ,pa_proj_elem_ver_structure ppevs2
4371: ,pa_object_relationships por1
4372: ,pa_object_relationships por2
4373: WHERE
4374: ppv2.element_version_id = por1.object_id_to1
4375: AND por1.object_id_from1 = por2.object_id_to1
4376: AND por2.object_id_from1 = ppv1.element_version_id

Line 5653: pa_object_relationships obj,

5649: , ppr.Oth_etc_quantity
5650: -- 4533112 : Added base_progress_status_code
5651: , decode(ppr.base_progress_status_code, 'Y' , 'Y', 'N') base_progress_status_code
5652: FROM pa_proj_element_versions ppev,
5653: pa_object_relationships obj,
5654: pa_progress_rollup ppr,
5655: pa_project_statuses pps1,
5656: pa_project_statuses pps2,
5657: pa_project_statuses pps3,

Line 5958: pa_object_relationships obj,

5954: -- 4533112 : Added base_progress_status_code
5955: , decode(ppr.base_progress_status_code,'Y','Y','N') base_progress_status_code
5956: FROM pa_proj_element_versions ppev1,
5957: pa_proj_element_versions ppev2,
5958: pa_object_relationships obj,
5959: pa_progress_rollup ppr,
5960: pa_project_statuses pps1,
5961: pa_project_statuses pps2,
5962: pa_project_statuses pps3,

Line 6125: pa_object_relationships obj,

6121: -- 4533112 : Added base_progress_status_code
6122: , 'N' base_progress_status_code
6123: FROM pa_proj_element_versions ppev1,
6124: pa_proj_element_versions ppev2,
6125: pa_object_relationships obj,
6126: pji_fm_xbs_accum_tmp1 pfxat,
6127: pa_proj_elements ppe -- 4392189
6128: WHERE obj.object_id_from1 = c_task_ver_id
6129: AND obj.object_id_from1 = ppev1.element_version_id

Line 6439: , pa_object_relationships obj

6435: , ppr.base_percent_complete
6436: , pps2.project_status_weight override_weight ---override progress status code
6437: , pps3.project_status_weight base_weight --base prog status
6438: FROM pa_proj_elements elem
6439: , pa_object_relationships obj
6440: , pa_progress_rollup ppr
6441: , pa_project_statuses pps2
6442: , pa_project_statuses pps3
6443: WHERE obj.object_id_from2= c_task_proj_elem_id

Line 6696: ,pa_object_relationships por1

6692: 'WORKPLAN','N') sub_project_bac_value
6693: FROM
6694: pa_proj_element_versions ppv2
6695: ,pa_proj_elem_ver_structure ppevs2
6696: ,pa_object_relationships por1
6697: ,pa_object_relationships por2
6698: WHERE
6699: por1.object_id_from1 = c_task_version_id
6700: AND por1.object_id_to1 = por2.object_id_from1

Line 6697: ,pa_object_relationships por2

6693: FROM
6694: pa_proj_element_versions ppv2
6695: ,pa_proj_elem_ver_structure ppevs2
6696: ,pa_object_relationships por1
6697: ,pa_object_relationships por2
6698: WHERE
6699: por1.object_id_from1 = c_task_version_id
6700: AND por1.object_id_to1 = por2.object_id_from1
6701: AND por2.object_id_to1 = ppv2.element_version_id

Line 6829: FROM pa_object_relationships

6825:
6826: -- Bug 4506461 Begin
6827: CURSOR c_get_any_childs_have_subprj(c_task_version_id NUMBER) IS
6828: SELECT 'Y'
6829: FROM pa_object_relationships
6830: WHERE --relationship_type in ( 'LW', 'LF' )
6831: relationship_type = 'LW'
6832: AND object_id_from1 IN
6833: (SELECT object_id_to1

Line 6834: FROM pa_object_relationships

6830: WHERE --relationship_type in ( 'LW', 'LF' )
6831: relationship_type = 'LW'
6832: AND object_id_from1 IN
6833: (SELECT object_id_to1
6834: FROM pa_object_relationships
6835: START WITH object_id_from1 = c_task_version_id
6836: AND relationship_type = 'S'
6837: CONNECT BY PRIOR object_id_to1 = object_id_from1
6838: AND relationship_type = 'S')

Line 9041: from pa_object_relationships obj1

9037: CURSOR c_get_subproject IS
9038: SELECT obj2.object_id_to1 subprj_str_ver_id
9039: , obj2.object_id_to2 subprj_id
9040: , ver.proj_element_id subprj_proj_elem_id
9041: from pa_object_relationships obj1
9042: , pa_object_relationships obj2
9043: , pa_proj_element_versions ver
9044: WHERE obj1.object_id_from1 = p_object_version_id
9045: AND obj1.relationship_type = 'S'

Line 9042: , pa_object_relationships obj2

9038: SELECT obj2.object_id_to1 subprj_str_ver_id
9039: , obj2.object_id_to2 subprj_id
9040: , ver.proj_element_id subprj_proj_elem_id
9041: from pa_object_relationships obj1
9042: , pa_object_relationships obj2
9043: , pa_proj_element_versions ver
9044: WHERE obj1.object_id_from1 = p_object_version_id
9045: AND obj1.relationship_type = 'S'
9046: AND obj1.object_id_to1 = obj2.object_id_from1