DBA Data[Home] [Help]

VIEW: APPS.OKE_TASKS_V

Source

View Text - Preformatted

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
View Text - HTML Formatted

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