[Home] [Help]
View: PA_EXT_DRIVERS_V
Product: | PA - Projects |
Description: | Extensible Context View |
Implementation/DBA Data: |
APPS.PA_EXT_DRIVERS_V
|
View Text
SELECT 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
Columns
Name |
DRIVER_TYPE |
DRIVER_NAME |
DRIVER_ID |
DESCRIPTION |