VIEW: APPS.PA_EXT_MAINT_AG_RESULTS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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