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.PJI_PJP_GEN_PERF_ALL dependencies on PJI_FP_XBS_ACCUM_F

Line 4138: index(fpr PJI_FP_XBS_ACCUM_F_N1) */

4134: wbs_hdr.CB_FLAG = fin_plan.CB_FLAG (+) and
4135: wbs_hdr.CO_FLAG = fin_plan.CO_FLAG (+)
4136: union all
4137: select /*+ ordered
4138: index(fpr PJI_FP_XBS_ACCUM_F_N1) */
4139: -- get delta task level amounts from Reporting Lines
4140: to_char(null) LINE_TYPE,
4141: wbs_hdr.WBS_VERSION_ID,
4142: decode(wbs_hdr.WP_FLAG, 'Y', 'LW', 'LF') RELATIONSHIP_TYPE,

Line 4240: PJI_FP_XBS_ACCUM_F fpr,

4236: PJI_PA_PROJ_EVENTS_LOG log,
4237: PJI_PJP_WBS_HEADER wbs_hdr,
4238: PJI_XBS_DENORM_DELTA wbs,
4239: PJI_XBS_DENORM prg,
4240: PJI_FP_XBS_ACCUM_F fpr,
4241: (
4242: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
4243: from DUAL union all
4244: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID

Line 5453: index(fpr PJI_FP_XBS_ACCUM_F_N1) */

5449: wbs_hdr.CB_FLAG = fin_plan.CB_FLAG (+) and
5450: wbs_hdr.CO_FLAG = fin_plan.CO_FLAG (+)
5451: union all
5452: select /*+ ordered
5453: index(fpr PJI_FP_XBS_ACCUM_F_N1) */
5454: -- get delta task level amounts from Reporting Lines
5455: to_char(null) LINE_TYPE,
5456: wbs_hdr.WBS_VERSION_ID,
5457: decode(wbs_hdr.WP_FLAG, 'Y', 'LW', 'LF') RELATIONSHIP_TYPE,

Line 5555: PJI_FP_XBS_ACCUM_F fpr,

5551: PJI_PA_PROJ_EVENTS_LOG log,
5552: PJI_PJP_WBS_HEADER wbs_hdr,
5553: PJI_XBS_DENORM_DELTA wbs,
5554: PJI_XBS_DENORM prg,
5555: PJI_FP_XBS_ACCUM_F fpr,
5556: (
5557: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
5558: from DUAL union all
5559: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID

Line 6768: index(fpr PJI_FP_XBS_ACCUM_F_N1) */

6764: wbs_hdr.CB_FLAG = fin_plan.CB_FLAG (+) and
6765: wbs_hdr.CO_FLAG = fin_plan.CO_FLAG (+)
6766: union all
6767: select /*+ ordered
6768: index(fpr PJI_FP_XBS_ACCUM_F_N1) */
6769: -- get delta task level amounts from Reporting Lines
6770: to_char(null) LINE_TYPE,
6771: wbs_hdr.WBS_VERSION_ID,
6772: decode(wbs_hdr.WP_FLAG, 'Y', 'LW', 'LF') RELATIONSHIP_TYPE,

Line 6870: PJI_FP_XBS_ACCUM_F fpr,

6866: PJI_PA_PROJ_EVENTS_LOG log,
6867: PJI_PJP_WBS_HEADER wbs_hdr,
6868: PJI_XBS_DENORM_DELTA wbs,
6869: PJI_XBS_DENORM prg,
6870: PJI_FP_XBS_ACCUM_F fpr,
6871: (
6872: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
6873: from DUAL union all
6874: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID

Line 8082: index(fpr PJI_FP_XBS_ACCUM_F_N1) */

8078: wbs_hdr.CB_FLAG = fin_plan.CB_FLAG (+) and
8079: wbs_hdr.CO_FLAG = fin_plan.CO_FLAG (+)
8080: union all
8081: select /*+ ordered
8082: index(fpr PJI_FP_XBS_ACCUM_F_N1) */
8083: -- get delta task level amounts from Reporting Lines
8084: to_char(null) LINE_TYPE,
8085: wbs_hdr.WBS_VERSION_ID,
8086: decode(wbs_hdr.WP_FLAG, 'Y', 'LW', 'LF') RELATIONSHIP_TYPE,

Line 8184: PJI_FP_XBS_ACCUM_F fpr,

8180: PJI_PA_PROJ_EVENTS_LOG log,
8181: PJI_PJP_WBS_HEADER wbs_hdr,
8182: PJI_XBS_DENORM_DELTA wbs,
8183: PJI_XBS_DENORM prg,
8184: PJI_FP_XBS_ACCUM_F fpr,
8185: (
8186: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
8187: from DUAL union all
8188: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID

Line 9396: index(fpr PJI_FP_XBS_ACCUM_F_N1) */

9392: wbs_hdr.CB_FLAG = fin_plan.CB_FLAG (+) and
9393: wbs_hdr.CO_FLAG = fin_plan.CO_FLAG (+)
9394: union all
9395: select /*+ ordered
9396: index(fpr PJI_FP_XBS_ACCUM_F_N1) */
9397: -- get delta task level amounts from Reporting Lines
9398: to_char(null) LINE_TYPE,
9399: wbs_hdr.WBS_VERSION_ID,
9400: decode(wbs_hdr.WP_FLAG, 'Y', 'LW', 'LF') RELATIONSHIP_TYPE,

Line 9498: PJI_FP_XBS_ACCUM_F fpr,

9494: PJI_PA_PROJ_EVENTS_LOG log,
9495: PJI_PJP_WBS_HEADER wbs_hdr,
9496: PJI_XBS_DENORM_DELTA wbs,
9497: PJI_XBS_DENORM prg,
9498: PJI_FP_XBS_ACCUM_F fpr,
9499: (
9500: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
9501: from DUAL union all
9502: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID

Line 10710: index(fpr PJI_FP_XBS_ACCUM_F_N1) */

10706: wbs_hdr.CB_FLAG = fin_plan.CB_FLAG (+) and
10707: wbs_hdr.CO_FLAG = fin_plan.CO_FLAG (+)
10708: union all
10709: select /*+ ordered
10710: index(fpr PJI_FP_XBS_ACCUM_F_N1) */
10711: -- get delta task level amounts from Reporting Lines
10712: to_char(null) LINE_TYPE,
10713: wbs_hdr.WBS_VERSION_ID,
10714: decode(wbs_hdr.WP_FLAG, 'Y', 'LW', 'LF') RELATIONSHIP_TYPE,

Line 10812: PJI_FP_XBS_ACCUM_F fpr,

10808: PJI_PA_PROJ_EVENTS_LOG log,
10809: PJI_PJP_WBS_HEADER wbs_hdr,
10810: PJI_XBS_DENORM_DELTA wbs,
10811: PJI_XBS_DENORM prg,
10812: PJI_FP_XBS_ACCUM_F fpr,
10813: (
10814: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
10815: from DUAL union all
10816: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID

Line 12024: index(fpr PJI_FP_XBS_ACCUM_F_N1) */

12020: wbs_hdr.CB_FLAG = fin_plan.CB_FLAG (+) and
12021: wbs_hdr.CO_FLAG = fin_plan.CO_FLAG (+)
12022: union all
12023: select /*+ ordered
12024: index(fpr PJI_FP_XBS_ACCUM_F_N1) */
12025: -- get delta task level amounts from Reporting Lines
12026: to_char(null) LINE_TYPE,
12027: wbs_hdr.WBS_VERSION_ID,
12028: decode(wbs_hdr.WP_FLAG, 'Y', 'LW', 'LF') RELATIONSHIP_TYPE,

Line 12126: PJI_FP_XBS_ACCUM_F fpr,

12122: PJI_PA_PROJ_EVENTS_LOG log,
12123: PJI_PJP_WBS_HEADER wbs_hdr,
12124: PJI_XBS_DENORM_DELTA wbs,
12125: PJI_XBS_DENORM prg,
12126: PJI_FP_XBS_ACCUM_F fpr,
12127: (
12128: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
12129: from DUAL union all
12130: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID

Line 13338: index(fpr PJI_FP_XBS_ACCUM_F_N1) */

13334: wbs_hdr.CB_FLAG = fin_plan.CB_FLAG (+) and
13335: wbs_hdr.CO_FLAG = fin_plan.CO_FLAG (+)
13336: union all
13337: select /*+ ordered
13338: index(fpr PJI_FP_XBS_ACCUM_F_N1) */
13339: -- get delta task level amounts from Reporting Lines
13340: to_char(null) LINE_TYPE,
13341: wbs_hdr.WBS_VERSION_ID,
13342: decode(wbs_hdr.WP_FLAG, 'Y', 'LW', 'LF') RELATIONSHIP_TYPE,

Line 13440: PJI_FP_XBS_ACCUM_F fpr,

13436: PJI_PA_PROJ_EVENTS_LOG log,
13437: PJI_PJP_WBS_HEADER wbs_hdr,
13438: PJI_XBS_DENORM_DELTA wbs,
13439: PJI_XBS_DENORM prg,
13440: PJI_FP_XBS_ACCUM_F fpr,
13441: (
13442: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
13443: from DUAL union all
13444: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID

Line 14652: index(fpr PJI_FP_XBS_ACCUM_F_N1) */

14648: wbs_hdr.CB_FLAG = fin_plan.CB_FLAG (+) and
14649: wbs_hdr.CO_FLAG = fin_plan.CO_FLAG (+)
14650: union all
14651: select /*+ ordered
14652: index(fpr PJI_FP_XBS_ACCUM_F_N1) */
14653: -- get delta task level amounts from Reporting Lines
14654: to_char(null) LINE_TYPE,
14655: wbs_hdr.WBS_VERSION_ID,
14656: decode(wbs_hdr.WP_FLAG, 'Y', 'LW', 'LF') RELATIONSHIP_TYPE,

Line 14754: PJI_FP_XBS_ACCUM_F fpr,

14750: PJI_PA_PROJ_EVENTS_LOG log,
14751: PJI_PJP_WBS_HEADER wbs_hdr,
14752: PJI_XBS_DENORM_DELTA wbs,
14753: PJI_XBS_DENORM prg,
14754: PJI_FP_XBS_ACCUM_F fpr,
14755: (
14756: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
14757: from DUAL union all
14758: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID

Line 15966: index(fpr PJI_FP_XBS_ACCUM_F_N1) */

15962: wbs_hdr.CB_FLAG = fin_plan.CB_FLAG (+) and
15963: wbs_hdr.CO_FLAG = fin_plan.CO_FLAG (+)
15964: union all
15965: select /*+ ordered
15966: index(fpr PJI_FP_XBS_ACCUM_F_N1) */
15967: -- get delta task level amounts from Reporting Lines
15968: to_char(null) LINE_TYPE,
15969: wbs_hdr.WBS_VERSION_ID,
15970: decode(wbs_hdr.WP_FLAG, 'Y', 'LW', 'LF') RELATIONSHIP_TYPE,

Line 16068: PJI_FP_XBS_ACCUM_F fpr,

16064: PJI_PA_PROJ_EVENTS_LOG log,
16065: PJI_PJP_WBS_HEADER wbs_hdr,
16066: PJI_XBS_DENORM_DELTA wbs,
16067: PJI_XBS_DENORM prg,
16068: PJI_FP_XBS_ACCUM_F fpr,
16069: (
16070: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
16071: from DUAL union all
16072: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID