VIEW: APPS.OZF_JE_CATEGORIES_V

Source

View Text - Preformatted

SELECT je_category_name, user_je_category_name from gl_je_categories where je_category_name in ('Fixed Budgets', 'Accrual Budgets', 'Claims', 'Deductions', 'Settlement') 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 ('FIXED BUDGETS'
, 'ACCRUAL BUDGETS'
, 'CLAIMS'
, 'DEDUCTIONS'
, 'SETTLEMENT') UNION SELECT LOOKUP_CODE
, MEANING
FROM FND_LOOKUPS
WHERE LOOKUP_TYPE = 'BOTH_ALL_NONE'
AND LOOKUP_CODE = 'A'