View: PA_UDS_SECTIONS_V

Product:	PA - Projects
Description:	PA_UDS_SECTIONS_V shows all user definable sections.
Implementation/DBA Data:	APPS.PA_UDS_SECTIONS_V

View Text

SELECT PPTR.REGION_SOURCE_CODE FLEX_CODE
, FDFCV.DESCRIPTIVE_FLEX_CONTEXT_NAME FLEX_NAME
, FDFCV.DESCRIPTION DESCRIPTION
, PL.MEANING LAYOUT
, PPTR.START_DATE_ACTIVE
, PPTR.END_DATE_ACTIVE
, PPTR.PAGE_TYPE_CODE
, NULL
, PPTR.REGION_SOURCE_TYPE
, PA_PAGE_LAYOUT_UTILS.IS_PAGE_TYPE_REGION_DELETABLE(PPTR.PAGE_TYPE_CODE
, PPTR.REGION_SOURCE_TYPE
, PPTR.REGION_SOURCE_CODE) DELETABLE_FLAG
, PPTR.VIEW_REGION_CODE
, PPTR.EDIT_REGION_CODE
, PPTR.DISPLAY_ORDER
, PPTR.MANDATORY_FLAG
, PPTR.DEFAULT_REGION_POSITION
, PPTR.PLACEHOLDER_REGION_FLAG
, PPTR.ROWID
FROM PA_PAGE_TYPE_REGIONS PPTR
, FND_DESCR_FLEX_CONTEXTS_VL FDFCV
, PA_LOOKUPS PL
WHERE PPTR.REGION_SOURCE_TYPE = 'DFF'
AND PPTR.REGION_SOURCE_CODE = FDFCV.DESCRIPTIVE_FLEX_CONTEXT_CODE
AND FDFCV.DESCRIPTIVE_FLEXFIELD_NAME = 'PA_STATUS_REPORT_DESC_FLEX'
AND PPTR.VIEW_REGION_CODE = PL.ATTRIBUTE1
AND PL. LOOKUP_TYPE = 'PA_USER_REGION_STYLES'
AND FDFCV.APPLICATION_ID = 275

Columns