VIEW: APPS.PA_PROJECTS_ERP_OCV

Source

View Text - Preformatted

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

View Text - HTML Formatted

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