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_PRG_PERF_ALL dependencies on PJI_XBS_DENORM_DELTA

Line 635: ,p_tabname => 'PJI_XBS_DENORM_DELTA'

631: ,p_partname => 'P'||g_worker_id
632: ,p_percent => 10);
633:
634: GATHER_TEMP_STATS(p_ownname => l_pji_schema
635: ,p_tabname => 'PJI_XBS_DENORM_DELTA'
636: ,p_partname => 'P'||g_worker_id
637: ,p_percent => 10);
638:
639: GATHER_TEMP_STATS(p_ownname => l_pji_schema

Line 7943: PJI_XBS_DENORM_DELTA wbs,

7939: wbs.SIGN * fpr.CUSTOM15 CUSTOM15
7940: from
7941: PJI_PA_PROJ_EVENTS_LOG log,
7942: PJI_PJP_WBS_HEADER wbs_hdr,
7943: PJI_XBS_DENORM_DELTA wbs,
7944: PJI_XBS_DENORM prg,
7945: PJI_FP_XBS_ACCUM_F fpr,
7946: (
7947: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID

Line 8039: PJI_XBS_DENORM_DELTA prg_delta

8035: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
8036: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all
8037: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual
8038: ) invert,
8039: PJI_XBS_DENORM_DELTA prg_delta
8040: where
8041: prg.STRUCT_TYPE = 'PRG' and
8042: prg.SUB_ROLLUP_ID is not null and
8043: prg.SUB_LEVEL = l_level and

Line 9437: PJI_XBS_DENORM_DELTA wbs,

9433: wbs.SIGN * fpr.CUSTOM15 CUSTOM15
9434: from
9435: PJI_PA_PROJ_EVENTS_LOG log,
9436: PJI_PJP_WBS_HEADER wbs_hdr,
9437: PJI_XBS_DENORM_DELTA wbs,
9438: PJI_XBS_DENORM prg,
9439: PJI_FP_XBS_ACCUM_F fpr,
9440: (
9441: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID

Line 9533: PJI_XBS_DENORM_DELTA prg_delta

9529: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
9530: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all
9531: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual
9532: ) invert,
9533: PJI_XBS_DENORM_DELTA prg_delta
9534: where
9535: prg.STRUCT_TYPE = 'PRG' and
9536: prg.SUB_ROLLUP_ID is not null and
9537: prg.SUB_LEVEL = l_level and

Line 10931: PJI_XBS_DENORM_DELTA wbs,

10927: wbs.SIGN * fpr.CUSTOM15 CUSTOM15
10928: from
10929: PJI_PA_PROJ_EVENTS_LOG log,
10930: PJI_PJP_WBS_HEADER wbs_hdr,
10931: PJI_XBS_DENORM_DELTA wbs,
10932: PJI_XBS_DENORM prg,
10933: PJI_FP_XBS_ACCUM_F fpr,
10934: (
10935: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID

Line 11027: PJI_XBS_DENORM_DELTA prg_delta

11023: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
11024: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all
11025: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual
11026: ) invert,
11027: PJI_XBS_DENORM_DELTA prg_delta
11028: where
11029: prg.STRUCT_TYPE = 'PRG' and
11030: prg.SUB_ROLLUP_ID is not null and
11031: prg.SUB_LEVEL = l_level and

Line 12424: PJI_XBS_DENORM_DELTA wbs,

12420: wbs.SIGN * fpr.CUSTOM15 CUSTOM15
12421: from
12422: PJI_PA_PROJ_EVENTS_LOG log,
12423: PJI_PJP_WBS_HEADER wbs_hdr,
12424: PJI_XBS_DENORM_DELTA wbs,
12425: PJI_XBS_DENORM prg,
12426: PJI_FP_XBS_ACCUM_F fpr,
12427: (
12428: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID

Line 12520: PJI_XBS_DENORM_DELTA prg_delta

12516: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
12517: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all
12518: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual
12519: ) invert,
12520: PJI_XBS_DENORM_DELTA prg_delta
12521: where
12522: prg.STRUCT_TYPE = 'PRG' and
12523: prg.SUB_ROLLUP_ID is not null and
12524: prg.SUB_LEVEL = l_level and

Line 13918: PJI_XBS_DENORM_DELTA wbs,

13914: wbs.SIGN * fpr.CUSTOM15 CUSTOM15
13915: from
13916: PJI_PA_PROJ_EVENTS_LOG log,
13917: PJI_PJP_WBS_HEADER wbs_hdr,
13918: PJI_XBS_DENORM_DELTA wbs,
13919: PJI_XBS_DENORM prg,
13920: PJI_FP_XBS_ACCUM_F fpr,
13921: (
13922: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID

Line 14014: PJI_XBS_DENORM_DELTA prg_delta

14010: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
14011: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all
14012: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual
14013: ) invert,
14014: PJI_XBS_DENORM_DELTA prg_delta
14015: where
14016: prg.STRUCT_TYPE = 'PRG' and
14017: prg.SUB_ROLLUP_ID is not null and
14018: prg.SUB_LEVEL = l_level and

Line 15411: PJI_XBS_DENORM_DELTA wbs,

15407: wbs.SIGN * fpr.CUSTOM15 CUSTOM15
15408: from
15409: PJI_PA_PROJ_EVENTS_LOG log,
15410: PJI_PJP_WBS_HEADER wbs_hdr,
15411: PJI_XBS_DENORM_DELTA wbs,
15412: PJI_XBS_DENORM prg,
15413: PJI_FP_XBS_ACCUM_F fpr,
15414: (
15415: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID

Line 15507: PJI_XBS_DENORM_DELTA prg_delta

15503: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
15504: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all
15505: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual
15506: ) invert,
15507: PJI_XBS_DENORM_DELTA prg_delta
15508: where
15509: prg.STRUCT_TYPE = 'PRG' and
15510: prg.SUB_ROLLUP_ID is not null and
15511: prg.SUB_LEVEL = l_level and

Line 16904: PJI_XBS_DENORM_DELTA wbs,

16900: wbs.SIGN * fpr.CUSTOM15 CUSTOM15
16901: from
16902: PJI_PA_PROJ_EVENTS_LOG log,
16903: PJI_PJP_WBS_HEADER wbs_hdr,
16904: PJI_XBS_DENORM_DELTA wbs,
16905: PJI_XBS_DENORM prg,
16906: PJI_FP_XBS_ACCUM_F fpr,
16907: (
16908: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID

Line 17000: PJI_XBS_DENORM_DELTA prg_delta

16996: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
16997: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all
16998: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual
16999: ) invert,
17000: PJI_XBS_DENORM_DELTA prg_delta
17001: where
17002: prg.STRUCT_TYPE = 'PRG' and
17003: prg.SUB_ROLLUP_ID is not null and
17004: prg.SUB_LEVEL = l_level and

Line 18398: PJI_XBS_DENORM_DELTA wbs,

18394: wbs.SIGN * fpr.CUSTOM15 CUSTOM15
18395: from
18396: PJI_PA_PROJ_EVENTS_LOG log,
18397: PJI_PJP_WBS_HEADER wbs_hdr,
18398: PJI_XBS_DENORM_DELTA wbs,
18399: PJI_XBS_DENORM prg,
18400: PJI_FP_XBS_ACCUM_F fpr,
18401: (
18402: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID

Line 18494: PJI_XBS_DENORM_DELTA prg_delta

18490: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
18491: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all
18492: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual
18493: ) invert,
18494: PJI_XBS_DENORM_DELTA prg_delta
18495: where
18496: prg.STRUCT_TYPE = 'PRG' and
18497: prg.SUB_ROLLUP_ID is not null and
18498: prg.SUB_LEVEL = l_level and

Line 19892: PJI_XBS_DENORM_DELTA wbs,

19888: wbs.SIGN * fpr.CUSTOM15 CUSTOM15
19889: from
19890: PJI_PA_PROJ_EVENTS_LOG log,
19891: PJI_PJP_WBS_HEADER wbs_hdr,
19892: PJI_XBS_DENORM_DELTA wbs,
19893: PJI_XBS_DENORM prg,
19894: PJI_FP_XBS_ACCUM_F fpr,
19895: (
19896: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID

Line 19988: PJI_XBS_DENORM_DELTA prg_delta

19984: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
19985: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all
19986: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual
19987: ) invert,
19988: PJI_XBS_DENORM_DELTA prg_delta
19989: where
19990: prg.STRUCT_TYPE = 'PRG' and
19991: prg.SUB_ROLLUP_ID is not null and
19992: prg.SUB_LEVEL = l_level and

Line 21386: PJI_XBS_DENORM_DELTA wbs,

21382: wbs.SIGN * fpr.CUSTOM15 CUSTOM15
21383: from
21384: PJI_PA_PROJ_EVENTS_LOG log,
21385: PJI_PJP_WBS_HEADER wbs_hdr,
21386: PJI_XBS_DENORM_DELTA wbs,
21387: PJI_XBS_DENORM prg,
21388: PJI_FP_XBS_ACCUM_F fpr,
21389: (
21390: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID

Line 21482: PJI_XBS_DENORM_DELTA prg_delta

21478: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
21479: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all
21480: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual
21481: ) invert,
21482: PJI_XBS_DENORM_DELTA prg_delta
21483: where
21484: prg.STRUCT_TYPE = 'PRG' and
21485: prg.SUB_ROLLUP_ID is not null and
21486: prg.SUB_LEVEL = l_level and