VIEW: APPS.PA_REP_UTIL_CATEGORY_V

Source

View Text - Preformatted

SELECT UTIL_CATEGORY_ID, NAME FROM pa_util_categories_tl WHERE LANGUAGE=USERENV('LANG') UNION SELECT 0, meaning FROM pa_lookups WHERE lookup_type = 'PA_REP_ALL'

View Text - HTML Formatted

SELECT UTIL_CATEGORY_ID
, NAME
FROM PA_UTIL_CATEGORIES_TL
WHERE LANGUAGE=USERENV('LANG') UNION SELECT 0
, MEANING
FROM PA_LOOKUPS
WHERE LOOKUP_TYPE = 'PA_REP_ALL'