View: PA_EXT_MAINT_AG_RESULTS_V

Product:	PA - Projects
Description:	Extensible drivers with associated attribute groups
Implementation/DBA Data:	APPS.PA_EXT_MAINT_AG_RESULTS_V

View Text

SELECT UNIQUE AGV.CLASSIFICATION_CODE
, PL.MEANING DRIVER_TYPE
, PL.LOOKUP_CODE DRIVER_TYPE_CODE
, PEV.DRIVER_ID
, PEV.DRIVER_NAME
, PA_EXT_ATTRIBUTE_UTILS.GET_ATTRIBUTE_GROUPS(CLASSIFICATION_CODE) AG_DETAIL
, PA_EXT_ATTRIBUTE_UTILS.GET_PAGE_REGIONS(CLASSIFICATION_CODE) PG_DETAIL
FROM EGO_OBJ_ATTR_GRP_ASSOCS_V AGV
, PA_LOOKUPS PL
, PA_EXT_DRIVERS_V PEV
, FND_OBJECTS FO
WHERE FO.OBJ_NAME = 'PA_PROJECTS'
AND AGV.OBJECT_ID = FO.OBJECT_ID
AND PL.LOOKUP_TYPE = 'PA_EXT_DRIVER_TYPE'
AND PEV.DRIVER_TYPE = PL.LOOKUP_CODE
AND PEV.DRIVER_TYPE || ':' || PEV.DRIVER_ID = AGV.CLASSIFICATION_CODE UNION SELECT UNIQUE EPV.CLASSIFICATION_CODE
, PL.MEANING DRIVER_TYPE
, PL.LOOKUP_CODE DRIVER_TYPE_CODE
, PEV.DRIVER_ID
, PEV.DRIVER_NAME
, PA_EXT_ATTRIBUTE_UTILS.GET_ATTRIBUTE_GROUPS(CLASSIFICATION_CODE) AG_DETAIL
, PA_EXT_ATTRIBUTE_UTILS.GET_PAGE_REGIONS(CLASSIFICATION_CODE) PG_DETAIL
FROM EGO_PAGES_V EPV
, PA_LOOKUPS PL
, PA_EXT_DRIVERS_V PEV
, FND_OBJECTS FO
WHERE FO.OBJ_NAME = 'PA_PROJECTS'
AND EPV.OBJECT_ID = FO.OBJECT_ID
AND PL.LOOKUP_TYPE = 'PA_EXT_DRIVER_TYPE'
AND PEV.DRIVER_TYPE = PL.LOOKUP_CODE
AND PEV.DRIVER_TYPE || ':' || PEV.DRIVER_ID = EPV.CLASSIFICATION_CODE

Columns