View: PA_PROJ_STATUS_REMINDER_V

Product:	PA - Projects
Description:
Implementation/DBA Data:	APPS.PA_PROJ_STATUS_REMINDER_V

View Text

SELECT PROJ.SEGMENT1
, LAYOUT.OBJECT_PAGE_LAYOUT_ID
, 'PA_PROJ_STATUS_REPORTS'
, PROJ.NAME || '(' || PROJ.SEGMENT1 || ')'
, LAYOUT.NEXT_REPORTING_DATE
, PROJ.PROJECT_STATUS_CODE
, PA_PROJECT_UTILS.CHECK_PRJ_STUS_ACTION_ALLOWED (PROJ.PROJECT_STATUS_CODE
, 'PA_PROJ_STATUS_REPORT')
FROM PA_PROJECTS_ALL PROJ
, PA_OBJECT_PAGE_LAYOUTS LAYOUT
WHERE LAYOUT.OBJECT_ID = PROJ.PROJECT_ID
AND LAYOUT.OBJECT_TYPE = 'PA_PROJECTS'
AND LAYOUT.PAGE_TYPE_CODE = 'PPR'
AND LAYOUT.NEXT_REPORTING_DATE IS NOT NULL
AND LAYOUT.EFFECTIVE_FROM <= SYSDATE
AND NVL(LAYOUT.EFFECTIVE_TO
, SYSDATE) >= SYSDATE
AND 'Y' = PA_PROJECT_UTILS.CHECK_PRJ_STUS_ACTION_ALLOWED (PROJ.PROJECT_STATUS_CODE
, 'PA_PROJ_STATUS_REPORT')

Columns