VIEW: APPS.PA_PROJECTS_FOR_ACCUM_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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