View: OZF_JE_CATEGORIES_V

Product:	OZF - Trade Management
Description:
Implementation/DBA Data:	APPS.OZF_JE_CATEGORIES_V

View Text

SELECT JE_CATEGORY_NAME
, USER_JE_CATEGORY_NAME
FROM GL_JE_CATEGORIES
WHERE JE_CATEGORY_NAME IN ('BUDGET'
, 'CLAIMS'
, 'DEDUCTIONS') UNION SELECT LOOKUP_CODE
, MEANING
FROM FND_LOOKUPS
WHERE LOOKUP_TYPE = 'BOTH_ALL_NONE'
AND LOOKUP_CODE = 'A'

Columns