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_PROCESS_UTIL dependencies on PJI_FP_XBS_ACCUM_F

Line 8690: index(fpr PJI_FP_XBS_ACCUM_F_N1) */

8686: wbs_hdr.CB_FLAG = fin_plan.CB_FLAG (+) and
8687: wbs_hdr.CO_FLAG = fin_plan.CO_FLAG (+)
8688: union all
8689: select /*+ ordered
8690: index(fpr PJI_FP_XBS_ACCUM_F_N1) */
8691: -- get delta task level amounts from Reporting Lines
8692: to_char(null) LINE_TYPE,
8693: wbs_hdr.WBS_VERSION_ID,
8694: decode(wbs_hdr.WP_FLAG, 'Y', 'LW', 'LF') RELATIONSHIP_TYPE,

Line 8792: PJI_FP_XBS_ACCUM_F fpr,

8788: PJI_PA_PROJ_EVENTS_LOG log,
8789: PJI_PJP_WBS_HEADER wbs_hdr,
8790: PJI_XBS_DENORM_DELTA wbs,
8791: PJI_XBS_DENORM prg,
8792: PJI_FP_XBS_ACCUM_F fpr,
8793: (
8794: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
8795: from DUAL union all
8796: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID

Line 10011: index(fpr PJI_FP_XBS_ACCUM_F_N1) */

10007: wbs_hdr.CB_FLAG = fin_plan.CB_FLAG (+) and
10008: wbs_hdr.CO_FLAG = fin_plan.CO_FLAG (+)
10009: union all
10010: select /*+ ordered
10011: index(fpr PJI_FP_XBS_ACCUM_F_N1) */
10012: -- get delta task level amounts from Reporting Lines
10013: to_char(null) LINE_TYPE,
10014: wbs_hdr.WBS_VERSION_ID,
10015: decode(wbs_hdr.WP_FLAG, 'Y', 'LW', 'LF') RELATIONSHIP_TYPE,

Line 10113: PJI_FP_XBS_ACCUM_F fpr,

10109: PJI_PA_PROJ_EVENTS_LOG log,
10110: PJI_PJP_WBS_HEADER wbs_hdr,
10111: PJI_XBS_DENORM_DELTA wbs,
10112: PJI_XBS_DENORM prg,
10113: PJI_FP_XBS_ACCUM_F fpr,
10114: (
10115: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
10116: from DUAL union all
10117: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID

Line 11330: index(fpr PJI_FP_XBS_ACCUM_F_N1) */

11326: wbs_hdr.CB_FLAG = fin_plan.CB_FLAG (+) and
11327: wbs_hdr.CO_FLAG = fin_plan.CO_FLAG (+)
11328: union all
11329: select /*+ ordered
11330: index(fpr PJI_FP_XBS_ACCUM_F_N1) */
11331: -- get delta task level amounts from Reporting Lines
11332: to_char(null) LINE_TYPE,
11333: wbs_hdr.WBS_VERSION_ID,
11334: decode(wbs_hdr.WP_FLAG, 'Y', 'LW', 'LF') RELATIONSHIP_TYPE,

Line 11432: PJI_FP_XBS_ACCUM_F fpr,

11428: PJI_PA_PROJ_EVENTS_LOG log,
11429: PJI_PJP_WBS_HEADER wbs_hdr,
11430: PJI_XBS_DENORM_DELTA wbs,
11431: PJI_XBS_DENORM prg,
11432: PJI_FP_XBS_ACCUM_F fpr,
11433: (
11434: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
11435: from DUAL union all
11436: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID

Line 12648: index(fpr PJI_FP_XBS_ACCUM_F_N1) */

12644: wbs_hdr.CB_FLAG = fin_plan.CB_FLAG (+) and
12645: wbs_hdr.CO_FLAG = fin_plan.CO_FLAG (+)
12646: union all
12647: select /*+ ordered
12648: index(fpr PJI_FP_XBS_ACCUM_F_N1) */
12649: -- get delta task level amounts from Reporting Lines
12650: to_char(null) LINE_TYPE,
12651: wbs_hdr.WBS_VERSION_ID,
12652: decode(wbs_hdr.WP_FLAG, 'Y', 'LW', 'LF') RELATIONSHIP_TYPE,

Line 12750: PJI_FP_XBS_ACCUM_F fpr,

12746: PJI_PA_PROJ_EVENTS_LOG log,
12747: PJI_PJP_WBS_HEADER wbs_hdr,
12748: PJI_XBS_DENORM_DELTA wbs,
12749: PJI_XBS_DENORM prg,
12750: PJI_FP_XBS_ACCUM_F fpr,
12751: (
12752: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
12753: from DUAL union all
12754: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID

Line 13966: index(fpr PJI_FP_XBS_ACCUM_F_N1) */

13962: wbs_hdr.CB_FLAG = fin_plan.CB_FLAG (+) and
13963: wbs_hdr.CO_FLAG = fin_plan.CO_FLAG (+)
13964: union all
13965: select /*+ ordered
13966: index(fpr PJI_FP_XBS_ACCUM_F_N1) */
13967: -- get delta task level amounts from Reporting Lines
13968: to_char(null) LINE_TYPE,
13969: wbs_hdr.WBS_VERSION_ID,
13970: decode(wbs_hdr.WP_FLAG, 'Y', 'LW', 'LF') RELATIONSHIP_TYPE,

Line 14068: PJI_FP_XBS_ACCUM_F fpr,

14064: PJI_PA_PROJ_EVENTS_LOG log,
14065: PJI_PJP_WBS_HEADER wbs_hdr,
14066: PJI_XBS_DENORM_DELTA wbs,
14067: PJI_XBS_DENORM prg,
14068: PJI_FP_XBS_ACCUM_F fpr,
14069: (
14070: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
14071: from DUAL union all
14072: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID

Line 15284: index(fpr PJI_FP_XBS_ACCUM_F_N1) */

15280: wbs_hdr.CB_FLAG = fin_plan.CB_FLAG (+) and
15281: wbs_hdr.CO_FLAG = fin_plan.CO_FLAG (+)
15282: union all
15283: select /*+ ordered
15284: index(fpr PJI_FP_XBS_ACCUM_F_N1) */
15285: -- get delta task level amounts from Reporting Lines
15286: to_char(null) LINE_TYPE,
15287: wbs_hdr.WBS_VERSION_ID,
15288: decode(wbs_hdr.WP_FLAG, 'Y', 'LW', 'LF') RELATIONSHIP_TYPE,

Line 15386: PJI_FP_XBS_ACCUM_F fpr,

15382: PJI_PA_PROJ_EVENTS_LOG log,
15383: PJI_PJP_WBS_HEADER wbs_hdr,
15384: PJI_XBS_DENORM_DELTA wbs,
15385: PJI_XBS_DENORM prg,
15386: PJI_FP_XBS_ACCUM_F fpr,
15387: (
15388: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
15389: from DUAL union all
15390: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID

Line 16602: index(fpr PJI_FP_XBS_ACCUM_F_N1) */

16598: wbs_hdr.CB_FLAG = fin_plan.CB_FLAG (+) and
16599: wbs_hdr.CO_FLAG = fin_plan.CO_FLAG (+)
16600: union all
16601: select /*+ ordered
16602: index(fpr PJI_FP_XBS_ACCUM_F_N1) */
16603: -- get delta task level amounts from Reporting Lines
16604: to_char(null) LINE_TYPE,
16605: wbs_hdr.WBS_VERSION_ID,
16606: decode(wbs_hdr.WP_FLAG, 'Y', 'LW', 'LF') RELATIONSHIP_TYPE,

Line 16704: PJI_FP_XBS_ACCUM_F fpr,

16700: PJI_PA_PROJ_EVENTS_LOG log,
16701: PJI_PJP_WBS_HEADER wbs_hdr,
16702: PJI_XBS_DENORM_DELTA wbs,
16703: PJI_XBS_DENORM prg,
16704: PJI_FP_XBS_ACCUM_F fpr,
16705: (
16706: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
16707: from DUAL union all
16708: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID

Line 17920: index(fpr PJI_FP_XBS_ACCUM_F_N1) */

17916: wbs_hdr.CB_FLAG = fin_plan.CB_FLAG (+) and
17917: wbs_hdr.CO_FLAG = fin_plan.CO_FLAG (+)
17918: union all
17919: select /*+ ordered
17920: index(fpr PJI_FP_XBS_ACCUM_F_N1) */
17921: -- get delta task level amounts from Reporting Lines
17922: to_char(null) LINE_TYPE,
17923: wbs_hdr.WBS_VERSION_ID,
17924: decode(wbs_hdr.WP_FLAG, 'Y', 'LW', 'LF') RELATIONSHIP_TYPE,

Line 18022: PJI_FP_XBS_ACCUM_F fpr,

18018: PJI_PA_PROJ_EVENTS_LOG log,
18019: PJI_PJP_WBS_HEADER wbs_hdr,
18020: PJI_XBS_DENORM_DELTA wbs,
18021: PJI_XBS_DENORM prg,
18022: PJI_FP_XBS_ACCUM_F fpr,
18023: (
18024: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
18025: from DUAL union all
18026: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID

Line 19238: index(fpr PJI_FP_XBS_ACCUM_F_N1) */

19234: wbs_hdr.CB_FLAG = fin_plan.CB_FLAG (+) and
19235: wbs_hdr.CO_FLAG = fin_plan.CO_FLAG (+)
19236: union all
19237: select /*+ ordered
19238: index(fpr PJI_FP_XBS_ACCUM_F_N1) */
19239: -- get delta task level amounts from Reporting Lines
19240: to_char(null) LINE_TYPE,
19241: wbs_hdr.WBS_VERSION_ID,
19242: decode(wbs_hdr.WP_FLAG, 'Y', 'LW', 'LF') RELATIONSHIP_TYPE,

Line 19340: PJI_FP_XBS_ACCUM_F fpr,

19336: PJI_PA_PROJ_EVENTS_LOG log,
19337: PJI_PJP_WBS_HEADER wbs_hdr,
19338: PJI_XBS_DENORM_DELTA wbs,
19339: PJI_XBS_DENORM prg,
19340: PJI_FP_XBS_ACCUM_F fpr,
19341: (
19342: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
19343: from DUAL union all
19344: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID

Line 20556: index(fpr PJI_FP_XBS_ACCUM_F_N1) */

20552: wbs_hdr.CB_FLAG = fin_plan.CB_FLAG (+) and
20553: wbs_hdr.CO_FLAG = fin_plan.CO_FLAG (+)
20554: union all
20555: select /*+ ordered
20556: index(fpr PJI_FP_XBS_ACCUM_F_N1) */
20557: -- get delta task level amounts from Reporting Lines
20558: to_char(null) LINE_TYPE,
20559: wbs_hdr.WBS_VERSION_ID,
20560: decode(wbs_hdr.WP_FLAG, 'Y', 'LW', 'LF') RELATIONSHIP_TYPE,

Line 20658: PJI_FP_XBS_ACCUM_F fpr,

20654: PJI_PA_PROJ_EVENTS_LOG log,
20655: PJI_PJP_WBS_HEADER wbs_hdr,
20656: PJI_XBS_DENORM_DELTA wbs,
20657: PJI_XBS_DENORM prg,
20658: PJI_FP_XBS_ACCUM_F fpr,
20659: (
20660: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
20661: from DUAL union all
20662: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID

Line 26916: select /+ ordered index(fpr PJI_FP_XBS_ACCUM_F_N1) /

26912: sum(pjp.CUSTOM14) CUSTOM14,
26913: sum(pjp.CUSTOM15) CUSTOM15
26914: from
26915: (
26916: select /*+ ordered index(fpr PJI_FP_XBS_ACCUM_F_N1) */
26917: -- get structure level amounts from Reporting Lines
26918: decode(fpr.RBS_AGGR_LEVEL,
26919: 'L', 'DO_NOT_ROLLUP',
26920: 'WBS') STRUCT_TYPE,

Line 27236: PJI_FP_XBS_ACCUM_F fpr,

27232: from
27233: PJI_XBS_DENORM_DELTA prg,
27234: PA_PROJ_ELEMENTS prj_emt,
27235: PJI_PJP_WBS_HEADER wbs_hdr,
27236: PJI_FP_XBS_ACCUM_F fpr,
27237: PJI_PJP_WBS_HEADER sup_wbs_hdr,
27238: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
27239: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,
27240: (

Line 27961: select /+ ordered index(fpr PJI_FP_XBS_ACCUM_F_N1) /

27957: sum(pjp.CUSTOM14) CUSTOM14,
27958: sum(pjp.CUSTOM15) CUSTOM15
27959: from
27960: (
27961: select /*+ ordered index(fpr PJI_FP_XBS_ACCUM_F_N1) */
27962: -- get structure level amounts from Reporting Lines
27963: decode(fpr.RBS_AGGR_LEVEL,
27964: 'L', 'DO_NOT_ROLLUP',
27965: 'WBS') STRUCT_TYPE,

Line 28281: PJI_FP_XBS_ACCUM_F fpr,

28277: from
28278: PJI_XBS_DENORM_DELTA prg,
28279: PA_PROJ_ELEMENTS prj_emt,
28280: PJI_PJP_WBS_HEADER wbs_hdr,
28281: PJI_FP_XBS_ACCUM_F fpr,
28282: PJI_PJP_WBS_HEADER sup_wbs_hdr,
28283: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
28284: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,
28285: (

Line 29006: select /+ ordered index(fpr PJI_FP_XBS_ACCUM_F_N1) /

29002: sum(pjp.CUSTOM14) CUSTOM14,
29003: sum(pjp.CUSTOM15) CUSTOM15
29004: from
29005: (
29006: select /*+ ordered index(fpr PJI_FP_XBS_ACCUM_F_N1) */
29007: -- get structure level amounts from Reporting Lines
29008: decode(fpr.RBS_AGGR_LEVEL,
29009: 'L', 'DO_NOT_ROLLUP',
29010: 'WBS') STRUCT_TYPE,

Line 29326: PJI_FP_XBS_ACCUM_F fpr,

29322: from
29323: PJI_XBS_DENORM_DELTA prg,
29324: PA_PROJ_ELEMENTS prj_emt,
29325: PJI_PJP_WBS_HEADER wbs_hdr,
29326: PJI_FP_XBS_ACCUM_F fpr,
29327: PJI_PJP_WBS_HEADER sup_wbs_hdr,
29328: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
29329: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,
29330: (

Line 30051: select /+ ordered index(fpr PJI_FP_XBS_ACCUM_F_N1) /

30047: sum(pjp.CUSTOM14) CUSTOM14,
30048: sum(pjp.CUSTOM15) CUSTOM15
30049: from
30050: (
30051: select /*+ ordered index(fpr PJI_FP_XBS_ACCUM_F_N1) */
30052: -- get structure level amounts from Reporting Lines
30053: decode(fpr.RBS_AGGR_LEVEL,
30054: 'L', 'DO_NOT_ROLLUP',
30055: 'WBS') STRUCT_TYPE,

Line 30371: PJI_FP_XBS_ACCUM_F fpr,

30367: from
30368: PJI_XBS_DENORM_DELTA prg,
30369: PA_PROJ_ELEMENTS prj_emt,
30370: PJI_PJP_WBS_HEADER wbs_hdr,
30371: PJI_FP_XBS_ACCUM_F fpr,
30372: PJI_PJP_WBS_HEADER sup_wbs_hdr,
30373: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
30374: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,
30375: (

Line 31096: select /+ ordered index(fpr PJI_FP_XBS_ACCUM_F_N1) /

31092: sum(pjp.CUSTOM14) CUSTOM14,
31093: sum(pjp.CUSTOM15) CUSTOM15
31094: from
31095: (
31096: select /*+ ordered index(fpr PJI_FP_XBS_ACCUM_F_N1) */
31097: -- get structure level amounts from Reporting Lines
31098: decode(fpr.RBS_AGGR_LEVEL,
31099: 'L', 'DO_NOT_ROLLUP',
31100: 'WBS') STRUCT_TYPE,

Line 31416: PJI_FP_XBS_ACCUM_F fpr,

31412: from
31413: PJI_XBS_DENORM_DELTA prg,
31414: PA_PROJ_ELEMENTS prj_emt,
31415: PJI_PJP_WBS_HEADER wbs_hdr,
31416: PJI_FP_XBS_ACCUM_F fpr,
31417: PJI_PJP_WBS_HEADER sup_wbs_hdr,
31418: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
31419: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,
31420: (

Line 32141: select /+ ordered index(fpr PJI_FP_XBS_ACCUM_F_N1) /

32137: sum(pjp.CUSTOM14) CUSTOM14,
32138: sum(pjp.CUSTOM15) CUSTOM15
32139: from
32140: (
32141: select /*+ ordered index(fpr PJI_FP_XBS_ACCUM_F_N1) */
32142: -- get structure level amounts from Reporting Lines
32143: decode(fpr.RBS_AGGR_LEVEL,
32144: 'L', 'DO_NOT_ROLLUP',
32145: 'WBS') STRUCT_TYPE,

Line 32461: PJI_FP_XBS_ACCUM_F fpr,

32457: from
32458: PJI_XBS_DENORM_DELTA prg,
32459: PA_PROJ_ELEMENTS prj_emt,
32460: PJI_PJP_WBS_HEADER wbs_hdr,
32461: PJI_FP_XBS_ACCUM_F fpr,
32462: PJI_PJP_WBS_HEADER sup_wbs_hdr,
32463: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
32464: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,
32465: (

Line 33186: select /+ ordered index(fpr PJI_FP_XBS_ACCUM_F_N1) /

33182: sum(pjp.CUSTOM14) CUSTOM14,
33183: sum(pjp.CUSTOM15) CUSTOM15
33184: from
33185: (
33186: select /*+ ordered index(fpr PJI_FP_XBS_ACCUM_F_N1) */
33187: -- get structure level amounts from Reporting Lines
33188: decode(fpr.RBS_AGGR_LEVEL,
33189: 'L', 'DO_NOT_ROLLUP',
33190: 'WBS') STRUCT_TYPE,

Line 33506: PJI_FP_XBS_ACCUM_F fpr,

33502: from
33503: PJI_XBS_DENORM_DELTA prg,
33504: PA_PROJ_ELEMENTS prj_emt,
33505: PJI_PJP_WBS_HEADER wbs_hdr,
33506: PJI_FP_XBS_ACCUM_F fpr,
33507: PJI_PJP_WBS_HEADER sup_wbs_hdr,
33508: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
33509: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,
33510: (

Line 34231: select /+ ordered index(fpr PJI_FP_XBS_ACCUM_F_N1) /

34227: sum(pjp.CUSTOM14) CUSTOM14,
34228: sum(pjp.CUSTOM15) CUSTOM15
34229: from
34230: (
34231: select /*+ ordered index(fpr PJI_FP_XBS_ACCUM_F_N1) */
34232: -- get structure level amounts from Reporting Lines
34233: decode(fpr.RBS_AGGR_LEVEL,
34234: 'L', 'DO_NOT_ROLLUP',
34235: 'WBS') STRUCT_TYPE,

Line 34551: PJI_FP_XBS_ACCUM_F fpr,

34547: from
34548: PJI_XBS_DENORM_DELTA prg,
34549: PA_PROJ_ELEMENTS prj_emt,
34550: PJI_PJP_WBS_HEADER wbs_hdr,
34551: PJI_FP_XBS_ACCUM_F fpr,
34552: PJI_PJP_WBS_HEADER sup_wbs_hdr,
34553: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
34554: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,
34555: (

Line 35276: select /+ ordered index(fpr PJI_FP_XBS_ACCUM_F_N1) /

35272: sum(pjp.CUSTOM14) CUSTOM14,
35273: sum(pjp.CUSTOM15) CUSTOM15
35274: from
35275: (
35276: select /*+ ordered index(fpr PJI_FP_XBS_ACCUM_F_N1) */
35277: -- get structure level amounts from Reporting Lines
35278: decode(fpr.RBS_AGGR_LEVEL,
35279: 'L', 'DO_NOT_ROLLUP',
35280: 'WBS') STRUCT_TYPE,

Line 35596: PJI_FP_XBS_ACCUM_F fpr,

35592: from
35593: PJI_XBS_DENORM_DELTA prg,
35594: PA_PROJ_ELEMENTS prj_emt,
35595: PJI_PJP_WBS_HEADER wbs_hdr,
35596: PJI_FP_XBS_ACCUM_F fpr,
35597: PJI_PJP_WBS_HEADER sup_wbs_hdr,
35598: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
35599: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,
35600: (

Line 36321: select /+ ordered index(fpr PJI_FP_XBS_ACCUM_F_N1) /

36317: sum(pjp.CUSTOM14) CUSTOM14,
36318: sum(pjp.CUSTOM15) CUSTOM15
36319: from
36320: (
36321: select /*+ ordered index(fpr PJI_FP_XBS_ACCUM_F_N1) */
36322: -- get structure level amounts from Reporting Lines
36323: decode(fpr.RBS_AGGR_LEVEL,
36324: 'L', 'DO_NOT_ROLLUP',
36325: 'WBS') STRUCT_TYPE,

Line 36641: PJI_FP_XBS_ACCUM_F fpr,

36637: from
36638: PJI_XBS_DENORM_DELTA prg,
36639: PA_PROJ_ELEMENTS prj_emt,
36640: PJI_PJP_WBS_HEADER wbs_hdr,
36641: PJI_FP_XBS_ACCUM_F fpr,
36642: PJI_PJP_WBS_HEADER sup_wbs_hdr,
36643: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
36644: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,
36645: (

Line 46256: index(fpr PJI_FP_XBS_ACCUM_F_N1) */

46252: wbs_hdr.CB_FLAG = fin_plan.CB_FLAG (+) and
46253: wbs_hdr.CO_FLAG = fin_plan.CO_FLAG (+)
46254: union all
46255: select /*+ ordered
46256: index(fpr PJI_FP_XBS_ACCUM_F_N1) */
46257: -- get delta task level amounts from Reporting Lines
46258: to_char(null) LINE_TYPE,
46259: wbs_hdr.WBS_VERSION_ID,
46260: decode(wbs_hdr.WP_FLAG, 'Y', 'LW', 'LF') RELATIONSHIP_TYPE,

Line 46359: PJI_FP_XBS_ACCUM_F fpr,

46355: PJI_HELPER_420 helper,
46356: PJI_PJP_WBS_HEADER_T wbs_hdr,
46357: PJI_XBS_DENORM_DELTA wbs,
46358: PJI_XBS_DENORM_T prg,
46359: PJI_FP_XBS_ACCUM_F fpr,
46360: (
46361: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
46362: from DUAL union all
46363: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID