View: PN_JE_CATEGORIES_V

Product:	PN - Property Manager
Description:
Implementation/DBA Data:	APPS.PN_JE_CATEGORIES_V

View Text

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'

Columns