[Home] [Help]
View: GL_SRS_GLRTB2_START_PERIOD
View Text
SELECT 'A' ACTUAL_FLAG
, -1 LEDGER_ID
, MEANING PERIOD_NAME
, -1 PERIOD_YEAR
, -1 PERIOD_NUM
FROM GL_LOOKUPS
WHERE LOOKUP_TYPE = 'LITERAL' AND LOOKUP_CODE = 'N/A' UNION SELECT 'B' ACTUAL_FLAG
, LEDGER_ID LEDGER_ID
, PERIOD_NAME PERIOD_NAME
, PERIOD_YEAR PERIOD_YEAR
, PERIOD_NUM PERIOD_NUM
FROM GL_PERIOD_STATUSES
WHERE APPLICATION_ID = 101
Columns
Name |
ACTUAL_FLAG |
LEDGER_ID |
PERIOD_NAME |
PERIOD_YEAR |
PERIOD_NUM |