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 PA_PJI_PROJ_EVENTS_LOG

Line 3027: select /+ ordered index(log PA_PJI_PROJ_EVENTS_LOG_N1) use_hash(log) / /* Modified for Bug 7669026 */

3023: -- -----------------------------------------------------
3024: procedure CREATE_EVENTS_SNAPSHOT (p_worker_id in number) is
3025:
3026: cursor events (p_worker_id in number) is
3027: select /*+ ordered index(log PA_PJI_PROJ_EVENTS_LOG_N1) use_hash(log) */ /* Modified for Bug 7669026 */
3028: distinct
3029: log.ROWID LOG_ROWID,
3030: log.EVENT_TYPE,
3031: log.EVENT_ID,

Line 3061: PA_PJI_PROJ_EVENTS_LOG log,

3057: log.ATTRIBUTE19,
3058: log.ATTRIBUTE20
3059: from
3060: PJI_PJP_PROJ_BATCH_MAP map,
3061: PA_PJI_PROJ_EVENTS_LOG log,
3062: PA_RBS_VERSIONS_B ver
3063: where
3064: map.WORKER_ID = p_worker_id and
3065: log.EVENT_TYPE in (-- 'WBS_CHANGE', -- disable bulk processing

Line 3072: select /+ ordered index(log PA_PJI_PROJ_EVENTS_LOG_N1) use_hash(log) / /* Modified for Bug 7669026 */

3068: 'RBS_PRG') and
3069: log.ATTRIBUTE1 = map.PROJECT_ID and
3070: log.EVENT_OBJECT = ver.RBS_VERSION_ID (+)
3071: union all
3072: select /*+ ordered index(log PA_PJI_PROJ_EVENTS_LOG_N1) use_hash(log) */ /* Modified for Bug 7669026 */
3073: distinct
3074: log.ROWID LOG_ROWID,
3075: log.EVENT_TYPE,
3076: log.EVENT_ID,

Line 3103: PA_PJI_PROJ_EVENTS_LOG log

3099: log.ATTRIBUTE19,
3100: log.ATTRIBUTE20
3101: from
3102: PJI_PJP_PROJ_BATCH_MAP map,
3103: PA_PJI_PROJ_EVENTS_LOG log
3104: where
3105: map.WORKER_ID = p_worker_id and
3106: log.EVENT_TYPE = 'PRG_CHANGE' and
3107: log.EVENT_OBJECT = -1 and

Line 3111: select /+ index(log PA_PJI_PROJ_EVENTS_LOG_N1) /

3107: log.EVENT_OBJECT = -1 and
3108: log.ATTRIBUTE1 = map.PROJECT_ID;
3109:
3110: cursor prg_change_events (p_worker_id in number) is
3111: select /*+ index(log PA_PJI_PROJ_EVENTS_LOG_N1) */
3112: log.ROWID LOG_ROWID,
3113: log.EVENT_TYPE,
3114: log.EVENT_ID,
3115: log.EVENT_OBJECT,

Line 3140: PA_PJI_PROJ_EVENTS_LOG log,

