[Home] [Help]
View: GL_PERIOD_STATUSES_NAME_V
View Text
SELECT GPS.APPLICATION_ID APPLICATION_ID
, GPS.LEDGER_ID LEDGER_ID
, GPS.PERIOD_NAME PERIOD_NAME
, GPS.PERIOD_YEAR PERIOD_YEAR
, GPS.PERIOD_NUM PERIOD_NUM
, GPS.QUARTER_NUM QUARTER_NUM
, GPS.START_DATE START_DATE
, GPS.END_DATE END_DATE
, GPS.QUARTER_START_DATE QUARTER_START_DATE
, GPS.YEAR_START_DATE YEAR_START_DATE
, GPS.ADJUSTMENT_PERIOD_FLAG ADJUSTMENT_PERIOD_FLAG
, GPS.CLOSING_STATUS CLOSING_STATUS
, GPS.EFFECTIVE_PERIOD_NUM EFFECTIVE_PERIOD_NUM
FROM GL_PERIOD_STATUSES GPS
Columns
Name |
APPLICATION_ID |
LEDGER_ID |
PERIOD_NAME |
PERIOD_YEAR |
PERIOD_NUM |
QUARTER_NUM |
START_DATE |
END_DATE |
QUARTER_START_DATE |
YEAR_START_DATE |
ADJUSTMENT_PERIOD_FLAG |
CLOSING_STATUS |
EFFECTIVE_PERIOD_NUM |