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.

VIEW: APPS.GMS_PROJECTS_EXPEND_V

Source

View Text - Preformatted


SELECT A.PROJECT_ID PROJECT_ID , A.PROJECT_NUMBER PROJECT_NUMBER , A.PROJECT_NAME PROJECT_NAME , A.START_DATE START_DATE , A.COMPLETION_DATE COMPLETION_DATE , PT.PROJECT_TYPE_CLASS_CODE PROJECT_TYPE_CLASS_CODE , A.PROJECT_NUMBER_SORT_ORDER PROJECT_NUMBER_SORT_ORDER , A.PROJECT_TYPE PROJECT_TYPE , (SELECT COUNT(C.TASK_ID) FROM PA_TASKS C WHERE C.PROJECT_ID = A.PROJECT_ID) TASKS_PER_PROJ , PT.ORG_ID FROM PA_PROJECTS_EXPEND_V A ,PA_PROJECT_TYPES PT WHERE PT.PROJECT_TYPE = A.PROJECT_TYPE AND PT.ORG_ID = A.PROJECT_OU

View Text - HTML Formatted

SELECT A.PROJECT_ID PROJECT_ID
, A.PROJECT_NUMBER PROJECT_NUMBER
, A.PROJECT_NAME PROJECT_NAME
, A.START_DATE START_DATE
, A.COMPLETION_DATE COMPLETION_DATE
, PT.PROJECT_TYPE_CLASS_CODE PROJECT_TYPE_CLASS_CODE
, A.PROJECT_NUMBER_SORT_ORDER PROJECT_NUMBER_SORT_ORDER
, A.PROJECT_TYPE PROJECT_TYPE
, (SELECT COUNT(C.TASK_ID)
FROM PA_TASKS C
WHERE C.PROJECT_ID = A.PROJECT_ID) TASKS_PER_PROJ
, PT.ORG_ID
FROM PA_PROJECTS_EXPEND_V A
, PA_PROJECT_TYPES PT
WHERE PT.PROJECT_TYPE = A.PROJECT_TYPE
AND PT.ORG_ID = A.PROJECT_OU