[Home] [Help]
View: PA_ALLOC_SRC_PROJECTS_V
View Text
SELECT PAP.PROJECT_ID
, PAP.SEGMENT1
, PAP.NAME
, PAP.PROJECT_TYPE
, PAP.CARRYING_OUT_ORGANIZATION_ID
, PPC.CLASS_CATEGORY
, PPC.CLASS_CODE
, PAP.ORG_ID
FROM PA_PROJECTS PAP
, PA_PROJECT_CLASSES PPC
WHERE PPC.PROJECT_ID(+) = PAP.PROJECT_ID
AND PAP.TEMPLATE_FLAG <> 'Y'
AND PA_PROJECT_STUS_UTILS.IS_PROJECT_CLOSED(PAP.PROJECT_ID) = 'N'
Columns
| Name |
| PROJECT_ID |
| PROJECT_NUMBER |
| PROJECT_NAME |
| PROJECT_TYPE |
| CARRYING_OUT_ORGANIZATION_ID |
| CLASS_CATEGORY |
| CLASS_CODE |
| ORG_ID |
APPS.PA_ALLOC_SRC_PROJECTS_V