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_PROJECT_STATUSES

Line 3177: PA_PROJECT_STATUSES proj_status /*,

3173: null, 'N', 'Y') PROJECT_ACTIVE_FLAG */
3174: from
3175: PJI_PJP_PROJ_EXTR_STATUS status,
3176: PA_PROJECTS_ALL prj,
3177: PA_PROJECT_STATUSES proj_status /*,
3178: ( Processing is not depending on Project status Bug 5057835
3179: select
3180: distinct
3181: stat.PROJECT_STATUS_CODE

Line 3183: PA_PROJECT_STATUSES stat

3179: select
3180: distinct
3181: stat.PROJECT_STATUS_CODE
3182: from
3183: PA_PROJECT_STATUSES stat
3184: where
3185: stat.STATUS_TYPE = 'PROJECT' and
3186: stat.PROJECT_SYSTEM_STATUS_CODE not in ('CLOSED',
3187: 'PENDING_CLOSE',

Line 3289: PA_PROJECT_STATUSES stat,

3285: index(prg, PA_XBS_DENORM_N3)
3286: distinct
3287: emt.PROJECT_ID
3288: from
3289: PA_PROJECT_STATUSES stat,
3290: PA_PROJECTS_ALL prj,
3291: PA_XBS_DENORM prg,
3292: PA_PROJ_ELEMENTS emt
3293: where

Line 3488: PA_PROJECT_STATUSES stat,

3484: index(prg, PA_XBS_DENORM_N3)
3485: distinct
3486: emt.PROJECT_ID
3487: from
3488: PA_PROJECT_STATUSES stat,
3489: PA_PROJECTS_ALL prj,
3490: PA_XBS_DENORM prg,
3491: PA_PROJ_ELEMENTS emt
3492: where