VIEW: APPS.PA_EXT_DRIVERS_V

Source

View Text - Preformatted

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 where object_type='PA_TASKS' union select 'PROJECT_TYPE' driver_type, project_type driver_name, project_type_id driver_id, description from pa_project_types_v

View Text - HTML Formatted

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
WHERE OBJECT_TYPE='PA_TASKS' UNION SELECT 'PROJECT_TYPE' DRIVER_TYPE
, PROJECT_TYPE DRIVER_NAME
, PROJECT_TYPE_ID DRIVER_ID
, DESCRIPTION
FROM PA_PROJECT_TYPES_V