View: PA_TASK_PROGRESS_REMINDER_V

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

View Text

SELECT PROJ.SEGMENT1
, PROJ.PROJECT_ID
, 'PA_PROJECTS'
, PROJ.NAME || '(' || PROJ.SEGMENT1 || ')'
, LAYOUT.NEXT_REPORTING_DATE
, PROJ.PROJECT_STATUS_CODE
, PROJ.START_DATE
, PA_PROJECT_UTILS.CHECK_PRJ_STUS_ACTION_ALLOWED (PROJ.PROJECT_STATUS_CODE
, 'PA_TASK_PROGRESS')
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 = 'TPR'
AND NVL(PROJ.START_DATE
, SYSDATE) <= SYSDATE
AND LAYOUT.NEXT_REPORTING_DATE <= SYSDATE
AND 'Y' = PA_PROJECT_UTILS.CHECK_PRJ_STUS_ACTION_ALLOWED (PROJ.PROJECT_STATUS_CODE
, 'PA_TASK_PROGRESS')

Columns