[Home] [Help]
View: 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
Name |
CLASSIFICATION_CODE |
DRIVER_TYPE |
DRIVER_TYPE_CODE |
DRIVER_ID |
DRIVER_NAME |
AG_DETAIL |
PG_DETAIL |