View: PA_XC_TASKS_ALL_V

View Text

SELECT USR.USER_ID
, USR.USER_NAME
, T.TASK_ID
, T.PROJECT_ID
, PRJ1.SEGMENT1
, PRJ1.NAME
, T.TASK_NUMBER
, T.DESCRIPTION
, T.TOP_TASK_ID
, T.WBS_LEVEL
, T.PARENT_TASK_ID
, T.DESCRIPTION
, T.CARRYING_OUT_ORGANIZATION_ID
, PTY1.PARTY_NAME
, T.TASK_MANAGER_PERSON_ID
, PTY2.PARTY_NAME
, T.START_DATE
, T.COMPLETION_DATE
, T.ATTRIBUTE2
, NVL(PAL2.MEANING
, T.ATTRIBUTE3)
, T.ATTRIBUTE3
, T.ATTRIBUTE1
, T.ATTRIBUTE4
, PRJ2.SEGMENT1
, PRJ2.NAME
, T.ATTRIBUTE9
, ST.TASK_NUMBER
, ST.DESCRIPTION
, PPR.PROGRESS_STATUS_CODE
, PAL.MEANING
, PAL.PREDEFINED_FLAG
, PAL.ATTRIBUTE1
, PPR.PROGRESS_ASOF_DATE
, PPR.SHORT_DESCRIPTION
, PPR.LONG_DESCRIPTION
, PPR.ISSUES
, DECODE((SELECT 'Y'
FROM DUAL
WHERE EXISTS (SELECT T1.TASK_ID
FROM PA_TASKS T1
WHERE T.TASK_ID = T1.PARENT_TASK_ID))
, 'Y'
, 'Y'
, 'N')
, T.ATTRIBUTE5
, T.ATTRIBUTE6
, T.ATTRIBUTE7
, T.ATTRIBUTE8
, T.ATTRIBUTE10
, PPR.ESTIMATED_START_DATE
, PPR.ESTIMATED_END_DATE
, PPR.ACTUAL_START_DATE
, PPR.ACTUAL_END_DATE
, PPR.PERCENT_COMPLETE
, PPR.ESTIMATE_TO_COMPLETE
, PPR.UNIT_TYPE
, PAL1.MEANING
, TRUNC(NVL(PPR.ACTUAL_START_DATE
, NVL(PPR.ESTIMATED_START_DATE
, T.START_DATE))) - TRUNC(T.START_DATE)
, TRUNC(NVL(PPR.ACTUAL_END_DATE
, NVL(PPR.ESTIMATED_END_DATE
, NVL(T.COMPLETION_DATE
, SYSDATE)))) - TRUNC(NVL(T.COMPLETION_DATE
, SYSDATE))
, PPR.WF_STATUS_CODE
, PPR.WF_ITEM_TYPE
, PPR.WF_ITEM_KEY
, PPR.WF_PROCESS
, PPR.LAST_UPDATE_DATE
FROM PA_TASKS T
, HZ_PARTIES PTY1
, HZ_PARTIES PTY2
, FND_USER USR
, PA_PROJ_PROGRESS_REPORTS PPR
, PA_LOOKUPS PAL
, PA_PROJECTS_ALL PRJ1
, PA_PROJECTS_ALL PRJ2
, PA_TASKS ST
, PA_LOOKUPS PAL1
, PA_LOOKUPS PAL2
WHERE T.CARRYING_OUT_ORGANIZATION_ID = PTY1.PARTY_ID
AND T.TASK_MANAGER_PERSON_ID = PTY2.PARTY_ID(+)
AND PTY2.PARTY_ID = USR.CUSTOMER_ID (+)
AND T.PROJECT_ID = PPR.PROJECT_ID
AND PPR.TASK_ID = T.TASK_ID
AND PPR.PROGRESS_STATUS_CODE = PAL.LOOKUP_CODE
AND PAL.LOOKUP_TYPE = 'PA_XC_PROGRESS_STATUS'
AND T.PROJECT_ID = PRJ1.PROJECT_ID
AND T.ATTRIBUTE4 = PRJ2.PROJECT_ID (+)
AND T.ATTRIBUTE9 = ST.TASK_ID (+)
AND PAL1.LOOKUP_TYPE(+) = 'PA_XC_TASK_DURATION_UNITS'
AND PAL1.LOOKUP_CODE(+) = PPR.UNIT_TYPE
AND PAL2.LOOKUP_TYPE(+) = 'PA_XC_TASK_DURATION_UNITS'
AND PAL2.LOOKUP_CODE(+) = T.ATTRIBUTE3

Columns