FND Design Data [Home] [Help]

View: PA_CE_PROJECTS_SEC_V

Product: PA - Projects
Description: View of all projects across operating units
Implementation/DBA Data: ViewAPPS.PA_CE_PROJECTS_SEC_V
View Text

SELECT P.PROJECT_ID
, P.SEGMENT1
, P.NAME
FROM PA_PROJECTS_ALL P
WHERE PA_SECURITY.ALLOW_QUERY(P.PROJECT_ID) = 'Y'

Columns

Name
PROJECT_ID
PROJECT_NUMBER
PROJECT_NAME