View: PA_PROJECTS_FOR_ACCUM_V

Product:	PA - Projects
Description:	View for selecting the range of projects that need to be summarized
Implementation/DBA Data:	APPS.PA_PROJECTS_FOR_ACCUM_V

View Text

SELECT PROJ.PROJECT_ID
, PROJ.SEGMENT1
, PROJ.CLOSED_DATE
, PROJ.PROJECT_TYPE
FROM PA_PROJECTS PROJ
WHERE PROJ.SEGMENT1 BETWEEN PA_ACCUM_UTILS.GET_PROJECT_INFO('F') AND PA_ACCUM_UTILS.GET_PROJECT_INFO('T') AND PA_ACCUM_UTILS.GET_CONTEXT_INFO = 'REGULAR' AND NVL(PROJ.TEMPLATE_FLAG
, 'N') <> 'Y' UNION ALL SELECT DISTINCT ALLOC.PROJECT_ID
, PROJ.SEGMENT1
, PROJ.CLOSED_DATE
, PROJ.PROJECT_TYPE
FROM PA_PROJECTS PROJ
, PA_ALLOC_TXN_DETAILS ALLOC
WHERE PROJ.PROJECT_ID = ALLOC.PROJECT_ID
AND PA_ACCUM_UTILS.GET_CONTEXT_INFO = 'AUTO_ALLOCATION'
AND ALLOC.RUN_ID = PA_ACCUM_UTILS.GET_GROUPING_ID

Columns