SELECT lookup_code period_set_code, meaning period_set_name FROM gl_lookups WHERE lookup_type='LITERAL' AND lookup_code='ALL' UNION SELECT period_set_name, period_set_name FROM gl_period_sets
View Text - HTML Formatted
SELECT LOOKUP_CODE PERIOD_SET_CODE , MEANING PERIOD_SET_NAME FROM GL_LOOKUPS WHERE LOOKUP_TYPE='LITERAL' AND LOOKUP_CODE='ALL' UNION SELECT PERIOD_SET_NAME , PERIOD_SET_NAME FROM GL_PERIOD_SETS