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_XBS_ACCUM_F

Line 1738: from PJI_FP_XBS_ACCUM_F

1734:
1735: if (l_extraction_type = 'INCREMENTAL') then
1736:
1737: delete
1738: from PJI_FP_XBS_ACCUM_F
1739: where (RBS_AGGR_LEVEL,
1740: WBS_ROLLUP_FLAG,
1741: PRG_ROLLUP_FLAG) in (('L', 'Y', 'N'),
1742: ('R', 'N', 'N'),

Line 1792: from PJI_FP_XBS_ACCUM_F

1788: log.EVENT_TYPE in ('RBS_PUSH',
1789: 'RBS_DELETE'));
1790:
1791: delete
1792: from PJI_FP_XBS_ACCUM_F
1793: where RBS_AGGR_LEVEL in ('L', 'R') and
1794: (PROJECT_ID,
1795: PLAN_VERSION_ID,
1796: RBS_VERSION_ID) in (select distinct

Line 5660: PJI_FP_XBS_ACCUM_F fpr

5656: to_number(null) CUSTOM14,
5657: to_number(null) CUSTOM15
5658: from
5659: PJI_PJP_PROJ_BATCH_MAP map,
5660: PJI_FP_XBS_ACCUM_F fpr
5661: where
5662: l_extraction_type = 'INCREMENTAL' and
5663: map.WORKER_ID = p_worker_id and
5664: map.EXTRACTION_TYPE = 'M' and

Line 5751: PJI_FP_XBS_ACCUM_F fpr

5747: - fpr.CUSTOM14 CUSTOM14,
5748: - fpr.CUSTOM15 CUSTOM15
5749: from
5750: PJI_FM_EXTR_PLNVER3_T map,
5751: PJI_FP_XBS_ACCUM_F fpr
5752: where
5753: l_extraction_type = 'PARTIAL' and
5754: map.WORKER_ID = p_worker_id and
5755: fpr.PROJECT_ID = map.PROJECT_ID and

Line 8678: index(fpr PJI_FP_XBS_ACCUM_F_N1) */

8674: wbs_hdr.CB_FLAG = fin_plan.CB_FLAG (+) and
8675: wbs_hdr.CO_FLAG = fin_plan.CO_FLAG (+)
8676: union all
8677: select /*+ ordered
8678: index(fpr PJI_FP_XBS_ACCUM_F_N1) */
8679: -- get delta task level amounts from Reporting Lines
8680: to_char(null) LINE_TYPE,
8681: wbs_hdr.WBS_VERSION_ID,
8682: decode(wbs_hdr.WP_FLAG, 'Y', 'LW', 'LF') RELATIONSHIP_TYPE,

Line 8780: PJI_FP_XBS_ACCUM_F fpr,

8776: PJI_PA_PROJ_EVENTS_LOG log,
8777: PJI_PJP_WBS_HEADER wbs_hdr,
8778: PJI_XBS_DENORM_DELTA wbs,
8779: PJI_XBS_DENORM prg,
8780: PJI_FP_XBS_ACCUM_F fpr,
8781: (
8782: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
8783: from DUAL union all
8784: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID

Line 9985: index(fpr PJI_FP_XBS_ACCUM_F_N1) */

9981: wbs_hdr.CO_FLAG = fin_plan.CO_FLAG (+)
9982: union all
9983: select /*+ ordered
9984: index(log PA_PJI_PROJ_EVENTS_LOG_N2)
9985: index(fpr PJI_FP_XBS_ACCUM_F_N1) */
9986: -- get delta task level amounts from Reporting Lines
9987: to_char(null) LINE_TYPE,
9988: wbs_hdr.WBS_VERSION_ID,
9989: decode(wbs_hdr.WP_FLAG, 'Y', 'LW', 'LF') RELATIONSHIP_TYPE,

Line 10087: PJI_FP_XBS_ACCUM_F fpr,

10083: PA_PJI_PROJ_EVENTS_LOG log,
10084: PJI_PJP_WBS_HEADER wbs_hdr,
10085: PJI_XBS_DENORM_DELTA_T wbs,
10086: PJI_XBS_DENORM prg,
10087: PJI_FP_XBS_ACCUM_F fpr,
10088: (
10089: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
10090: from DUAL union all
10091: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID

Line 10158: index(fpr PJI_FP_XBS_ACCUM_F_N1) */

10154: wbs.SUB_LEVEL = 1))
10155: union all
10156: select /*+ ordered
10157: index(log PA_PJI_PROJ_EVENTS_LOG_N2)
10158: index(fpr PJI_FP_XBS_ACCUM_F_N1) */
10159: -- Baseline reversals and fact amounts (-3 slice)
10160: -- Current Original reversals and fact amounts (-4 slice)
10161: -- Part 1
10162: to_char(null) LINE_TYPE,

Line 10516: PJI_FP_XBS_ACCUM_F fpr,

10512: PA_PJI_PROJ_EVENTS_LOG log,
10513: PJI_PJP_WBS_HEADER wbs_hdr,
10514: -- Changes done for bug 7354982.
10515: --PJI_XBS_DENORM prg,
10516: PJI_FP_XBS_ACCUM_F fpr,
10517: PJI_XBS_DENORM prg
10518: where
10519: prg.STRUCT_TYPE = 'PRG' and
10520: prg.SUP_LEVEL = l_level and

Line 10552: index(fpr PJI_FP_XBS_ACCUM_F_N1) */

10548: prg.struct_version_id is NULL -- added for bug 5882260
10549: union all
10550: select /*+ ordered
10551: index(log PA_PJI_PROJ_EVENTS_LOG_N2)
10552: index(fpr PJI_FP_XBS_ACCUM_F_N1) */
10553: -- Baseline reversals and fact amounts (-3 slice)
10554: -- Current Original reversals and fact amounts (-4 slice)
10555: -- Part 2
10556: to_char(null) LINE_TYPE,

Line 10910: PJI_FP_XBS_ACCUM_F fpr,

10906: PA_PJI_PROJ_EVENTS_LOG log,
10907: PJI_PJP_WBS_HEADER wbs_hdr,
10908: -- Changes done for bug 7354982.
10909: --PJI_XBS_DENORM prg,
10910: PJI_FP_XBS_ACCUM_F fpr,
10911: PJI_XBS_DENORM prg
10912: where
10913: prg.STRUCT_TYPE = 'PRG' and
10914: prg.SUP_LEVEL = l_level and

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

13687: sum(pjp.CUSTOM14) CUSTOM14,
13688: sum(pjp.CUSTOM15) CUSTOM15
13689: from
13690: (
13691: select /*+ ordered index(fpr PJI_FP_XBS_ACCUM_F_N1) */
13692: -- get structure level amounts from Reporting Lines
13693: decode(fpr.RBS_AGGR_LEVEL,
13694: 'L', 'DO_NOT_ROLLUP',
13695: 'WBS') STRUCT_TYPE,

Line 14011: PJI_FP_XBS_ACCUM_F fpr,

14007: from
14008: PJI_XBS_DENORM_DELTA prg,
14009: PA_PROJ_ELEMENTS prj_emt,
14010: PJI_PJP_WBS_HEADER wbs_hdr,
14011: PJI_FP_XBS_ACCUM_F fpr,
14012: PJI_PJP_WBS_HEADER sup_wbs_hdr,
14013: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
14014: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,
14015: (