VIEW: APPS.PA_PURGE_PROJECTS_LOV_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'