[Home] [Help]
| Product: | PA - Projects |
|---|---|
| Description: | View My Task Details |
| Implementation/DBA Data: | Not implemented in this database |
SELECT T.TASK_ID
, T.PROJECT_ID
, PRJ.SEGMENT1
, PRJ.NAME
, T.TASK_NUMBER
, T.DESCRIPTION
, T.WBS_LEVEL
, T.START_DATE
, T.COMPLETION_DATE
, T.ATTRIBUTE1 /* MILE STONE FLAG */
, T.TASK_MANAGER_PERSON_ID
, PPR.PROGRESS_STATUS_CODE
, LKP.MEANING
, T.ATTRIBUTE5
, NVL((SELECT 'Y'
FROM DUAL
WHERE EXISTS (SELECT T1.TASK_ID
FROM PA_TASKS T1
WHERE T.TASK_ID = T1.PARENT_TASK_ID))
, 'N')
, 'DIRECT'
FROM PA_TASKS T
, PA_PROJECTS_ALL PRJ
, PA_PROJ_PROGRESS_REPORTS PPR
, PA_LOOKUPS LKP
WHERE T.PROJECT_ID = PPR.PROJECT_ID
AND T.TASK_ID = PPR.TASK_ID
AND PPR.PROGRESS_STATUS_CODE = LKP.LOOKUP_CODE
AND LKP.LOOKUP_TYPE = 'PA_XC_PROGRESS_STATUS'
AND T.PROJECT_ID = PRJ.PROJECT_ID UNION SELECT T.TASK_ID
, T.PROJECT_ID
, PRJ.SEGMENT1
, PRJ.NAME
, T.TASK_NUMBER
, T.DESCRIPTION
, T.WBS_LEVEL
, T.START_DATE
, T.COMPLETION_DATE
, T.ATTRIBUTE1 /* MILE STONE FLAG */
, PPP.RESOURCE_SOURCE_ID
, PPR.PROGRESS_STATUS_CODE
, LKP.MEANING
, T.ATTRIBUTE5
, NVL((SELECT 'Y'
FROM DUAL
WHERE EXISTS (SELECT T1.TASK_ID
FROM PA_TASKS T1
WHERE T.TASK_ID = T1.PARENT_TASK_ID))
, 'N')
, 'DIRECT'
FROM PA_TASKS T
, PA_PROJECTS_ALL PRJ
, PA_PROJ_PROGRESS_REPORTS PPR
, PA_LOOKUPS LKP
, PA_PROJECT_PARTIES PPP
WHERE T.PROJECT_ID = PPR.PROJECT_ID
AND T.TASK_ID = PPR.TASK_ID
AND PPR.PROGRESS_STATUS_CODE = LKP.LOOKUP_CODE
AND LKP.LOOKUP_TYPE = 'PA_XC_PROGRESS_STATUS'
AND T.PROJECT_ID = PRJ.PROJECT_ID
AND T.TASK_ID = PPP.OBJECT_ID
AND T.PROJECT_ID = PPP.PROJECT_ID
AND PPP.RESOURCE_TYPE_ID = 101
AND PPP.OBJECT_TYPE = 'PA_TASKS' UNION SELECT T.TASK_ID
, T.PROJECT_ID
, PRJ.SEGMENT1
, PRJ.NAME
, T.TASK_NUMBER
, T.DESCRIPTION
, T.WBS_LEVEL
, T.START_DATE
, T.COMPLETION_DATE
, T.ATTRIBUTE1 /* MILE STONE FLAG */
, REL.SUBJECT_ID
, PPR.PROGRESS_STATUS_CODE
, LKP.MEANING
, T.ATTRIBUTE5
, NVL((SELECT 'Y'
FROM DUAL
WHERE EXISTS (SELECT T1.TASK_ID
FROM PA_TASKS T1
WHERE T.TASK_ID = T1.PARENT_TASK_ID))
, 'N')
, 'GROUP'
FROM PA_TASKS T
, PA_PROJECTS_ALL PRJ
, PA_PROJ_PROGRESS_REPORTS PPR
, PA_LOOKUPS LKP
, PA_PROJECT_PARTIES PPP
, HZ_PARTY_RELATIONSHIPS REL
WHERE T.PROJECT_ID = PPR.PROJECT_ID
AND T.TASK_ID = PPR.TASK_ID
AND PPR.PROGRESS_STATUS_CODE = LKP.LOOKUP_CODE
AND LKP.LOOKUP_TYPE = 'PA_XC_PROGRESS_STATUS'
AND T.PROJECT_ID = PRJ.PROJECT_ID
AND T.TASK_ID=PPP.OBJECT_ID
AND T.PROJECT_ID=PPP.PROJECT_ID
AND PPP.RESOURCE_TYPE_ID=101
AND PPP.OBJECT_TYPE='PA_TASKS'
AND PPP.RESOURCE_SOURCE_ID=REL.OBJECT_ID
AND REL.PARTY_RELATIONSHIP_TYPE='MEMBER_OF'