VIEW: APPS.PA_PROJECT_TASKS_AP_V

Source

View Text - Preformatted

SELECT PAP.SEGMENT1 PROJECT , PAP.NAME DESCRIPTION , PAP.PROJECT_ID PROJECT_ID , COUNT ( DISTINCT PAT.TASK_ID ) TASKS_PER_PROJ FROM PA_PROJECTS PAP, PA_TASKS_EXPEND_V PAT WHERE PAP.PROJECT_ID = PAT.PROJECT_ID ( + ) GROUP BY PAP.PROJECT_ID, PAP.SEGMENT1, PAP.NAME

View Text - HTML Formatted

SELECT PAP.SEGMENT1 PROJECT
, PAP.NAME DESCRIPTION
, PAP.PROJECT_ID PROJECT_ID
, COUNT ( DISTINCT PAT.TASK_ID ) TASKS_PER_PROJ
FROM PA_PROJECTS PAP
, PA_TASKS_EXPEND_V PAT
WHERE PAP.PROJECT_ID = PAT.PROJECT_ID ( + ) GROUP BY PAP.PROJECT_ID
, PAP.SEGMENT1
, PAP.NAME