3136: log.ATTRIBUTE18,
3137: log.ATTRIBUTE19,
3138: log.ATTRIBUTE20
3139: from
3140: PA_PJI_PROJ_EVENTS_LOG log,
3141: (
3142: select /*+ ordered index(ver PA_PROJ_ELEMENT_VERSIONS_N3) */
3143: distinct
3144: ver.PRG_GROUP

Line 3160: select /+ index(log PA_PJI_PROJ_EVENTS_LOG_N1) /

3156: map.PRG_GROUP in (log.EVENT_OBJECT, log.ATTRIBUTE1);
3157:
3158: cursor rbs_push_events (p_worker_id in number,
3159: p_rbs_header_id in number) is
3160: select /*+ index(log PA_PJI_PROJ_EVENTS_LOG_N1) */
3161: distinct
3162: log.ROWID LOG_ROWID,
3163: log.EVENT_TYPE,
3164: log.EVENT_ID,

Line 3191: PA_PJI_PROJ_EVENTS_LOG log,

3187: log.ATTRIBUTE19, -- project id
3188: ver.RBS_HEADER_ID ATTRIBUTE20, -- rbs header
3189: log.pjt_rollup_flag -- OLAP
3190: from
3191: PA_PJI_PROJ_EVENTS_LOG log,
3192: (
3193: select
3194: distinct
3195: asg.RBS_HEADER_ID,

Line 3214: PA_PJI_PROJ_EVENTS_LOG log

3210: from
3211: PJI_PJP_PROJ_BATCH_MAP map,
3212: PA_PROJECTS_ALL prj,
3213: PA_RBS_VERSIONS_B rbs,
3214: PA_PJI_PROJ_EVENTS_LOG log
3215: where
3216: map.WORKER_ID = p_worker_id and
3217: prj.PROJECT_ID = map.PROJECT_ID and
3218: log.EVENT_TYPE = 'RBS_PUSH' and

Line 3228: select /+ index(log PA_PJI_PROJ_EVENTS_LOG_N1) /

3224: ver.RBS_VERSION_ID in (log.EVENT_OBJECT, log.ATTRIBUTE2);
3225:
3226: cursor rbs_delete_events (p_worker_id in number,
3227: p_rbs_header_id in number) is
3228: select /*+ index(log PA_PJI_PROJ_EVENTS_LOG_N1) */
3229: distinct
3230: log.ROWID LOG_ROWID,
3231: log.EVENT_TYPE,
3232: log.EVENT_ID,

Line 3260: PA_PJI_PROJ_EVENTS_LOG log

3256: log.ATTRIBUTE20
3257: from
3258: PJI_PJP_PROJ_BATCH_MAP map,
3259: PA_RBS_PRJ_ASSIGNMENTS asg,
3260: PA_PJI_PROJ_EVENTS_LOG log
3261: where
3262: map.WORKER_ID = p_worker_id and
3263: asg.PROJECT_ID = map.PROJECT_ID and
3264: asg.RBS_HEADER_ID = nvl(p_rbs_header_id,

Line 3337: select /*+ ordered index(log PA_PJI_PROJ_EVENTS_LOG_N1)

3333: ATTRIBUTE18,
3334: ATTRIBUTE19,
3335: ATTRIBUTE20
3336: )
3337: select /*+ ordered index(log PA_PJI_PROJ_EVENTS_LOG_N1)
3338: use_hash(log)
3339: use_hash(map) */
3340: p_worker_id,
3341: log.ROWID,

Line 3369: PA_PJI_PROJ_EVENTS_LOG log,

3365: log.ATTRIBUTE18,
3366: log.ATTRIBUTE19,
3367: log.ATTRIBUTE20
3368: from
3369: PA_PJI_PROJ_EVENTS_LOG log,
3370: PJI_PJP_PROJ_BATCH_MAP map
3371: where
3372: map.WORKER_ID = p_worker_id and
3373: log.EVENT_TYPE = 'PRG_CHANGE' and

Line 3378: from PA_PJI_PROJ_EVENTS_LOG

3374: log.EVENT_OBJECT = -1 and
3375: log.ATTRIBUTE1 = map.PROJECT_ID;
3376:
3377: delete
3378: from PA_PJI_PROJ_EVENTS_LOG
3379: where ROWID in (select LOG_ROWID
3380: from PJI_PA_PROJ_EVENTS_LOG
3381: where WORKER_ID = p_worker_id);
3382:

Line 3451: from PA_PJI_PROJ_EVENTS_LOG

3447: c.ATTRIBUTE20
3448: );
3449:
3450: delete
3451: from PA_PJI_PROJ_EVENTS_LOG
3452: where ROWID = c.LOG_ROWID;
3453:
3454: end loop;
3455:

Line 3522: from PA_PJI_PROJ_EVENTS_LOG

3518: c.ATTRIBUTE20
3519: );
3520:
3521: delete
3522: from PA_PJI_PROJ_EVENTS_LOG
3523: where ROWID = c.LOG_ROWID;
3524:
3525: end loop;
3526:

Line 3658: update PA_PJI_PROJ_EVENTS_LOG log

3654: end if;
3655:
3656: --ensure all RBS_ASSOC and RBS_PRG events point to the latest version
3657:
3658: update PA_PJI_PROJ_EVENTS_LOG log
3659: set log.EVENT_OBJECT =
3660: (
3661: select
3662: ver1.RBS_VERSION_ID

Line 3882: from PA_PJI_PROJ_EVENTS_LOG

3878: -- OLAP CHANGES END
3879: end if;
3880:
3881: delete
3882: from PA_PJI_PROJ_EVENTS_LOG
3883: where ROWID = c.LOG_ROWID;
3884:
3885: end loop;
3886:

Line 3955: from PA_PJI_PROJ_EVENTS_LOG

3951: c.ATTRIBUTE20
3952: );
3953:
3954: delete
3955: from PA_PJI_PROJ_EVENTS_LOG
3956: where ROWID = c.LOG_ROWID;
3957:
3958: end loop;
3959:

Line 4756: (select /+ index(log PA_PJI_PROJ_EVENTS_LOG_N1) /

4752: while (SQL%ROWCOUNT > 0) loop
4753:
4754: update PJI_PJP_WBS_HEADER wbs_hdr
4755: set wbs_hdr.WBS_VERSION_ID =
4756: (select /*+ index(log PA_PJI_PROJ_EVENTS_LOG_N1) */
4757: distinct log.ATTRIBUTE2
4758: from PA_PJI_PROJ_EVENTS_LOG log
4759: where log.EVENT_TYPE = 'WBS_PUBLISH' and
4760: log.EVENT_OBJECT = wbs_hdr.WBS_VERSION_ID),

Line 4758: from PA_PJI_PROJ_EVENTS_LOG log

4754: update PJI_PJP_WBS_HEADER wbs_hdr
4755: set wbs_hdr.WBS_VERSION_ID =
4756: (select /*+ index(log PA_PJI_PROJ_EVENTS_LOG_N1) */
4757: distinct log.ATTRIBUTE2
4758: from PA_PJI_PROJ_EVENTS_LOG log
4759: where log.EVENT_TYPE = 'WBS_PUBLISH' and
4760: log.EVENT_OBJECT = wbs_hdr.WBS_VERSION_ID),
4761: wbs_hdr.LAST_UPDATE_DATE = l_last_update_date,
4762: wbs_hdr.LAST_UPDATED_BY = l_last_updated_by,

Line 4771: from PA_PJI_PROJ_EVENTS_LOG log

4767: where map.WORKER_ID = p_worker_id) and
4768: wbs_hdr.PLAN_VERSION_ID = -1 and
4769: wbs_hdr.WBS_VERSION_ID in
4770: (select log.EVENT_OBJECT
4771: from PA_PJI_PROJ_EVENTS_LOG log
4772: where log.EVENT_TYPE = 'WBS_PUBLISH');
4773:
4774: end loop;
4775:

Line 5428: PA_PJI_PROJ_EVENTS_LOG_S.NEXTVAL,

5424: )
5425: select
5426: p_worker_id,
5427: 'PJI_RBS_CHANGE',
5428: PA_PJI_PROJ_EVENTS_LOG_S.NEXTVAL,
5429: c.RBS_VERSION_ID,
5430: 'I',
5431: 'X'
5432: from

