FND Design Data [Home] [Help]

View: PA_CAPITAL_COMMON_TASKS_V

Product: PA - Projects
Description: 10SC Only
Implementation/DBA Data: ViewAPPS.PA_CAPITAL_COMMON_TASKS_V
View Text

SELECT T.PROJECT_ID
, T.TASK_ID
, T.TASK_NUMBER
, T.TASK_NAME
FROM PA_TASKS T
WHERE TASK_ID IN (SELECT TASK_ID
FROM PA_PROJECT_ASSET_ASSIGNMENTS PPAA
WHERE T.PROJECT_ID = PPAA.PROJECT_ID
AND PPAA.PROJECT_ASSET_ID = 0)

Columns

Name
PROJECT_ID
TASK_ID
TASK_NUMBER
TASK_NAME