View: PA_EXT_DRIVERS_V

Product:	PA - Projects
Description:	Extensible Context View
Implementation/DBA Data:	APPS.PA_EXT_DRIVERS_V

View Text

SELECT 'CLASS_CATEGORY' DRIVER_TYPE
, CLASS_CATEGORY DRIVER_NAME
, CLASS_CATEGORY_ID DRIVER_ID
, DESCRIPTION
FROM PA_CLASS_CATEGORIES UNION SELECT 'CLASS_CODE' DRIVER_TYPE
, PCC.CLASS_CATEGORY || '-' || PCC.CLASS_CODE DRIVER_NAME
, PCC.CLASS_CODE_ID DRIVER_ID
, DESCRIPTION
FROM PA_CLASS_CODES PCC UNION SELECT 'TASK_TYPE' DRIVER_TYPE
, TASK_TYPE DRIVER_NAME
, TASK_TYPE_ID DRIVER_ID
, DESCRIPTION
FROM PA_TASK_TYPES UNION SELECT 'PROJECT_TYPE' DRIVER_TYPE
, PROJECT_TYPE DRIVER_NAME
, PROJECT_TYPE_ID DRIVER_ID
, DESCRIPTION
FROM PA_PROJECT_TYPES_V

Columns