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]

View: PA_XC_TASKS_V

Product:	PA - Projects
Description:	View All Task Status,Dates and Associations
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT T.TASK_ID
, T.WBS_LEVEL
, T.DESCRIPTION
, NVL(TO_CHAR(T.COMPLETION_DATE
, 'MM/DD/YYYY')
, ' ')
, PPR.PROGRESS_STATUS_CODE
, T.ATTRIBUTE6
, NVL(TO_CHAR(PPR.ESTIMATED_END_DATE
, 'MM/DD/YYYY')
, ' ')
, NVL(T.ATTRIBUTE4
, 0)
, NVL(T.ATTRIBUTE9
, 0)
, PRJ.NAME
, SUB.DESCRIPTION
, PRJ.SEGMENT1
, SUB.TASK_NUMBER
, NVL(TO_CHAR(T.START_DATE
, 'MM/DD/YYYY')
, ' ')
, T.PROJECT_ID
, T.TASK_NUMBER
FROM PA_TASKS T
, PA_LOOKUPS PAL
, PA_PROJ_PROGRESS_REPORTS PPR
, PA_PROJECTS_ALL PRJ
, PA_TASKS SUB
WHERE PPR.PROJECT_ID = T.PROJECT_ID
AND PPR.TASK_ID = T.TASK_ID
AND PAL.LOOKUP_TYPE = 'PA_XC_PROGRESS_STATUS'
AND T.ATTRIBUTE4 = PRJ.PROJECT_ID(+)
AND PPR.PROGRESS_STATUS_CODE = PAL.LOOKUP_CODE
AND T.ATTRIBUTE9 = SUB.TASK_ID(+) ORDER BY TO_NUMBER(T.ATTRIBUTE5)
, T.TASK_NUMBER

Columns

Name
TASK_ID
WBS_LEVEL
TASK_NAME
SCHED_END_DATE
STAT_CODE
CRITICAL
EST_END_DATE
SUB_PROJ_ID
SUB_TASK_ID
SUB_PROJ_NAME
SUB_TASK_NAME
SUB_PROJ_NUMBER
SUB_TASK_NUMBER
SCHED_START_DATE
PROJECT_ID
TASK_NUMBER