FND Design Data [Home] [Help]

View: PA_ALLOC_OFFSET_PROJECTS_V

Product: PA - Projects
Description:
Implementation/DBA Data: ViewAPPS.PA_ALLOC_OFFSET_PROJECTS_V
View Text

SELECT PAP.PROJECT_ID
, PAP.SEGMENT1
, PAP.NAME
, PAP.ORG_ID
FROM PA_PROJECTS PAP
WHERE PAP.TEMPLATE_FLAG <> 'Y'
AND PA_PROJECT_UTILS.CHECK_PRJ_STUS_ACTION_ALLOWED(PAP.PROJECT_STATUS_CODE
, 'NEW_TXNS')='Y'

Columns

Name
PROJECT_ID
PROJECT_NUMBER
PROJECT_NAME
ORG_ID