[Home] [Help]
View: OKE_TASKS_V
Product: | OKE - Project Contracts |
Description: | Valid task listing |
Implementation/DBA Data: |
APPS.OKE_TASKS_V
|
View Text
SELECT PTK.PROJECT_ID
, PTK.TASK_ID
, PTK.TASK_NUMBER
, PTK.TASK_NAME
, PTK.START_DATE
, PTK.COMPLETION_DATE
, PTK.TASK_MANAGER_PERSON_ID
, PEOP.FULL_NAME
FROM PA_TASKS PTK
, PER_PEOPLE_F PEOP
WHERE PEOP.PERSON_ID (+) = PTK.TASK_MANAGER_PERSON_ID
Columns
Name |
PROJECT_ID |
TASK_ID |
TASK_NUMBER |
TASK_NAME |
START_DATE |
END_DATE |
TASK_MGR_ID |
TASK_MGR |