GL_JE_SOURCES_AUTOPOST_V

Details

• Schema: FUSION

• Object owner: GL

• Object type: VIEW

Columns

Name
JE_SOURCE_NAME USER_JE_SOURCE_NAME DESCRIPTION SORT_ORDER

Query

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