FND Design Data [Home] [Help]

View: PA_REP_UTIL_CATEGORY_V

Product: PA - Projects
Description: View to display utility categories and description
Implementation/DBA Data: ViewAPPS.PA_REP_UTIL_CATEGORY_V
View Text

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'

Columns

Name
UTIL_CATEGORY_ID
UTIL_CATEGORY_DESC