View: PA_PROJECT_TASKS_AP_V

Product:	AP - Payables
Description:	(Release 10SC Only)
Implementation/DBA Data:	APPS.PA_PROJECT_TASKS_AP_V

View Text

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

Columns