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_AC_XBS_ACCUM_F

Line 21363: PJI_AC_XBS_ACCUM_F acr,

21359: PJI_PA_PROJ_EVENTS_LOG log,
21360: PJI_PJP_WBS_HEADER wbs_hdr,
21361: PJI_XBS_DENORM_DELTA wbs,
21362: PJI_XBS_DENORM prg,
21363: PJI_AC_XBS_ACCUM_F acr,
21364: (
21365: select 1 WBS_SUP_LEVEL,
21366: 1 WBS_SUB_LEVEL,
21367: 'PRJ' INVERT_ID

Line 21945: PJI_AC_XBS_ACCUM_F acr,

21941: PJI_PA_PROJ_EVENTS_LOG log,
21942: PJI_PJP_WBS_HEADER wbs_hdr,
21943: PJI_XBS_DENORM_DELTA wbs,
21944: PJI_XBS_DENORM prg,
21945: PJI_AC_XBS_ACCUM_F acr,
21946: (
21947: select 1 WBS_SUP_LEVEL,
21948: 1 WBS_SUB_LEVEL,
21949: 'PRJ' INVERT_ID

Line 22527: PJI_AC_XBS_ACCUM_F acr,

22523: PJI_PA_PROJ_EVENTS_LOG log,
22524: PJI_PJP_WBS_HEADER wbs_hdr,
22525: PJI_XBS_DENORM_DELTA wbs,
22526: PJI_XBS_DENORM prg,
22527: PJI_AC_XBS_ACCUM_F acr,
22528: (
22529: select 1 WBS_SUP_LEVEL,
22530: 1 WBS_SUB_LEVEL,
22531: 'PRJ' INVERT_ID

Line 23109: PJI_AC_XBS_ACCUM_F acr,

23105: PJI_PA_PROJ_EVENTS_LOG log,
23106: PJI_PJP_WBS_HEADER wbs_hdr,
23107: PJI_XBS_DENORM_DELTA wbs,
23108: PJI_XBS_DENORM prg,
23109: PJI_AC_XBS_ACCUM_F acr,
23110: (
23111: select 1 WBS_SUP_LEVEL,
23112: 1 WBS_SUB_LEVEL,
23113: 'PRJ' INVERT_ID

Line 23691: PJI_AC_XBS_ACCUM_F acr,

23687: PJI_PA_PROJ_EVENTS_LOG log,
23688: PJI_PJP_WBS_HEADER wbs_hdr,
23689: PJI_XBS_DENORM_DELTA wbs,
23690: PJI_XBS_DENORM prg,
23691: PJI_AC_XBS_ACCUM_F acr,
23692: (
23693: select 1 WBS_SUP_LEVEL,
23694: 1 WBS_SUB_LEVEL,
23695: 'PRJ' INVERT_ID

Line 24273: PJI_AC_XBS_ACCUM_F acr,

24269: PJI_PA_PROJ_EVENTS_LOG log,
24270: PJI_PJP_WBS_HEADER wbs_hdr,
24271: PJI_XBS_DENORM_DELTA wbs,
24272: PJI_XBS_DENORM prg,
24273: PJI_AC_XBS_ACCUM_F acr,
24274: (
24275: select 1 WBS_SUP_LEVEL,
24276: 1 WBS_SUB_LEVEL,
24277: 'PRJ' INVERT_ID

Line 24855: PJI_AC_XBS_ACCUM_F acr,

24851: PJI_PA_PROJ_EVENTS_LOG log,
24852: PJI_PJP_WBS_HEADER wbs_hdr,
24853: PJI_XBS_DENORM_DELTA wbs,
24854: PJI_XBS_DENORM prg,
24855: PJI_AC_XBS_ACCUM_F acr,
24856: (
24857: select 1 WBS_SUP_LEVEL,
24858: 1 WBS_SUB_LEVEL,
24859: 'PRJ' INVERT_ID

Line 25437: PJI_AC_XBS_ACCUM_F acr,

25433: PJI_PA_PROJ_EVENTS_LOG log,
25434: PJI_PJP_WBS_HEADER wbs_hdr,
25435: PJI_XBS_DENORM_DELTA wbs,
25436: PJI_XBS_DENORM prg,
25437: PJI_AC_XBS_ACCUM_F acr,
25438: (
25439: select 1 WBS_SUP_LEVEL,
25440: 1 WBS_SUB_LEVEL,
25441: 'PRJ' INVERT_ID

Line 26019: PJI_AC_XBS_ACCUM_F acr,

26015: PJI_PA_PROJ_EVENTS_LOG log,
26016: PJI_PJP_WBS_HEADER wbs_hdr,
26017: PJI_XBS_DENORM_DELTA wbs,
26018: PJI_XBS_DENORM prg,
26019: PJI_AC_XBS_ACCUM_F acr,
26020: (
26021: select 1 WBS_SUP_LEVEL,
26022: 1 WBS_SUB_LEVEL,
26023: 'PRJ' INVERT_ID

Line 26601: PJI_AC_XBS_ACCUM_F acr,

26597: PJI_PA_PROJ_EVENTS_LOG log,
26598: PJI_PJP_WBS_HEADER wbs_hdr,
26599: PJI_XBS_DENORM_DELTA wbs,
26600: PJI_XBS_DENORM prg,
26601: PJI_AC_XBS_ACCUM_F acr,
26602: (
26603: select 1 WBS_SUP_LEVEL,
26604: 1 WBS_SUB_LEVEL,
26605: 'PRJ' INVERT_ID

Line 37345: select /+ ordered index(acr PJI_AC_XBS_ACCUM_F_N1) /

37341: sum(pjp.CUSTOM14) CUSTOM14,
37342: sum(pjp.CUSTOM15) CUSTOM15
37343: from
37344: (
37345: select /*+ ordered index(acr PJI_AC_XBS_ACCUM_F_N1) */
37346: -- get structure level amounts from Reporting Lines
37347: prg.SUP_PROJECT_ID,
37348: prg.SUP_ID,
37349: prg.SUP_EMT_ID,

Line 37406: PJI_AC_XBS_ACCUM_F acr

37402: from
37403: PJI_XBS_DENORM_DELTA prg,
37404: PA_PROJ_ELEMENTS prj_emt,
37405: PJI_PJP_WBS_HEADER wbs_hdr,
37406: PJI_AC_XBS_ACCUM_F acr
37407: where
37408: prg.WORKER_ID = p_worker_id and
37409: prg.STRUCT_TYPE = 'PRG' and
37410: prg.RELATIONSHIP_TYPE = 'LF' and

Line 37688: select /+ ordered index(acr PJI_AC_XBS_ACCUM_F_N1) /

37684: sum(pjp.CUSTOM14) CUSTOM14,
37685: sum(pjp.CUSTOM15) CUSTOM15
37686: from
37687: (
37688: select /*+ ordered index(acr PJI_AC_XBS_ACCUM_F_N1) */
37689: -- get structure level amounts from Reporting Lines
37690: prg.SUP_PROJECT_ID,
37691: prg.SUP_ID,
37692: prg.SUP_EMT_ID,

Line 37749: PJI_AC_XBS_ACCUM_F acr

37745: from
37746: PJI_XBS_DENORM_DELTA prg,
37747: PA_PROJ_ELEMENTS prj_emt,
37748: PJI_PJP_WBS_HEADER wbs_hdr,
37749: PJI_AC_XBS_ACCUM_F acr
37750: where
37751: prg.WORKER_ID = p_worker_id and
37752: prg.STRUCT_TYPE = 'PRG' and
37753: prg.RELATIONSHIP_TYPE = 'LF' and

Line 38030: select /+ ordered index(acr PJI_AC_XBS_ACCUM_F_N1) /

38026: sum(pjp.CUSTOM14) CUSTOM14,
38027: sum(pjp.CUSTOM15) CUSTOM15
38028: from
38029: (
38030: select /*+ ordered index(acr PJI_AC_XBS_ACCUM_F_N1) */
38031: -- get structure level amounts from Reporting Lines
38032: prg.SUP_PROJECT_ID,
38033: prg.SUP_ID,
38034: prg.SUP_EMT_ID,

Line 38091: PJI_AC_XBS_ACCUM_F acr

38087: from
38088: PJI_XBS_DENORM_DELTA prg,
38089: PA_PROJ_ELEMENTS prj_emt,
38090: PJI_PJP_WBS_HEADER wbs_hdr,
38091: PJI_AC_XBS_ACCUM_F acr
38092: where
38093: prg.WORKER_ID = p_worker_id and
38094: prg.STRUCT_TYPE = 'PRG' and
38095: prg.RELATIONSHIP_TYPE = 'LF' and

Line 38372: select /+ ordered index(acr PJI_AC_XBS_ACCUM_F_N1) /

38368: sum(pjp.CUSTOM14) CUSTOM14,
38369: sum(pjp.CUSTOM15) CUSTOM15
38370: from
38371: (
38372: select /*+ ordered index(acr PJI_AC_XBS_ACCUM_F_N1) */
38373: -- get structure level amounts from Reporting Lines
38374: prg.SUP_PROJECT_ID,
38375: prg.SUP_ID,
38376: prg.SUP_EMT_ID,

Line 38433: PJI_AC_XBS_ACCUM_F acr

38429: from
38430: PJI_XBS_DENORM_DELTA prg,
38431: PA_PROJ_ELEMENTS prj_emt,
38432: PJI_PJP_WBS_HEADER wbs_hdr,
38433: PJI_AC_XBS_ACCUM_F acr
38434: where
38435: prg.WORKER_ID = p_worker_id and
38436: prg.STRUCT_TYPE = 'PRG' and
38437: prg.RELATIONSHIP_TYPE = 'LF' and

Line 38714: select /+ ordered index(acr PJI_AC_XBS_ACCUM_F_N1) /

38710: sum(pjp.CUSTOM14) CUSTOM14,
38711: sum(pjp.CUSTOM15) CUSTOM15
38712: from
38713: (
38714: select /*+ ordered index(acr PJI_AC_XBS_ACCUM_F_N1) */
38715: -- get structure level amounts from Reporting Lines
38716: prg.SUP_PROJECT_ID,
38717: prg.SUP_ID,
38718: prg.SUP_EMT_ID,

Line 38775: PJI_AC_XBS_ACCUM_F acr

38771: from
38772: PJI_XBS_DENORM_DELTA prg,
38773: PA_PROJ_ELEMENTS prj_emt,
38774: PJI_PJP_WBS_HEADER wbs_hdr,
38775: PJI_AC_XBS_ACCUM_F acr
38776: where
38777: prg.WORKER_ID = p_worker_id and
38778: prg.STRUCT_TYPE = 'PRG' and
38779: prg.RELATIONSHIP_TYPE = 'LF' and

Line 39056: select /+ ordered index(acr PJI_AC_XBS_ACCUM_F_N1) /

39052: sum(pjp.CUSTOM14) CUSTOM14,
39053: sum(pjp.CUSTOM15) CUSTOM15
39054: from
39055: (
39056: select /*+ ordered index(acr PJI_AC_XBS_ACCUM_F_N1) */
39057: -- get structure level amounts from Reporting Lines
39058: prg.SUP_PROJECT_ID,
39059: prg.SUP_ID,
39060: prg.SUP_EMT_ID,

Line 39117: PJI_AC_XBS_ACCUM_F acr

39113: from
39114: PJI_XBS_DENORM_DELTA prg,
39115: PA_PROJ_ELEMENTS prj_emt,
39116: PJI_PJP_WBS_HEADER wbs_hdr,
39117: PJI_AC_XBS_ACCUM_F acr
39118: where
39119: prg.WORKER_ID = p_worker_id and
39120: prg.STRUCT_TYPE = 'PRG' and
39121: prg.RELATIONSHIP_TYPE = 'LF' and

Line 39398: select /+ ordered index(acr PJI_AC_XBS_ACCUM_F_N1) /

39394: sum(pjp.CUSTOM14) CUSTOM14,
39395: sum(pjp.CUSTOM15) CUSTOM15
39396: from
39397: (
39398: select /*+ ordered index(acr PJI_AC_XBS_ACCUM_F_N1) */
39399: -- get structure level amounts from Reporting Lines
39400: prg.SUP_PROJECT_ID,
39401: prg.SUP_ID,
39402: prg.SUP_EMT_ID,

Line 39459: PJI_AC_XBS_ACCUM_F acr

39455: from
39456: PJI_XBS_DENORM_DELTA prg,
39457: PA_PROJ_ELEMENTS prj_emt,
39458: PJI_PJP_WBS_HEADER wbs_hdr,
39459: PJI_AC_XBS_ACCUM_F acr
39460: where
39461: prg.WORKER_ID = p_worker_id and
39462: prg.STRUCT_TYPE = 'PRG' and
39463: prg.RELATIONSHIP_TYPE = 'LF' and

Line 39740: select /+ ordered index(acr PJI_AC_XBS_ACCUM_F_N1) /

39736: sum(pjp.CUSTOM14) CUSTOM14,
39737: sum(pjp.CUSTOM15) CUSTOM15
39738: from
39739: (
39740: select /*+ ordered index(acr PJI_AC_XBS_ACCUM_F_N1) */
39741: -- get structure level amounts from Reporting Lines
39742: prg.SUP_PROJECT_ID,
39743: prg.SUP_ID,
39744: prg.SUP_EMT_ID,

Line 39801: PJI_AC_XBS_ACCUM_F acr

39797: from
39798: PJI_XBS_DENORM_DELTA prg,
39799: PA_PROJ_ELEMENTS prj_emt,
39800: PJI_PJP_WBS_HEADER wbs_hdr,
39801: PJI_AC_XBS_ACCUM_F acr
39802: where
39803: prg.WORKER_ID = p_worker_id and
39804: prg.STRUCT_TYPE = 'PRG' and
39805: prg.RELATIONSHIP_TYPE = 'LF' and

Line 40082: select /+ ordered index(acr PJI_AC_XBS_ACCUM_F_N1) /

40078: sum(pjp.CUSTOM14) CUSTOM14,
40079: sum(pjp.CUSTOM15) CUSTOM15
40080: from
40081: (
40082: select /*+ ordered index(acr PJI_AC_XBS_ACCUM_F_N1) */
40083: -- get structure level amounts from Reporting Lines
40084: prg.SUP_PROJECT_ID,
40085: prg.SUP_ID,
40086: prg.SUP_EMT_ID,

Line 40143: PJI_AC_XBS_ACCUM_F acr

40139: from
40140: PJI_XBS_DENORM_DELTA prg,
40141: PA_PROJ_ELEMENTS prj_emt,
40142: PJI_PJP_WBS_HEADER wbs_hdr,
40143: PJI_AC_XBS_ACCUM_F acr
40144: where
40145: prg.WORKER_ID = p_worker_id and
40146: prg.STRUCT_TYPE = 'PRG' and
40147: prg.RELATIONSHIP_TYPE = 'LF' and

Line 40424: select /+ ordered index(acr PJI_AC_XBS_ACCUM_F_N1) /

40420: sum(pjp.CUSTOM14) CUSTOM14,
40421: sum(pjp.CUSTOM15) CUSTOM15
40422: from
40423: (
40424: select /*+ ordered index(acr PJI_AC_XBS_ACCUM_F_N1) */
40425: -- get structure level amounts from Reporting Lines
40426: prg.SUP_PROJECT_ID,
40427: prg.SUP_ID,
40428: prg.SUP_EMT_ID,

Line 40485: PJI_AC_XBS_ACCUM_F acr

40481: from
40482: PJI_XBS_DENORM_DELTA prg,
40483: PA_PROJ_ELEMENTS prj_emt,
40484: PJI_PJP_WBS_HEADER wbs_hdr,
40485: PJI_AC_XBS_ACCUM_F acr
40486: where
40487: prg.WORKER_ID = p_worker_id and
40488: prg.STRUCT_TYPE = 'PRG' and
40489: prg.RELATIONSHIP_TYPE = 'LF' and