VIEW: APPS.PN_JE_CATEGORIES_V

Source

View Text - Preformatted

SELECT je_category_name, user_je_category_name FROM gl_je_categories WHERE je_category_name IN ( 'PM EXPENSE', 'PM REVENUE') UNION SELECT lookup_code, meaning FROM fnd_lookups WHERE lookup_type = 'BOTH_ALL_NONE' AND lookup_code = 'A'

View Text - HTML Formatted

SELECT JE_CATEGORY_NAME
, USER_JE_CATEGORY_NAME
FROM GL_JE_CATEGORIES
WHERE JE_CATEGORY_NAME IN ( 'PM EXPENSE'
, 'PM REVENUE') UNION SELECT LOOKUP_CODE
, MEANING
FROM FND_LOOKUPS
WHERE LOOKUP_TYPE = 'BOTH_ALL_NONE'
AND LOOKUP_CODE = 'A'