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_SUM_ROLLUP dependencies on PJI_FP_AGGR_PJP1

Line 5270: insert into PJI_FP_AGGR_PJP1 pjp1_i

5266:
5267: end if; -- Partial Refresh Performance Improvement
5268:
5269:
5270: insert into PJI_FP_AGGR_PJP1 pjp1_i
5271: (
5272: WORKER_ID,
5273: RECORD_TYPE,
5274: PRG_LEVEL,

Line 7163: insert into PJI_FP_AGGR_PJP1 pjp1_i

7159: end if;
7160:
7161: l_extraction_type := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process, 'EXTRACTION_TYPE');
7162:
7163: insert into PJI_FP_AGGR_PJP1 pjp1_i
7164: (
7165: WORKER_ID,
7166: RECORD_TYPE,
7167: PRG_LEVEL,

Line 7469: PJI_FP_AGGR_PJP1 pjp1,

7465: sum(pjp1.CUSTOM13) CUSTOM13,
7466: sum(pjp1.CUSTOM14) CUSTOM14,
7467: sum(pjp1.CUSTOM15) CUSTOM15
7468: from
7469: PJI_FP_AGGR_PJP1 pjp1,
7470: (
7471: select
7472: distinct
7473: to_number(log.EVENT_OBJECT) RBS_VERSION_ID,

Line 7686: insert into PJI_FP_AGGR_PJP1

7682: STEP_SEQ = l_level_seq;
7683:
7684: -- rollup project hiearchy
7685:
7686: insert into PJI_FP_AGGR_PJP1
7687: (
7688: WORKER_ID,
7689: RECORD_TYPE,
7690: PRG_LEVEL,

Line 8471: PJI_FP_AGGR_PJP1 pjp1,

8467: pjp1.CUSTOM13,
8468: pjp1.CUSTOM14,
8469: pjp1.CUSTOM15
8470: from
8471: PJI_FP_AGGR_PJP1 pjp1,
8472: PJI_PJP_WBS_HEADER wbs_hdr,
8473: PA_XBS_DENORM wbs,
8474: PJI_XBS_DENORM prg,
8475: (

Line 8625: PJI_FP_AGGR_PJP1 pjp1,

8621: pjp1.CUSTOM13,
8622: pjp1.CUSTOM14,
8623: pjp1.CUSTOM15
8624: from
8625: PJI_FP_AGGR_PJP1 pjp1,
8626: PJI_PJP_WBS_HEADER wbs_hdr,
8627: PJI_XBS_DENORM prg,
8628: (
8629: select 'Y' CB_FLAG,

Line 9052: insert into PJI_FP_AGGR_PJP1_T

9048: while (l_level > 0) loop
9049:
9050: -- rollup project hiearchy
9051:
9052: insert into PJI_FP_AGGR_PJP1_T
9053: (
9054: WORKER_ID,
9055: RECORD_TYPE,
9056: PRG_LEVEL,

Line 9777: PJI_FP_AGGR_PJP1_T pjp1,

9773: pjp1.CUSTOM13,
9774: pjp1.CUSTOM14,
9775: pjp1.CUSTOM15
9776: from
9777: PJI_FP_AGGR_PJP1_T pjp1,
9778: PJI_PJP_WBS_HEADER wbs_hdr,
9779: PA_XBS_DENORM wbs,
9780: PJI_XBS_DENORM prg,
9781: (

Line 9931: PJI_FP_AGGR_PJP1_T pjp1,

9927: pjp1.CUSTOM13,
9928: pjp1.CUSTOM14,
9929: pjp1.CUSTOM15
9930: from
9931: PJI_FP_AGGR_PJP1_T pjp1,
9932: PJI_PJP_WBS_HEADER wbs_hdr,
9933: PJI_XBS_DENORM prg,
9934: (
9935: select 'Y' CB_FLAG,

Line 11119: insert into PJI_FP_AGGR_PJP1 pjp1_i

11115: end if;
11116:
11117: l_extraction_type := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process, 'EXTRACTION_TYPE');
11118:
11119: insert into PJI_FP_AGGR_PJP1 pjp1_i
11120: (
11121: WORKER_ID,
11122: RECORD_TYPE,
11123: PRG_LEVEL,

Line 11440: PJI_FP_AGGR_PJP1 pjp1,

11436: sum(pjp1.CUSTOM13) CUSTOM13,
11437: sum(pjp1.CUSTOM14) CUSTOM14,
11438: sum(pjp1.CUSTOM15) CUSTOM15
11439: from
11440: PJI_FP_AGGR_PJP1 pjp1,
11441: PJI_ROLLUP_LEVEL_STATUS ss,
11442: PJI_PJP_RBS_HEADER rbs_hdr,
11443: PJI_PJP_WBS_HEADER wbs_hdr,
11444: PA_RBS_DENORM rbs

Line 11573: insert into PJI_FP_AGGR_PJP1_T pjp1_i

11569: commit;
11570:
11571: else -- online mode
11572:
11573: insert into PJI_FP_AGGR_PJP1_T pjp1_i
11574: (
11575: WORKER_ID,
11576: RECORD_TYPE,
11577: PRG_LEVEL,

Line 11895: PJI_FP_AGGR_PJP1_T pjp1,

11891: sum(pjp1.CUSTOM13) CUSTOM13,
11892: sum(pjp1.CUSTOM14) CUSTOM14,
11893: sum(pjp1.CUSTOM15) CUSTOM15
11894: from
11895: PJI_FP_AGGR_PJP1_T pjp1,
11896: PJI_ROLLUP_LEVEL_STATUS ss,
11897: PJI_PJP_RBS_HEADER rbs_hdr,
11898: PJI_PJP_WBS_HEADER wbs_hdr,
11899: PA_RBS_DENORM rbs

Line 13525: insert into PJI_FP_AGGR_PJP1 pjp1_i

13521: STEP_SEQ = l_level_seq;
13522:
13523: -- rollup project hiearchy
13524:
13525: insert into PJI_FP_AGGR_PJP1 pjp1_i
13526: (
13527: WORKER_ID,
13528: RECORD_TYPE,
13529: PRG_LEVEL,

Line 14408: PJI_FP_AGGR_PJP1 pjp1,

14404: pjp1.CUSTOM13,
14405: pjp1.CUSTOM14,
14406: pjp1.CUSTOM15
14407: from
14408: PJI_FP_AGGR_PJP1 pjp1,
14409: PJI_PJP_WBS_HEADER wbs_hdr,
14410: PA_PROJ_ELEMENTS prj_emt,
14411: PA_XBS_DENORM prg,
14412: PJI_XBS_DENORM_DELTA prg_delta,

Line 15510: insert into PJI_FP_AGGR_PJP1 pjp1_i

15506: l_extraction_type := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process, 'EXTRACTION_TYPE');
15507:
15508: IF (l_extraction_type IN ('PARTIAL', 'RBS', 'INCREMENTAL', 'FULL')) THEN
15509:
15510: insert into PJI_FP_AGGR_PJP1 pjp1_i
15511: (
15512: WORKER_ID,
15513: RECORD_TYPE,
15514: PRG_LEVEL,

Line 15665: PJI_FP_AGGR_PJP1 pjp1

15661: sum(pjp1.CUSTOM13) CUSTOM13,
15662: sum(pjp1.CUSTOM14) CUSTOM14,
15663: sum(pjp1.CUSTOM15) CUSTOM15
15664: from
15665: PJI_FP_AGGR_PJP1 pjp1
15666: where
15667: pjp1.WORKER_ID = p_worker_id
15668: group by
15669: pjp1.WORKER_ID,

Line 15960: from PJI_FP_AGGR_PJP1 pjp1

15956:
15957: IF (l_extraction_type IN ('PARTIAL', 'RBS', 'INCREMENTAL', 'FULL')) THEN
15958:
15959: delete
15960: from PJI_FP_AGGR_PJP1 pjp1
15961: where pjp1.WORKER_ID = p_worker_id and
15962: nvl(pjp1.LINE_TYPE, 'X') <> 'AGGR_PLAN';
15963:
15964: delete

Line 17347: from PJI_FP_AGGR_PJP1

17343: where WORKER_ID = p_worker_id and
17344: PJI_PROJECT_STATUS is null and
17345: PROJECT_ID in (select distinct
17346: PROJECT_ID
17347: from PJI_FP_AGGR_PJP1
17348: where WORKER_ID = p_worker_id
17349: and PLAN_VERSION_ID = -1);
17350:
17351: end if;

Line 18020: 'PJI_FP_AGGR_PJP1',

18016: 'PARTITION',
18017: 'P' || p_worker_id);
18018:
18019: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(l_schema,
18020: 'PJI_FP_AGGR_PJP1',
18021: 'PARTITION',
18022: 'P' || p_worker_id);
18023:
18024: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(l_schema,

Line 18071: delete from PJI_FP_AGGR_PJP1_T;

18067: else -- online mode
18068:
18069: delete from PJI_XBS_DENORM_DELTA_T;
18070:
18071: delete from PJI_FP_AGGR_PJP1_T;
18072:
18073: delete from PJI_AC_AGGR_PJP1_T;
18074:
18075: end if;