Line 5545: PA_PJI_PROJ_EVENTS_LOG_S.NEXTVAL,

5541: )
5542: select
5543: p_worker_id,
5544: 'PJI_RBS_CHANGE',
5545: PA_PJI_PROJ_EVENTS_LOG_S.NEXTVAL,
5546: c.RBS_VERSION_ID,
5547: 'I',
5548: 'X'
5549: from

Line 5622: PA_PJI_PROJ_EVENTS_LOG_S.NEXTVAL,

5618: )
5619: select
5620: p_worker_id,
5621: 'PJI_RBS_CHANGE',
5622: PA_PJI_PROJ_EVENTS_LOG_S.NEXTVAL,
5623: c.RBS_VERSION_ID,
5624: 'I',
5625: 'X'
5626: from

Line 6197: PA_PJI_PROJ_EVENTS_LOG_S.NEXTVAL,

6193: )
6194: select
6195: p_worker_id,
6196: 'PJI_RBS_CHANGE',
6197: PA_PJI_PROJ_EVENTS_LOG_S.NEXTVAL,
6198: c.RBS_VERSION_ID,
6199: 'I',
6200: 'X'
6201: from

Line 12097: index(log PA_PJI_PROJ_EVENTS_LOG_N2)

12093: wbs_hdr.CB_FLAG = fin_plan.CB_FLAG (+) and
12094: wbs_hdr.CO_FLAG = fin_plan.CO_FLAG (+)
12095: union all
12096: select /*+ ordered
12097: index(log PA_PJI_PROJ_EVENTS_LOG_N2)
12098: index(fpr PJI_FP_XBS_ACCUM_F_N1)
12099: index(prg pji_xbs_denorm_n3) */ -- Bug 10632614
12100: -- get delta task level amounts from Reporting Lines
12101: to_char(null) LINE_TYPE,

