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_PROJ_STRUCTURE_PUB dependencies on PA_PROGRESS_ROLLUP

Line 1517: ,pa_progress_rollup ppru

1513: ,pa_work_types_tl pwt
1514: ,pa_task_types tt
1515: ,pa_project_statuses pps3
1516: ,pa_page_layouts ppl
1517: ,pa_progress_rollup ppru
1518: -----,pa_percent_completes ppc
1519: ,pa_project_statuses pps
1520: ,pa_project_statuses pps5
1521: ,pa_proj_elements ppe5

Line 1576: from pa_progress_rollup ppr2

1572: -- Begin fix for Bug # 4499065.
1573: AND ppru.current_flag (+) <> 'W' -----= 'Y' (changed to <> 'W' condition)
1574: AND ppru.object_version_id(+) = ppv.element_version_id
1575: AND nvl(ppru.as_of_date, trunc(sysdate)) = (select nvl(max(ppr2.as_of_date),trunc(sysdate))
1576: from pa_progress_rollup ppr2
1577: where
1578: ppr2.object_id = ppv.proj_element_id
1579: and ppr2.proj_element_id = ppv.proj_element_id
1580: and ppr2.object_version_id = ppv.element_version_id

Line 2332: ,pa_progress_rollup ppru

2328: ,pa_work_types_tl pwt
2329: ,pa_task_types tt
2330: ,pa_project_statuses pps3
2331: ,pa_page_layouts ppl
2332: ,pa_progress_rollup ppru
2333: -----,pa_percent_completes ppc Bug 5580992
2334: ,pa_project_statuses pps
2335: ,pa_project_statuses pps5
2336: ,pa_proj_elements ppe5

Line 2391: from pa_progress_rollup ppr2

2387: -- Begin fix for Bug # 4499065.
2388: AND ppru.current_flag (+) <> 'W' -----= 'Y' (changed to <> 'W' condition)
2389: AND ppru.object_version_id(+) = ppv.element_version_id
2390: AND nvl(ppru.as_of_date, trunc(sysdate)) = (select nvl(max(ppr2.as_of_date),trunc(sysdate))
2391: from pa_progress_rollup ppr2
2392: where
2393: ppr2.object_id = ppv.proj_element_id
2394: and ppr2.proj_element_id = ppv.proj_element_id
2395: and ppr2.object_version_id = ppv.element_version_id

Line 3190: ,pa_progress_rollup ppru

3186: ,pa_work_types_tl pwt
3187: ,pa_task_types tt
3188: ,pa_project_statuses pps3
3189: ,pa_page_layouts ppl
3190: ,pa_progress_rollup ppru
3191: -----,pa_percent_completes ppc
3192: ,pa_project_statuses pps
3193: ,pa_project_statuses pps5
3194: ,pa_proj_elements ppe5

Line 3249: from pa_progress_rollup ppr2

3245: -- Begin fix for Bug # 4499065.
3246: AND ppru.current_flag (+) <> 'W' -----= 'Y' (changed to <> 'W' condition)
3247: AND ppru.object_version_id(+) = ppv.element_version_id
3248: AND nvl(ppru.as_of_date, trunc(sysdate)) = (select nvl(max(ppr2.as_of_date),trunc(sysdate))
3249: from pa_progress_rollup ppr2
3250: where
3251: ppr2.object_id = ppv.proj_element_id
3252: and ppr2.proj_element_id = ppv.proj_element_id
3253: and ppr2.object_version_id = ppv.element_version_id

Line 4161: ,pa_progress_rollup ppru

4157: ,pa_work_types_tl pwt
4158: ,pa_task_types tt
4159: ,pa_project_statuses pps3
4160: ,pa_page_layouts ppl
4161: ,pa_progress_rollup ppru
4162: -----,pa_percent_completes ppc
4163: ,pa_project_statuses pps
4164: ,pa_project_statuses pps5
4165: ,pa_proj_elements ppe5

Line 4986: ,pa_progress_rollup ppru

4982: ,pa_work_types_tl pwt
4983: ,pa_task_types tt
4984: ,pa_project_statuses pps3
4985: ,pa_page_layouts ppl
4986: ,pa_progress_rollup ppru
4987: -----,pa_percent_completes ppc
4988: ,pa_project_statuses pps
4989: ,pa_project_statuses pps5
4990: ,pa_proj_elements ppe5

Line 5812: ,pa_progress_rollup ppru

5808: ,pa_work_types_tl pwt
5809: ,pa_task_types tt
5810: ,pa_project_statuses pps3
5811: ,pa_page_layouts ppl
5812: ,pa_progress_rollup ppru
5813: -----,pa_percent_completes ppc
5814: ,pa_project_statuses pps
5815: ,pa_project_statuses pps5
5816: ,pa_proj_elements ppe5

Line 6757: ,pa_progress_rollup ppru

6753: ,pa_object_relationships por
6754: ,pa_object_relationships por2
6755: ,pji_fm_xbs_accum_tmp1 pfxat
6756: ----,pa_percent_completes ppc
6757: ,pa_progress_rollup ppru
6758: ,pa_proj_progress_attr pppa
6759: where
6760: por.object_id_from1 in ( SELECT ppevs.element_version_id
6761: FROM pa_proj_elements ppes, pa_proj_element_versions ppevs

Line 7247: ,pa_progress_rollup ppru

7243: ,pa_object_relationships por
7244: ,pa_object_relationships por2
7245: ,pji_fm_xbs_accum_tmp1 pfxat
7246: ----,pa_percent_completes ppc
7247: ,pa_progress_rollup ppru
7248: ,pa_proj_progress_attr pppa
7249: where
7250: por.object_id_from1 in ( SELECT ppevs.element_version_id
7251: FROM pa_proj_elements ppes, pa_proj_element_versions ppevs

Line 7288: from pa_progress_rollup ppr2

7284: -- Begin fix for Bug # 4499065.
7285: AND ppru.current_flag(+) <> 'W' --- = 'Y' (changed to <> 'W' condition) Bug # 4416432, Issue # 18
7286: AND ppru.object_version_id(+) = ppv1.element_version_id
7287: AND nvl(ppru.as_of_date, trunc(sysdate)) = (select nvl(max(ppr2.as_of_date),trunc(sysdate))
7288: from pa_progress_rollup ppr2
7289: where
7290: ppr2.object_id = ppv1.proj_element_id
7291: and ppr2.proj_element_id = ppv1.proj_element_id
7292: and ppr2.object_version_id = ppv1.element_version_id

Line 8067: ,pa_progress_rollup ppru

8063: ,pa_work_types_tl pwt
8064: ,pa_task_types tt
8065: ,pa_project_statuses pps3
8066: ,pa_page_layouts ppl
8067: ,pa_progress_rollup ppru
8068: ----,pa_percent_completes ppc
8069: ,pa_project_statuses pps
8070: ,pa_project_statuses pps5
8071: ,pa_proj_elements ppe5

Line 8827: ,pa_progress_rollup ppru

8823: ,pa_work_types_tl pwt
8824: ,pa_task_types tt
8825: ,pa_project_statuses pps3
8826: ,pa_page_layouts ppl
8827: ,pa_progress_rollup ppru
8828: ----,pa_percent_completes ppc
8829: ,pa_project_statuses pps
8830: ,pa_project_statuses pps5
8831: ,pa_proj_elements ppe5

Line 8966: -- as it is not available in the pa_progress_rollup table thus causing the

8962: g1_debug_mode VARCHAR2(1) ;
8963:
8964: -- Bug Fix 5611760. Performance changes.
8965: -- obtaining the task_weight_basis_code from the pa_proj_progress_attr table
8966: -- as it is not available in the pa_progress_rollup table thus causing the
8967: -- get_bcws function to get the same for every call.
8968:
8969: l_task_weight_basis_code pa_proj_progress_attr.task_weight_basis_code%TYPE;
8970: l_structure_type pa_proj_progress_attr.structure_type%TYPE := 'WORKPLAN';

Line 9018: -- is not available in the pa_progress_rollup table and that is causing the same a performance issue as

9014: -- ************************************************************************************************************************
9015:
9016: -- Bug Fix 5611760.
9017: -- Storing the task_weight_basis_code in a local variable and use that in the get_bcws call as the same
9018: -- is not available in the pa_progress_rollup table and that is causing the same a performance issue as
9019: -- the functiona get_bcws is getting the value for every call.
9020:
9021: OPEN c_task_weight_basis_code;
9022: FETCH c_task_weight_basis_code INTO l_task_weight_basis_code;

Line 9781: ,pa_progress_rollup ppru

9777: ,fnd_lookups fl5
9778: ,fnd_lookups fl6
9779: ,pa_lookups lu1
9780: ,pa_work_types_tl pwt
9781: ,pa_progress_rollup ppru
9782: ,pa_project_statuses pps
9783: ----,pa_percent_completes ppc
9784: ,pa_project_statuses pps5
9785: ,pa_task_types tt

Line 10608: ,pa_progress_rollup ppru

10604: ,fnd_lookups fl5
10605: ,fnd_lookups fl6
10606: ,pa_lookups lu1
10607: ,pa_work_types_tl pwt
10608: ,pa_progress_rollup ppru
10609: ,pa_project_statuses pps
10610: ----,pa_percent_completes ppc
10611: ,pa_project_statuses pps5
10612: ,pa_task_types tt

Line 11436: ,pa_progress_rollup ppru

11432: ,fnd_lookups fl5
11433: ,fnd_lookups fl6
11434: ,pa_lookups lu1
11435: ,pa_work_types_tl pwt
11436: ,pa_progress_rollup ppru
11437: ,pa_project_statuses pps
11438: ----,pa_percent_completes ppc
11439: ,pa_project_statuses pps5
11440: ,pa_task_types tt

Line 11580: -- as it is not available in the pa_progress_rollup table thus causing the

11576: g1_debug_mode VARCHAR2(1) ;
11577:
11578: -- Bug Fix 5611760. Performance changes.
11579: -- obtaining the task_weight_basis_code from the pa_proj_progress_attr table
11580: -- as it is not available in the pa_progress_rollup table thus causing the
11581: -- get_bcws function to get the same for every call.
11582:
11583: l_task_weight_basis_code pa_proj_progress_attr.task_weight_basis_code%TYPE;
11584: l_structure_type pa_proj_progress_attr.structure_type%TYPE := 'WORKPLAN';

Line 11632: -- is not available in the pa_progress_rollup table and that is causing the same a performance issue as

11628: -- ************************************************************************************************************************
11629:
11630: -- Bug Fix 5611760.
11631: -- Storing the task_weight_basis_code in a local variable and use that in the get_bcws call as the same
11632: -- is not available in the pa_progress_rollup table and that is causing the same a performance issue as
11633: -- the functiona get_bcws is getting the value for every call.
11634:
11635: OPEN c_task_weight_basis_code;
11636: FETCH c_task_weight_basis_code INTO l_task_weight_basis_code;

Line 12360: ,pa_progress_rollup ppru

12356: ,fnd_lookups fl5
12357: ,fnd_lookups fl6
12358: ,pa_lookups lu1
12359: ,pa_work_types_tl pwt
12360: ,pa_progress_rollup ppru
12361: ,pa_project_statuses pps
12362: ----,pa_percent_completes ppc
12363: ,pa_project_statuses pps5
12364: ,pa_task_types tt

Line 13156: ,pa_progress_rollup ppru

13152: ,fnd_lookups fl5
13153: ,fnd_lookups fl6
13154: ,pa_lookups lu1
13155: ,pa_work_types_tl pwt
13156: ,pa_progress_rollup ppru
13157: ,pa_project_statuses pps
13158: ----,pa_percent_completes ppc
13159: ,pa_project_statuses pps5
13160: ,pa_task_types tt

Line 13953: ,pa_progress_rollup ppru

13949: ,fnd_lookups fl5
13950: ,fnd_lookups fl6
13951: ,pa_lookups lu1
13952: ,pa_work_types_tl pwt
13953: ,pa_progress_rollup ppru
13954: ,pa_project_statuses pps
13955: ----,pa_percent_completes ppc
13956: ,pa_project_statuses pps5
13957: ,pa_task_types tt