GL_JE_CATEGORIES_AUTOPOST_V

Details

• Schema: FUSION

• Object owner: GL

• Object type: VIEW

Columns

Name
JE_CATEGORY_NAME USER_JE_CATEGORY_NAME DESCRIPTION SORT_ORDER

Query

SQL_Statement
select je_category_name, user_je_category_name, description, '1' || user_je_category_name sort_order from gl_je_categories UNION ALL select l.lookup_code je_category_name, l.meaning user_je_category_name, null description, '0' sort_order FROM gl_lookups l WHERE l.lookup_type = 'LITERAL' AND l.lookup_code = 'ALL' order by 4