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.PA_PROJ_STRUCTURE_PUB dependencies on PA_PROGRESS_ROLLUP

Line 1518: ,pa_progress_rollup ppru

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

Line 1578: -- AND nvl(ppru.as_of_date, trunc(sysdate)) = (select /+ INDEX (ppr2 pa_progress_rollup_u2)/ nvl(max(ppr2.as_of_date),trunc(sysdate)) --Bug 7644130

1574: AND ppru.current_flag (+) <> 'W' -----= 'Y' (changed to <> 'W' condition)
1575: AND ppru.object_version_id(+) = ppv.element_version_id
1576: -- Bug#11798422 - Replaced NVL with union
1577: -- Commented below line for bug#11798422
1578: -- AND nvl(ppru.as_of_date, trunc(sysdate)) = (select /*+ INDEX (ppr2 pa_progress_rollup_u2)*/ nvl(max(ppr2.as_of_date),trunc(sysdate)) --Bug 7644130
1579: AND PPRU.AS_OF_DATE =
1580: ( SELECT /*+ push_subq no_unnest INDEX ( ppr2 pa_progress_rollup_u2 ) */ MAX ( PPR2.AS_OF_DATE )
1581: from pa_progress_rollup ppr2
1582: where

Line 1580: ( SELECT /+ push_subq no_unnest INDEX ( ppr2 pa_progress_rollup_u2 ) / MAX ( PPR2.AS_OF_DATE )

1576: -- Bug#11798422 - Replaced NVL with union
1577: -- Commented below line for bug#11798422
1578: -- AND nvl(ppru.as_of_date, trunc(sysdate)) = (select /*+ INDEX (ppr2 pa_progress_rollup_u2)*/ nvl(max(ppr2.as_of_date),trunc(sysdate)) --Bug 7644130
1579: AND PPRU.AS_OF_DATE =
1580: ( SELECT /*+ push_subq no_unnest INDEX ( ppr2 pa_progress_rollup_u2 ) */ MAX ( PPR2.AS_OF_DATE )
1581: from pa_progress_rollup ppr2
1582: where
1583: ppr2.object_id = ppv.proj_element_id
1584: and ppr2.proj_element_id = ppv.proj_element_id

Line 1581: from pa_progress_rollup ppr2

1577: -- Commented below line for bug#11798422
1578: -- AND nvl(ppru.as_of_date, trunc(sysdate)) = (select /*+ INDEX (ppr2 pa_progress_rollup_u2)*/ nvl(max(ppr2.as_of_date),trunc(sysdate)) --Bug 7644130
1579: AND PPRU.AS_OF_DATE =
1580: ( SELECT /*+ push_subq no_unnest INDEX ( ppr2 pa_progress_rollup_u2 ) */ MAX ( PPR2.AS_OF_DATE )
1581: from pa_progress_rollup ppr2
1582: where
1583: ppr2.object_id = ppv.proj_element_id
1584: and ppr2.proj_element_id = ppv.proj_element_id
1585: and ppr2.object_version_id = ppv.element_version_id

Line 2095: ,pa_progress_rollup ppru

2091: ,pa_work_types_tl pwt
2092: ,pa_task_types tt
2093: ,pa_project_statuses pps3
2094: ,pa_page_layouts ppl
2095: ,pa_progress_rollup ppru
2096: -----,pa_percent_completes ppc
2097: ,pa_project_statuses pps
2098: ,pa_project_statuses pps5
2099: ,pa_proj_elements ppe5

Line 2155: -- AND nvl(ppru.as_of_date, trunc(sysdate)) = (select /+ INDEX (ppr2 pa_progress_rollup_u2)/ nvl(max(ppr2.as_of_date),trunc(sysdate)) --Bug 7644130

2151: AND ppru.current_flag (+) <> 'W' -----= 'Y' (changed to <> 'W' condition)
2152: AND ppru.object_version_id(+) = ppv.element_version_id
2153: -- Bug#11798422 - Replaced NVL with union
2154: -- Commented below line for bug#11798422
2155: -- AND nvl(ppru.as_of_date, trunc(sysdate)) = (select /*+ INDEX (ppr2 pa_progress_rollup_u2)*/ nvl(max(ppr2.as_of_date),trunc(sysdate)) --Bug 7644130
2156: AND PPRU.AS_OF_DATE is NULL --added for bug#11798422
2157: AND TRUNC(sysdate)=
2158: ( SELECT /*+ push_subq no_unnest INDEX ( ppr2 pa_progress_rollup_u2 ) */ NVL ( MAX ( PPR2.AS_OF_DATE ) , TRUNC ( SYSDATE ) )
2159: from pa_progress_rollup ppr2

Line 2158: ( SELECT /+ push_subq no_unnest INDEX ( ppr2 pa_progress_rollup_u2 ) / NVL ( MAX ( PPR2.AS_OF_DATE ) , TRUNC ( SYSDATE ) )

2154: -- Commented below line for bug#11798422
2155: -- AND nvl(ppru.as_of_date, trunc(sysdate)) = (select /*+ INDEX (ppr2 pa_progress_rollup_u2)*/ nvl(max(ppr2.as_of_date),trunc(sysdate)) --Bug 7644130
2156: AND PPRU.AS_OF_DATE is NULL --added for bug#11798422
2157: AND TRUNC(sysdate)=
2158: ( SELECT /*+ push_subq no_unnest INDEX ( ppr2 pa_progress_rollup_u2 ) */ NVL ( MAX ( PPR2.AS_OF_DATE ) , TRUNC ( SYSDATE ) )
2159: from pa_progress_rollup ppr2
2160: where
2161: ppr2.object_id = ppv.proj_element_id
2162: and ppr2.proj_element_id = ppv.proj_element_id

Line 2159: from pa_progress_rollup ppr2

2155: -- AND nvl(ppru.as_of_date, trunc(sysdate)) = (select /*+ INDEX (ppr2 pa_progress_rollup_u2)*/ nvl(max(ppr2.as_of_date),trunc(sysdate)) --Bug 7644130
2156: AND PPRU.AS_OF_DATE is NULL --added for bug#11798422
2157: AND TRUNC(sysdate)=
2158: ( SELECT /*+ push_subq no_unnest INDEX ( ppr2 pa_progress_rollup_u2 ) */ NVL ( MAX ( PPR2.AS_OF_DATE ) , TRUNC ( SYSDATE ) )
2159: from pa_progress_rollup ppr2
2160: where
2161: ppr2.object_id = ppv.proj_element_id
2162: and ppr2.proj_element_id = ppv.proj_element_id
2163: and ppr2.object_version_id = ppv.element_version_id

Line 2917: ,pa_progress_rollup ppru

2913: ,pa_work_types_tl pwt
2914: ,pa_task_types tt
2915: ,pa_project_statuses pps3
2916: ,pa_page_layouts ppl
2917: ,pa_progress_rollup ppru
2918: -----,pa_percent_completes ppc Bug 5580992
2919: ,pa_project_statuses pps
2920: ,pa_project_statuses pps5
2921: ,pa_proj_elements ppe5

Line 2977: -- AND nvl(ppru.as_of_date, trunc(sysdate)) = (select /+ INDEX (ppr2 pa_progress_rollup_u2)/ nvl(max(ppr2.as_of_date),trunc(sysdate)) --Bug 7644130

2973: AND ppru.current_flag (+) <> 'W' -----= 'Y' (changed to <> 'W' condition)
2974: AND ppru.object_version_id(+) = ppv.element_version_id
2975: -- Bug#11798422 - Replaced NVL with union
2976: -- Commented below line for bug#11798422
2977: -- AND nvl(ppru.as_of_date, trunc(sysdate)) = (select /*+ INDEX (ppr2 pa_progress_rollup_u2)*/ nvl(max(ppr2.as_of_date),trunc(sysdate)) --Bug 7644130
2978: AND PPRU.AS_OF_DATE =
2979: ( SELECT /*+ push_subq no_unnest INDEX ( ppr2 pa_progress_rollup_u2 ) */ MAX ( PPR2.AS_OF_DATE )
2980: from pa_progress_rollup ppr2
2981: where

Line 2979: ( SELECT /+ push_subq no_unnest INDEX ( ppr2 pa_progress_rollup_u2 ) / MAX ( PPR2.AS_OF_DATE )

2975: -- Bug#11798422 - Replaced NVL with union
2976: -- Commented below line for bug#11798422
2977: -- AND nvl(ppru.as_of_date, trunc(sysdate)) = (select /*+ INDEX (ppr2 pa_progress_rollup_u2)*/ nvl(max(ppr2.as_of_date),trunc(sysdate)) --Bug 7644130
2978: AND PPRU.AS_OF_DATE =
2979: ( SELECT /*+ push_subq no_unnest INDEX ( ppr2 pa_progress_rollup_u2 ) */ MAX ( PPR2.AS_OF_DATE )
2980: from pa_progress_rollup ppr2
2981: where
2982: ppr2.object_id = ppv.proj_element_id
2983: and ppr2.proj_element_id = ppv.proj_element_id

Line 2980: from pa_progress_rollup ppr2

2976: -- Commented below line for bug#11798422
2977: -- AND nvl(ppru.as_of_date, trunc(sysdate)) = (select /*+ INDEX (ppr2 pa_progress_rollup_u2)*/ nvl(max(ppr2.as_of_date),trunc(sysdate)) --Bug 7644130
2978: AND PPRU.AS_OF_DATE =
2979: ( SELECT /*+ push_subq no_unnest INDEX ( ppr2 pa_progress_rollup_u2 ) */ MAX ( PPR2.AS_OF_DATE )
2980: from pa_progress_rollup ppr2
2981: where
2982: ppr2.object_id = ppv.proj_element_id
2983: and ppr2.proj_element_id = ppv.proj_element_id
2984: and ppr2.object_version_id = ppv.element_version_id

Line 3497: ,pa_progress_rollup ppru

3493: ,pa_work_types_tl pwt
3494: ,pa_task_types tt
3495: ,pa_project_statuses pps3
3496: ,pa_page_layouts ppl
3497: ,pa_progress_rollup ppru
3498: -----,pa_percent_completes ppc Bug 5580992
3499: ,pa_project_statuses pps
3500: ,pa_project_statuses pps5
3501: ,pa_proj_elements ppe5

Line 3557: -- AND nvl(ppru.as_of_date, trunc(sysdate)) = (select /+ INDEX (ppr2 pa_progress_rollup_u2)/ nvl(max(ppr2.as_of_date),trunc(sysdate)) --Bug 7644130

3553: AND ppru.current_flag (+) <> 'W' -----= 'Y' (changed to <> 'W' condition)
3554: AND ppru.object_version_id(+) = ppv.element_version_id
3555: -- Bug#11798422 - Replaced NVL with union
3556: -- Commented below line for bug#11798422
3557: -- AND nvl(ppru.as_of_date, trunc(sysdate)) = (select /*+ INDEX (ppr2 pa_progress_rollup_u2)*/ nvl(max(ppr2.as_of_date),trunc(sysdate)) --Bug 7644130
3558: AND PPRU.AS_OF_DATE is NULL --added for bug#11798422
3559: AND TRUNC(sysdate)=
3560: ( SELECT /*+ push_subq no_unnest INDEX ( ppr2 pa_progress_rollup_u2 ) */ NVL ( MAX ( PPR2.AS_OF_DATE ) , TRUNC ( SYSDATE ) )
3561: from pa_progress_rollup ppr2

Line 3560: ( SELECT /+ push_subq no_unnest INDEX ( ppr2 pa_progress_rollup_u2 ) / NVL ( MAX ( PPR2.AS_OF_DATE ) , TRUNC ( SYSDATE ) )

3556: -- Commented below line for bug#11798422
3557: -- AND nvl(ppru.as_of_date, trunc(sysdate)) = (select /*+ INDEX (ppr2 pa_progress_rollup_u2)*/ nvl(max(ppr2.as_of_date),trunc(sysdate)) --Bug 7644130
3558: AND PPRU.AS_OF_DATE is NULL --added for bug#11798422
3559: AND TRUNC(sysdate)=
3560: ( SELECT /*+ push_subq no_unnest INDEX ( ppr2 pa_progress_rollup_u2 ) */ NVL ( MAX ( PPR2.AS_OF_DATE ) , TRUNC ( SYSDATE ) )
3561: from pa_progress_rollup ppr2
3562: where
3563: ppr2.object_id = ppv.proj_element_id
3564: and ppr2.proj_element_id = ppv.proj_element_id

Line 3561: from pa_progress_rollup ppr2

3557: -- AND nvl(ppru.as_of_date, trunc(sysdate)) = (select /*+ INDEX (ppr2 pa_progress_rollup_u2)*/ nvl(max(ppr2.as_of_date),trunc(sysdate)) --Bug 7644130
3558: AND PPRU.AS_OF_DATE is NULL --added for bug#11798422
3559: AND TRUNC(sysdate)=
3560: ( SELECT /*+ push_subq no_unnest INDEX ( ppr2 pa_progress_rollup_u2 ) */ NVL ( MAX ( PPR2.AS_OF_DATE ) , TRUNC ( SYSDATE ) )
3561: from pa_progress_rollup ppr2
3562: where
3563: ppr2.object_id = ppv.proj_element_id
3564: and ppr2.proj_element_id = ppv.proj_element_id
3565: and ppr2.object_version_id = ppv.element_version_id

Line 4367: ,pa_progress_rollup ppru

4363: ,pa_work_types_tl pwt
4364: ,pa_task_types tt
4365: ,pa_project_statuses pps3
4366: ,pa_page_layouts ppl
4367: ,pa_progress_rollup ppru
4368: -----,pa_percent_completes ppc
4369: ,pa_project_statuses pps
4370: ,pa_project_statuses pps5
4371: ,pa_proj_elements ppe5

Line 4427: -- AND nvl(ppru.as_of_date, trunc(sysdate)) = (select /+ INDEX (ppr2 pa_progress_rollup_u2)/ nvl(max(ppr2.as_of_date),trunc(sysdate)) --Bug 7644130

4423: AND ppru.current_flag (+) <> 'W' -----= 'Y' (changed to <> 'W' condition)
4424: AND ppru.object_version_id(+) = ppv.element_version_id
4425: -- Bug#11798422 - Replaced NVL with union
4426: -- Commented below line for bug#11798422
4427: -- AND nvl(ppru.as_of_date, trunc(sysdate)) = (select /*+ INDEX (ppr2 pa_progress_rollup_u2)*/ nvl(max(ppr2.as_of_date),trunc(sysdate)) --Bug 7644130
4428: AND PPRU.AS_OF_DATE =
4429: ( SELECT /*+ push_subq no_unnest INDEX ( ppr2 pa_progress_rollup_u2 ) */ MAX ( PPR2.AS_OF_DATE )
4430: from pa_progress_rollup ppr2
4431: where

Line 4429: ( SELECT /+ push_subq no_unnest INDEX ( ppr2 pa_progress_rollup_u2 ) / MAX ( PPR2.AS_OF_DATE )

4425: -- Bug#11798422 - Replaced NVL with union
4426: -- Commented below line for bug#11798422
4427: -- AND nvl(ppru.as_of_date, trunc(sysdate)) = (select /*+ INDEX (ppr2 pa_progress_rollup_u2)*/ nvl(max(ppr2.as_of_date),trunc(sysdate)) --Bug 7644130
4428: AND PPRU.AS_OF_DATE =
4429: ( SELECT /*+ push_subq no_unnest INDEX ( ppr2 pa_progress_rollup_u2 ) */ MAX ( PPR2.AS_OF_DATE )
4430: from pa_progress_rollup ppr2
4431: where
4432: ppr2.object_id = ppv.proj_element_id
4433: and ppr2.proj_element_id = ppv.proj_element_id

Line 4430: from pa_progress_rollup ppr2

4426: -- Commented below line for bug#11798422
4427: -- AND nvl(ppru.as_of_date, trunc(sysdate)) = (select /*+ INDEX (ppr2 pa_progress_rollup_u2)*/ nvl(max(ppr2.as_of_date),trunc(sysdate)) --Bug 7644130
4428: AND PPRU.AS_OF_DATE =
4429: ( SELECT /*+ push_subq no_unnest INDEX ( ppr2 pa_progress_rollup_u2 ) */ MAX ( PPR2.AS_OF_DATE )
4430: from pa_progress_rollup ppr2
4431: where
4432: ppr2.object_id = ppv.proj_element_id
4433: and ppr2.proj_element_id = ppv.proj_element_id
4434: and ppr2.object_version_id = ppv.element_version_id

Line 4942: ,pa_progress_rollup ppru

4938: ,pa_work_types_tl pwt
4939: ,pa_task_types tt
4940: ,pa_project_statuses pps3
4941: ,pa_page_layouts ppl
4942: ,pa_progress_rollup ppru
4943: -----,pa_percent_completes ppc
4944: ,pa_project_statuses pps
4945: ,pa_project_statuses pps5
4946: ,pa_proj_elements ppe5

Line 5002: -- AND nvl(ppru.as_of_date, trunc(sysdate)) = (select /+ INDEX (ppr2 pa_progress_rollup_u2)/ nvl(max(ppr2.as_of_date),trunc(sysdate)) --Bug 7644130

4998: AND ppru.current_flag (+) <> 'W' -----= 'Y' (changed to <> 'W' condition)
4999: AND ppru.object_version_id(+) = ppv.element_version_id
5000: -- Bug#11798422 - Replaced NVL with union
5001: -- Commented below line for bug#11798422
5002: -- AND nvl(ppru.as_of_date, trunc(sysdate)) = (select /*+ INDEX (ppr2 pa_progress_rollup_u2)*/ nvl(max(ppr2.as_of_date),trunc(sysdate)) --Bug 7644130
5003: AND PPRU.AS_OF_DATE is NULL --added for bug#11798422
5004: AND TRUNC(sysdate)=
5005: ( SELECT /*+ push_subq no_unnest INDEX ( ppr2 pa_progress_rollup_u2 ) */ NVL ( MAX ( PPR2.AS_OF_DATE ) , TRUNC ( SYSDATE ) )
5006: from pa_progress_rollup ppr2

Line 5005: ( SELECT /+ push_subq no_unnest INDEX ( ppr2 pa_progress_rollup_u2 ) / NVL ( MAX ( PPR2.AS_OF_DATE ) , TRUNC ( SYSDATE ) )

5001: -- Commented below line for bug#11798422
5002: -- AND nvl(ppru.as_of_date, trunc(sysdate)) = (select /*+ INDEX (ppr2 pa_progress_rollup_u2)*/ nvl(max(ppr2.as_of_date),trunc(sysdate)) --Bug 7644130
5003: AND PPRU.AS_OF_DATE is NULL --added for bug#11798422
5004: AND TRUNC(sysdate)=
5005: ( SELECT /*+ push_subq no_unnest INDEX ( ppr2 pa_progress_rollup_u2 ) */ NVL ( MAX ( PPR2.AS_OF_DATE ) , TRUNC ( SYSDATE ) )
5006: from pa_progress_rollup ppr2
5007: where
5008: ppr2.object_id = ppv.proj_element_id
5009: and ppr2.proj_element_id = ppv.proj_element_id

Line 5006: from pa_progress_rollup ppr2

5002: -- AND nvl(ppru.as_of_date, trunc(sysdate)) = (select /*+ INDEX (ppr2 pa_progress_rollup_u2)*/ nvl(max(ppr2.as_of_date),trunc(sysdate)) --Bug 7644130
5003: AND PPRU.AS_OF_DATE is NULL --added for bug#11798422
5004: AND TRUNC(sysdate)=
5005: ( SELECT /*+ push_subq no_unnest INDEX ( ppr2 pa_progress_rollup_u2 ) */ NVL ( MAX ( PPR2.AS_OF_DATE ) , TRUNC ( SYSDATE ) )
5006: from pa_progress_rollup ppr2
5007: where
5008: ppr2.object_id = ppv.proj_element_id
5009: and ppr2.proj_element_id = ppv.proj_element_id
5010: and ppr2.object_version_id = ppv.element_version_id

Line 5973: ,pa_progress_rollup ppru

5969: ,pa_work_types_tl pwt
5970: ,pa_task_types tt
5971: ,pa_project_statuses pps3
5972: ,pa_page_layouts ppl
5973: ,pa_progress_rollup ppru
5974: -----,pa_percent_completes ppc
5975: ,pa_project_statuses pps
5976: ,pa_project_statuses pps5
5977: ,pa_proj_elements ppe5

Line 6799: ,pa_progress_rollup ppru

6795: ,pa_work_types_tl pwt
6796: ,pa_task_types tt
6797: ,pa_project_statuses pps3
6798: ,pa_page_layouts ppl
6799: ,pa_progress_rollup ppru
6800: -----,pa_percent_completes ppc
6801: ,pa_project_statuses pps
6802: ,pa_project_statuses pps5
6803: ,pa_proj_elements ppe5

Line 7626: ,pa_progress_rollup ppru

7622: ,pa_work_types_tl pwt
7623: ,pa_task_types tt
7624: ,pa_project_statuses pps3
7625: ,pa_page_layouts ppl
7626: ,pa_progress_rollup ppru
7627: -----,pa_percent_completes ppc
7628: ,pa_project_statuses pps
7629: ,pa_project_statuses pps5
7630: ,pa_proj_elements ppe5

Line 8572: ,pa_progress_rollup ppru

8568: ,pa_object_relationships por
8569: ,pa_object_relationships por2
8570: ,pji_fm_xbs_accum_tmp1 pfxat
8571: ----,pa_percent_completes ppc
8572: ,pa_progress_rollup ppru
8573: ,pa_proj_progress_attr pppa
8574: where
8575: por.object_id_from1 in ( SELECT ppevs.element_version_id
8576: FROM pa_proj_elements ppes, pa_proj_element_versions ppevs

Line 9063: ,pa_progress_rollup ppru

9059: ,pa_object_relationships por
9060: ,pa_object_relationships por2
9061: ,pji_fm_xbs_accum_tmp1 pfxat
9062: ----,pa_percent_completes ppc
9063: ,pa_progress_rollup ppru
9064: ,pa_proj_progress_attr pppa
9065: where
9066: por.object_id_from1 in ( SELECT ppevs.element_version_id
9067: FROM pa_proj_elements ppes, pa_proj_element_versions ppevs

Line 9105: -- AND nvl(ppru.as_of_date, trunc(sysdate)) = (select /+ INDEX (ppr2 pa_progress_rollup_u2)/ nvl(max(ppr2.as_of_date),trunc(sysdate)) --Bug 7644130

9101: AND ppru.current_flag(+) <> 'W' --- = 'Y' (changed to <> 'W' condition) Bug # 4416432, Issue # 18
9102: AND ppru.object_version_id(+) = ppv1.element_version_id
9103: -- Bug#11798422 - Replaced NVL with union starts.
9104: -- Commented below line for bug#11798422
9105: -- AND nvl(ppru.as_of_date, trunc(sysdate)) = (select /*+ INDEX (ppr2 pa_progress_rollup_u2)*/ nvl(max(ppr2.as_of_date),trunc(sysdate)) --Bug 7644130
9106: AND PPRU.AS_OF_DATE =
9107: ( SELECT /*+ push_subq no_unnest INDEX ( ppr2 pa_progress_rollup_u2 ) */ MAX ( PPR2.AS_OF_DATE )
9108: from pa_progress_rollup ppr2
9109: where

Line 9107: ( SELECT /+ push_subq no_unnest INDEX ( ppr2 pa_progress_rollup_u2 ) / MAX ( PPR2.AS_OF_DATE )

9103: -- Bug#11798422 - Replaced NVL with union starts.
9104: -- Commented below line for bug#11798422
9105: -- AND nvl(ppru.as_of_date, trunc(sysdate)) = (select /*+ INDEX (ppr2 pa_progress_rollup_u2)*/ nvl(max(ppr2.as_of_date),trunc(sysdate)) --Bug 7644130
9106: AND PPRU.AS_OF_DATE =
9107: ( SELECT /*+ push_subq no_unnest INDEX ( ppr2 pa_progress_rollup_u2 ) */ MAX ( PPR2.AS_OF_DATE )
9108: from pa_progress_rollup ppr2
9109: where
9110: ppr2.object_id = ppv1.proj_element_id
9111: and ppr2.proj_element_id = ppv1.proj_element_id

Line 9108: from pa_progress_rollup ppr2

9104: -- Commented below line for bug#11798422
9105: -- AND nvl(ppru.as_of_date, trunc(sysdate)) = (select /*+ INDEX (ppr2 pa_progress_rollup_u2)*/ nvl(max(ppr2.as_of_date),trunc(sysdate)) --Bug 7644130
9106: AND PPRU.AS_OF_DATE =
9107: ( SELECT /*+ push_subq no_unnest INDEX ( ppr2 pa_progress_rollup_u2 ) */ MAX ( PPR2.AS_OF_DATE )
9108: from pa_progress_rollup ppr2
9109: where
9110: ppr2.object_id = ppv1.proj_element_id
9111: and ppr2.proj_element_id = ppv1.proj_element_id
9112: and ppr2.object_version_id = ppv1.element_version_id

Line 9571: ,pa_progress_rollup ppru

9567: ,pa_object_relationships por
9568: ,pa_object_relationships por2
9569: ,pji_fm_xbs_accum_tmp1 pfxat
9570: ----,pa_percent_completes ppc
9571: ,pa_progress_rollup ppru
9572: ,pa_proj_progress_attr pppa
9573: where
9574: por.object_id_from1 in ( SELECT ppevs.element_version_id
9575: FROM pa_proj_elements ppes, pa_proj_element_versions ppevs

Line 9612: -- AND nvl(ppru.as_of_date, trunc(sysdate)) = (select /+ INDEX (ppr2 pa_progress_rollup_u2)/ nvl(max(ppr2.as_of_date),trunc(sysdate)) --Bug 7644130

9608: -- Begin fix for Bug # 4499065.
9609: AND ppru.current_flag(+) <> 'W' --- = 'Y' (changed to <> 'W' condition) Bug # 4416432, Issue # 18
9610: AND ppru.object_version_id(+) = ppv1.element_version_id
9611: -- Commented below line for bug#11798422
9612: -- AND nvl(ppru.as_of_date, trunc(sysdate)) = (select /*+ INDEX (ppr2 pa_progress_rollup_u2)*/ nvl(max(ppr2.as_of_date),trunc(sysdate)) --Bug 7644130
9613: AND PPRU.AS_OF_DATE is NULL --added for bug#11798422
9614: AND TRUNC(sysdate)=
9615: ( SELECT /*+ push_subq no_unnest INDEX ( ppr2 pa_progress_rollup_u2 ) */ NVL ( MAX ( PPR2.AS_OF_DATE ) , TRUNC ( SYSDATE ) )
9616: from pa_progress_rollup ppr2

Line 9615: ( SELECT /+ push_subq no_unnest INDEX ( ppr2 pa_progress_rollup_u2 ) / NVL ( MAX ( PPR2.AS_OF_DATE ) , TRUNC ( SYSDATE ) )

9611: -- Commented below line for bug#11798422
9612: -- AND nvl(ppru.as_of_date, trunc(sysdate)) = (select /*+ INDEX (ppr2 pa_progress_rollup_u2)*/ nvl(max(ppr2.as_of_date),trunc(sysdate)) --Bug 7644130
9613: AND PPRU.AS_OF_DATE is NULL --added for bug#11798422
9614: AND TRUNC(sysdate)=
9615: ( SELECT /*+ push_subq no_unnest INDEX ( ppr2 pa_progress_rollup_u2 ) */ NVL ( MAX ( PPR2.AS_OF_DATE ) , TRUNC ( SYSDATE ) )
9616: from pa_progress_rollup ppr2
9617: where
9618: ppr2.object_id = ppv1.proj_element_id
9619: and ppr2.proj_element_id = ppv1.proj_element_id

Line 9616: from pa_progress_rollup ppr2

9612: -- AND nvl(ppru.as_of_date, trunc(sysdate)) = (select /*+ INDEX (ppr2 pa_progress_rollup_u2)*/ nvl(max(ppr2.as_of_date),trunc(sysdate)) --Bug 7644130
9613: AND PPRU.AS_OF_DATE is NULL --added for bug#11798422
9614: AND TRUNC(sysdate)=
9615: ( SELECT /*+ push_subq no_unnest INDEX ( ppr2 pa_progress_rollup_u2 ) */ NVL ( MAX ( PPR2.AS_OF_DATE ) , TRUNC ( SYSDATE ) )
9616: from pa_progress_rollup ppr2
9617: where
9618: ppr2.object_id = ppv1.proj_element_id
9619: and ppr2.proj_element_id = ppv1.proj_element_id
9620: and ppr2.object_version_id = ppv1.element_version_id

Line 10397: ,pa_progress_rollup ppru

10393: ,pa_work_types_tl pwt
10394: ,pa_task_types tt
10395: ,pa_project_statuses pps3
10396: ,pa_page_layouts ppl
10397: ,pa_progress_rollup ppru
10398: ----,pa_percent_completes ppc
10399: ,pa_project_statuses pps
10400: ,pa_project_statuses pps5
10401: ,pa_proj_elements ppe5

Line 11157: ,pa_progress_rollup ppru

11153: ,pa_work_types_tl pwt
11154: ,pa_task_types tt
11155: ,pa_project_statuses pps3
11156: ,pa_page_layouts ppl
11157: ,pa_progress_rollup ppru
11158: ----,pa_percent_completes ppc
11159: ,pa_project_statuses pps
11160: ,pa_project_statuses pps5
11161: ,pa_proj_elements ppe5

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

11292: g1_debug_mode VARCHAR2(1) ;
11293:
11294: -- Bug Fix 5611760. Performance changes.
11295: -- obtaining the task_weight_basis_code from the pa_proj_progress_attr table
11296: -- as it is not available in the pa_progress_rollup table thus causing the
11297: -- get_bcws function to get the same for every call.
11298:
11299: l_task_weight_basis_code pa_proj_progress_attr.task_weight_basis_code%TYPE;
11300: l_structure_type pa_proj_progress_attr.structure_type%TYPE := 'WORKPLAN';

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

11344: -- ************************************************************************************************************************
11345:
11346: -- Bug Fix 5611760.
11347: -- Storing the task_weight_basis_code in a local variable and use that in the get_bcws call as the same
11348: -- is not available in the pa_progress_rollup table and that is causing the same a performance issue as
11349: -- the functiona get_bcws is getting the value for every call.
11350:
11351: OPEN c_task_weight_basis_code;
11352: FETCH c_task_weight_basis_code INTO l_task_weight_basis_code;

Line 12112: ,pa_progress_rollup ppru

12108: ,fnd_lookups fl5
12109: ,fnd_lookups fl6
12110: ,pa_lookups lu1
12111: ,pa_work_types_tl pwt
12112: ,pa_progress_rollup ppru
12113: ,pa_project_statuses pps
12114: ----,pa_percent_completes ppc
12115: ,pa_project_statuses pps5
12116: ,pa_task_types tt

Line 12940: ,pa_progress_rollup ppru

12936: ,fnd_lookups fl5
12937: ,fnd_lookups fl6
12938: ,pa_lookups lu1
12939: ,pa_work_types_tl pwt
12940: ,pa_progress_rollup ppru
12941: ,pa_project_statuses pps
12942: ----,pa_percent_completes ppc
12943: ,pa_project_statuses pps5
12944: ,pa_task_types tt

Line 13769: ,pa_progress_rollup ppru

13765: ,fnd_lookups fl5
13766: ,fnd_lookups fl6
13767: ,pa_lookups lu1
13768: ,pa_work_types_tl pwt
13769: ,pa_progress_rollup ppru
13770: ,pa_project_statuses pps
13771: ----,pa_percent_completes ppc
13772: ,pa_project_statuses pps5
13773: ,pa_task_types tt

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

13909: g1_debug_mode VARCHAR2(1) ;
13910:
13911: -- Bug Fix 5611760. Performance changes.
13912: -- obtaining the task_weight_basis_code from the pa_proj_progress_attr table
13913: -- as it is not available in the pa_progress_rollup table thus causing the
13914: -- get_bcws function to get the same for every call.
13915:
13916: l_task_weight_basis_code pa_proj_progress_attr.task_weight_basis_code%TYPE;
13917: l_structure_type pa_proj_progress_attr.structure_type%TYPE := 'WORKPLAN';

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

13961: -- ************************************************************************************************************************
13962:
13963: -- Bug Fix 5611760.
13964: -- Storing the task_weight_basis_code in a local variable and use that in the get_bcws call as the same
13965: -- is not available in the pa_progress_rollup table and that is causing the same a performance issue as
13966: -- the functiona get_bcws is getting the value for every call.
13967:
13968: OPEN c_task_weight_basis_code;
13969: FETCH c_task_weight_basis_code INTO l_task_weight_basis_code;

Line 14694: ,pa_progress_rollup ppru

14690: ,fnd_lookups fl5
14691: ,fnd_lookups fl6
14692: ,pa_lookups lu1
14693: ,pa_work_types_tl pwt
14694: ,pa_progress_rollup ppru
14695: ,pa_project_statuses pps
14696: ----,pa_percent_completes ppc
14697: ,pa_project_statuses pps5
14698: ,pa_task_types tt

Line 15491: ,pa_progress_rollup ppru

15487: ,fnd_lookups fl5
15488: ,fnd_lookups fl6
15489: ,pa_lookups lu1
15490: ,pa_work_types_tl pwt
15491: ,pa_progress_rollup ppru
15492: ,pa_project_statuses pps
15493: ----,pa_percent_completes ppc
15494: ,pa_project_statuses pps5
15495: ,pa_task_types tt

Line 16289: ,pa_progress_rollup ppru

16285: ,fnd_lookups fl5
16286: ,fnd_lookups fl6
16287: ,pa_lookups lu1
16288: ,pa_work_types_tl pwt
16289: ,pa_progress_rollup ppru
16290: ,pa_project_statuses pps
16291: ----,pa_percent_completes ppc
16292: ,pa_project_statuses pps5
16293: ,pa_task_types tt