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_MAIN dependencies on PA_RBS_PRJ_ASSIGNMENTS

Line 3315: index(rbs_asg, PA_RBS_PRJ_ASSIGNMENTS_N1) */

3311: PROJECT_ACTIVE_FLAG
3312: )
3313: select /*+ ordered
3314: index(log, PA_PJI_PROJ_EVENTS_LOG_N1)
3315: index(rbs_asg, PA_RBS_PRJ_ASSIGNMENTS_N1) */
3316: distinct
3317: p_worker_id,
3318: rbs_asg.PROJECT_ID,
3319: null PJI_PROJECT_STATUS,

Line 3335: PA_RBS_PRJ_ASSIGNMENTS rbs_asg,

3331: /* decode(active_projects.PROJECT_ID,
3332: null, 'N', 'Y') PROJECT_ACTIVE_FLAG */
3333: from
3334: PA_PJI_PROJ_EVENTS_LOG log,
3335: PA_RBS_PRJ_ASSIGNMENTS rbs_asg,
3336: PA_PROJECTS_ALL prj,
3337: PA_PROJECT_TYPES_ALL pt /*,
3338: ( Processing is now not depending on status Bug 5057835
3339: select /*+ ordered