View: PA_PROGRESS_REPORTS_MAIN_V

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

View Text

SELECT PPDVER.OBJECT_TYPE
, PPDVER.OBJECT_ID
, PPDVER.PAGE_TYPE_CODE
, PPDVER.PAGE_ID
, PPDVER.REPORT_TYPE_ID
, RTYP.NAME
, POPL.NEXT_REPORTING_DATE
, PPDVER.VERSION_ID
, PPDVER.REPORT_STATUS_CODE
, PPS1.PROJECT_STATUS_NAME PAGE_STATUS_MEANING
, PPDVER.PROGRESS_STATUS_CODE
, PPS2.PROJECT_STATUS_NAME PROGRESS_STATUS_MEANING
, PPS2.STATUS_ICON_IND
, PPS2.STATUS_ICON_ACTIVE_IND
, PPDVER.REPORT_START_DATE
, PPDVER.REPORT_END_DATE
, PPDVER.REPORTED_BY
, PA_RESOURCE_UTILS.GET_RESOURCE_NAME(PPDVER.REPORTED_BY)
, PPDVER.CURRENT_FLAG
, PPDVER.OVERVIEW
, PPDVER.COMMENTS
, PPDVER.PUBLISHED_DATE
, PPDVER.CANCELED_DATE
, PPDVER.RECORD_VERSION_NUMBER
, PA_PROGRESS_REPORT_UTILS.CHECK_SECURITY_FOR_PROGREP(PPDVER.OBJECT_TYPE
, PPDVER.OBJECT_ID
, PPDVER.REPORT_TYPE_ID) REPORT_ACCESS FROM PA_PROGRESS_REPORT_VERS PPDVER
, PA_PROJECT_STATUSES PPS1
, PA_PROJECT_STATUSES PPS2
, PA_REPORT_TYPES RTYP
, PA_OBJECT_PAGE_LAYOUTS POPL
WHERE PPDVER.OBJECT_ID = POPL.OBJECT_ID
AND PPDVER.OBJECT_TYPE = POPL.OBJECT_TYPE
AND PPDVER.REPORT_TYPE_ID = POPL.REPORT_TYPE_ID
AND PPDVER.PAGE_TYPE_CODE = 'PPR'
AND PPDVER.REPORT_TYPE_ID = RTYP.REPORT_TYPE_ID
AND PPDVER.REPORT_STATUS_CODE = PPS1.PROJECT_STATUS_CODE
AND PPDVER.PROGRESS_STATUS_CODE = PPS2.PROJECT_STATUS_CODE(+)
AND ( GENERATION_METHOD IS NULL OR GENERATION_METHOD = 'MANUAL') UNION SELECT POPL.OBJECT_TYPE
, POPL.OBJECT_ID
, POPL.PAGE_TYPE_CODE
, POPL.PAGE_ID
, POPL.REPORT_TYPE_ID
, RTYP.NAME
, POPL.NEXT_REPORTING_DATE
, TO_NUMBER(NULL) VERSION_ID
, NULL REPORT_STATUS_CODE
, NULL PAGE_STATUS_MEANING
, NULL PROGRESS_STATUS_CODE
, NULL PROGRESS_STATUS_MEANING
, NULL PROGRESS_STATUS_ICON
, NULL PROGRESS_STATUS_ACTIVE_ICON
, TO_DATE(NULL) REPORT_START_DATE
, TO_DATE(NULL) REPORT_END_DATE
, TO_NUMBER(NULL) REPORTED_BY
, NULL REPORTED_BY_NAME
, 'Y' CURRENT_FLAG
, NULL OVERVIEW
, NULL COMMENTS
, TO_DATE(NULL) PUBLISHED_DATE
, TO_DATE(NULL) CANCELED_DATE
, TO_NUMBER(NULL) RECORD_VERSION_NUMBER
, PA_PROGRESS_REPORT_UTILS.CHECK_SECURITY_FOR_PROGREP(POPL.OBJECT_TYPE
, POPL.OBJECT_ID
, POPL.REPORT_TYPE_ID) REPORT_ACCESS
FROM PA_REPORT_TYPES RTYP
, PA_OBJECT_PAGE_LAYOUTS POPL
WHERE POPL.PAGE_TYPE_CODE = 'PPR'
AND POPL.REPORT_TYPE_ID = RTYP.REPORT_TYPE_ID
AND (GENERATION_METHOD IS NULL OR GENERATION_METHOD = 'MANUAL')
AND NOT EXISTS (SELECT 'Y'
FROM PA_PROGRESS_REPORT_VERS PPRV
WHERE PPRV.OBJECT_ID = POPL.OBJECT_ID
AND PPRV.OBJECT_TYPE = POPL.OBJECT_TYPE
AND PPRV.REPORT_TYPE_ID = POPL.REPORT_TYPE_ID
AND PPRV.REPORT_STATUS_CODE = 'PROGRESS_REPORT_PUBLISHED')

Columns