[Home] [Help]
View: PA_PURGE_PROJECTS_LOV_V
View Text
SELECT P.SEGMENT1
, P.NAME
, P.PROJECT_ID
, O1.NAME
, P.CARRYING_OUT_ORGANIZATION_ID
, P.PROJECT_STATUS_CODE
, PPS.PROJECT_STATUS_NAME
, P.CLOSED_DATE
, P.PROJECT_TYPE
, P.ORG_ID
FROM HR_ORGANIZATION_UNITS O1
, PA_PROJECTS P
, PA_PROJECT_STATUSES PPS
WHERE P.CARRYING_OUT_ORGANIZATION_ID = O1.ORGANIZATION_ID
AND P.PROJECT_STATUS_CODE = PPS.PROJECT_STATUS_CODE
AND P.TEMPLATE_FLAG <> 'Y'
AND PA_SECURITY.ALLOW_UPDATE(P.PROJECT_ID) = 'Y'
Columns
| Name |
| PROJECT_NUMBER |
| PROJECT_NAME |
| PROJECT_ID |
| ORGANIZATION_NAME |
| ORGANIZATION_ID |
| PROJECT_STATUS_CODE |
| PROJECT_STATUS |
| PROJECT_CLOSED_DATE |
| PROJECT_TYPE |
| ORG_ID |
APPS.PA_PURGE_PROJECTS_LOV_V