View: PA_PROJECTS_ERP_OCV

Product:	PA - Projects
Description:
Implementation/DBA Data:	APPS.PA_PROJECTS_ERP_OCV

View Text

SELECT 'CLASS_CATEGORY:'||TO_CHAR(CLASS_CATEGORY_ID)
, CLASS_CATEGORY
, USERENV('LANG')
FROM PA_CLASS_CATEGORIES
WHERE OBJECT_TYPE = 'PA_PROJECTS' UNION ALL SELECT 'CLASS_CODE:'||TO_CHAR(CLASS_CODE_ID)
, CLASS_CODE
, USERENV('LANG')
FROM PA_CLASS_CODES UNION ALL SELECT 'PROJECT_TYPE:'||TO_CHAR(PROJECT_TYPE_ID)
, PROJECT_TYPE
, USERENV('LANG')
FROM PA_PROJECT_TYPES UNION ALL SELECT 'TASK_TYPE:'||TO_CHAR(TASK_TYPE_ID)
, TASK_TYPE
, USERENV('LANG')
FROM PA_TASK_TYPES

Columns