[Home] [Help]
View: GL_ALL_LSET_PERIOD_NAME_VIEW
Product: | GL - General Ledger |
Description: | |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT PERIOD_NAME
, PERIOD_NAME MEANING
, PERIOD_YEAR
, PERIOD_NUM
, PERIOD_SET_NAME
, PERIOD_TYPE
FROM GL_PERIODS UNION SELECT MEANING
, LOOKUP_CODE
, 9999
, 9999
, NULL
, NULL
FROM GL_LOOKUPS
WHERE LOOKUP_TYPE = 'LITERAL'
AND LOOKUP_CODE = 'ALL'
Columns
Name |
PERIOD_NAME |
MEANING |
PERIOD_YEAR |
PERIOD_NUM |
PERIOD_SET_NAME |
PERIOD_TYPE |