[Home] [Help]
View: PJM_PROJECT_TASK_V
Product: | PJM - Project Manufacturing |
Description: | Task information for the Web Inquiry. |
Implementation/DBA Data: |
APPS.PJM_PROJECT_TASK_V
|
View Text
SELECT TASK.PROJECT_ID
, PROJ.SEGMENT1
, PROJ.NAME
, PROJ.DESCRIPTION
, TASK.TASK_ID
, TASK.TASK_NUMBER
, TASK.TASK_NAME
, TASK.DESCRIPTION
, DECODE( NVL( FND_PROFILE.VALUE_SPECIFIC( 'PA_TASKS_DISPLAYED' )
, 'ALL')
, 'ALL'
, PA_TASK_UTILS.SORT_ORDER_TREE_WALK ( TASK.PARENT_TASK_ID
, TASK.TASK_NUMBER)
, TASK_NUMBER)
, PEOP.FULL_NAME
, TASK.START_DATE
, TASK.COMPLETION_DATE
FROM PA_TASKS TASK
, PA_PROJECTS_ALL PROJ
, PER_ALL_PEOPLE_F PEOP
WHERE PROJ.PROJECT_ID = TASK.PROJECT_ID
AND PEOP.PERSON_ID (+) = TASK.TASK_MANAGER_PERSON_ID
AND TRUNC(SYSDATE) BETWEEN NVL( PEOP.EFFECTIVE_START_DATE
, SYSDATE - 1 )
AND NVL( PEOP.EFFECTIVE_END_DATE
, SYSDATE + 1)
Columns
Name |
PROJECT_ID |
PROJECT_NUMBER |
PROJECT_NAME |
PROJECT_DESCRIPTION |
TASK_ID |
TASK_NUMBER |
TASK_NAME |
DESCRIPTION |
WBS_SORT_ORDER |
MANAGER |
START_DATE |
END_DATE |