DBA Data[Home] [Help]

VIEW: APPS.PA_TASKS_LOWEST_V

Source

View Text - Preformatted

SELECT T.PROJECT_ID , T.TASK_ID , T.TASK_NUMBER , T.TASK_NAME , T.PARENT_TASK_ID , T.TOP_TASK_ID , T.TASK_NUMBER FROM PA_TASKS T WHERE PA_TASK_UTILS.CHECK_CHILD_EXISTS(T.TASK_ID) = 0
View Text - HTML Formatted

SELECT T.PROJECT_ID
, T.TASK_ID
, T.TASK_NUMBER
, T.TASK_NAME
, T.PARENT_TASK_ID
, T.TOP_TASK_ID
, T.TASK_NUMBER
FROM PA_TASKS T
WHERE PA_TASK_UTILS.CHECK_CHILD_EXISTS(T.TASK_ID) = 0