Product: | PA - Projects |
---|---|
Description: | View All Task Details |
Implementation/DBA Data: | Not implemented in this database |
SELECT T.USER_ID
, T.USER_NAME
, T.TASK_ID
, T.PROJECT_ID
, T.PROJECT_NUMBER
, T.PROJECT_NAME
, T.TASK_NUMBER
, T.TASK_NAME
, T.TOP_TASK_ID
, T.WBS_LEVEL
, T.PARENT_TASK_ID
, T.DESCRIPTION
, T.TASK_COMPANY_ID
, T.TASK_COMPANY_NAME
, T.TASK_MANAGER_ID
, T.TASK_MANAGER_NAME
, T.START_DATE
, T.END_DATE
, T.DURATION
, T.DURATION_UOM
, T.MILESTONE_FLAG
, T.SUB_PROJECT_ID
, T.SUB_PROJECT_NUMBER
, T.SUB_PROJECT_NAME
, T.PROGRESS_STATUS_CODE
, T.PROGRESS_STATUS
, T.TAG
, T.PROGRESS_IMAGE
, T.PROGRESS_ASOF_DATE
, T.PROGRESS_COMMENT
, T.PROGRESS_REPORT
, T.PROGRESS_ISSUES
, T.CHILD_FLAG
, T.DISPLAY_SEQ
FROM PA_XC_TASKS_ALL_V T
WHERE T.PROJECT_ID = PA_XC_VIEW_UTILS.GETPROJECTID
AND ((PA_XC_VIEW_UTILS.GETTASKID IS NULL
AND (PA_XC_VIEW_UTILS.GETPROJECTMANAGER = 'Y' OR (PA_XC_VIEW_UTILS.GETPROJECTMANAGER = 'N'
AND T.TASK_ID IN (SELECT T1.TASK_ID
FROM PA_TASKS T1
WHERE T1.PROJECT_ID = PA_XC_VIEW_UTILS.GETPROJECTID START WITH T1.TASK_ID IN (SELECT T2.TASK_ID
FROM PA_TASKS T2
WHERE T2.PROJECT_ID = PA_XC_VIEW_UTILS.GETPROJECTID
AND T2.TASK_MANAGER_PERSON_ID = PA_XC_VIEW_UTILS.GETTASKMANAGERID ) CONNECT BY PRIOR T1.TASK_ID = T1.PARENT_TASK_ID ) ) ) ) OR (PA_XC_VIEW_UTILS.GETTASKID() IS NOT NULL
AND T.TASK_ID IN (SELECT T3.TASK_ID
FROM PA_TASKS T3
WHERE T3.PROJECT_ID = PA_XC_VIEW_UTILS.GETPROJECTID START WITH T3.TASK_ID = PA_XC_VIEW_UTILS.GETTASKID CONNECT BY PRIOR T3.TASK_ID = T3.PARENT_TASK_ID ) ) )