[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 |