Line 12197: PA_PJI_PROJ_EVENTS_LOG log,

12193: wbs.SIGN * fpr.CUSTOM13 CUSTOM13,
12194: wbs.SIGN * fpr.CUSTOM14 CUSTOM14,
12195: wbs.SIGN * fpr.CUSTOM15 CUSTOM15
12196: from
12197: PA_PJI_PROJ_EVENTS_LOG log,
12198: PJI_PJP_WBS_HEADER wbs_hdr,
12199: PJI_XBS_DENORM_DELTA_T wbs,
12200: PJI_XBS_DENORM prg,
12201: PJI_FP_XBS_ACCUM_F fpr,

Line 12271: index(log PA_PJI_PROJ_EVENTS_LOG_N2)

12267: (wbs.SUP_LEVEL = 1 and
12268: wbs.SUB_LEVEL = 1))
12269: union all
12270: select /*+ ordered
12271: index(log PA_PJI_PROJ_EVENTS_LOG_N2)
12272: index(fpr PJI_FP_XBS_ACCUM_F_N1)
12273: index(prg pji_xbs_denorm_n3) */ -- Bug 10632614
12274: -- Baseline reversals and fact amounts (-3 slice)
12275: -- Current Original reversals and fact amounts (-4 slice)

Line 12627: PA_PJI_PROJ_EVENTS_LOG log,

12623: -3, -1,
12624: -4, -1)
12625: * fpr.CUSTOM15 CUSTOM15
12626: from
12627: PA_PJI_PROJ_EVENTS_LOG log,
12628: PJI_PJP_WBS_HEADER wbs_hdr,
12629: -- Changes done for bug 7354982.
12630: --PJI_XBS_DENORM prg,
12631: PJI_FP_XBS_ACCUM_F fpr,

Line 12666: index(log PA_PJI_PROJ_EVENTS_LOG_N2)

12662: wbs_hdr.WBS_VERSION_ID = prg.SUP_ID and
12663: prg.struct_version_id is NULL -- added for bug 5882260
12664: union all
12665: select /*+ ordered
12666: index(log PA_PJI_PROJ_EVENTS_LOG_N2)
12667: index(fpr PJI_FP_XBS_ACCUM_F_N1)
12668: index(prg pji_xbs_denorm_n3) */ -- Bug 10632614
12669: -- Baseline reversals and fact amounts (-3 slice)
12670: -- Current Original reversals and fact amounts (-4 slice)

Line 13022: PA_PJI_PROJ_EVENTS_LOG log,

13018: -3, -1,
13019: -4, -1)
13020: * fpr.CUSTOM15 CUSTOM15
13021: from
13022: PA_PJI_PROJ_EVENTS_LOG log,
13023: PJI_PJP_WBS_HEADER wbs_hdr,
13024: -- Changes done for bug 7354982.
13025: --PJI_XBS_DENORM prg,
13026: PJI_FP_XBS_ACCUM_F fpr,

Line 15280: index(log PA_PJI_PROJ_EVENTS_LOG_N2)

15276: wbs_hdr.PLAN_VERSION_ID = -1 and
15277: wbs_hdr.WBS_VERSION_ID = prg.SUP_ID
15278: union all
15279: select /*+ ordered
15280: index(log PA_PJI_PROJ_EVENTS_LOG_N2)
15281: index(fpr PJI_AC_XBR_ACCUM_F_N1) */
15282: -- get delta task level amounts from Reporting Lines
15283: wbs_hdr.WBS_VERSION_ID,
15284: 'LF' RELATIONSHIP_TYPE,

Line 15356: PA_PJI_PROJ_EVENTS_LOG log,

15352: wbs.SIGN * acr.CUSTOM13 CUSTOM13,
15353: wbs.SIGN * acr.CUSTOM14 CUSTOM14,
15354: wbs.SIGN * acr.CUSTOM15 CUSTOM15
15355: from
15356: PA_PJI_PROJ_EVENTS_LOG log,
15357: PJI_PJP_WBS_HEADER wbs_hdr,
15358: PJI_XBS_DENORM_DELTA_T wbs,
15359: PJI_XBS_DENORM prg,
15360: PJI_AC_XBS_ACCUM_F acr,