[Home] [Help]
View: GL_ALL_PERIOD_NAME_VIEW
View Text
SELECT PERIOD_NAME
, PERIOD_NAME MEANING
, PERIOD_YEAR
, PERIOD_NUM
, CLOSING_STATUS
, LEDGER_ID
FROM GL_PERIOD_STATUSES
WHERE APPLICATION_ID = 101 UNION SELECT DESCRIPTION
, LOOKUP_CODE
, 9999
, 9999
, 'O'
, -1
FROM GL_LOOKUPS
WHERE LOOKUP_TYPE = 'LITERAL'
AND LOOKUP_CODE = 'ALL'
Columns
Name |
PERIOD_NAME |
MEANING |
PERIOD_YEAR |
PERIOD_NUM |
CLOSING_STATUS |
LEDGER_ID |