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.

[Home] [Help]

APPS.PJI_PJP_SUM_MAIN dependencies on PA_RBS_PRJ_ASSIGNMENTS

Line 3459: index(rbs_asg, PA_RBS_PRJ_ASSIGNMENTS_N1) */

3455: PROJECT_ACTIVE_FLAG
3456: )
3457: select /*+ ordered
3458: index(log, PA_PJI_PROJ_EVENTS_LOG_N1)
3459: index(rbs_asg, PA_RBS_PRJ_ASSIGNMENTS_N1) */
3460: distinct
3461: p_worker_id,
3462: rbs_asg.PROJECT_ID,
3463: null PJI_PROJECT_STATUS,

Line 3479: PA_RBS_PRJ_ASSIGNMENTS rbs_asg,

3475: /* decode(active_projects.PROJECT_ID,
3476: null, 'N', 'Y') PROJECT_ACTIVE_FLAG */
3477: from
3478: PA_PJI_PROJ_EVENTS_LOG log,
3479: PA_RBS_PRJ_ASSIGNMENTS rbs_asg,
3480: PA_PROJECTS_ALL prj,
3481: PA_PROJECT_TYPES_ALL pt /*,
3482: ( Processing is now not depending on status Bug 5057835
3483: select /*+ ordered

Line 3534: index(rbs_asg, PA_RBS_PRJ_ASSIGNMENTS_N1) */

3530: PROJECT_ACTIVE_FLAG
3531: )
3532: select /*+ ordered
3533: index(log, PA_PJI_PROJ_EVENTS_LOG_N1)
3534: index(rbs_asg, PA_RBS_PRJ_ASSIGNMENTS_N1) */
3535: distinct
3536: p_worker_id,
3537: prj.PROJECT_ID,
3538: null PJI_PROJECT_STATUS,