[Home] [Help]
View: GL_PERIOD_STATUSES_ENC_V
View Text
SELECT GPS.PERIOD_NAME PERIOD_NAME
, GPS.LEDGER_ID LEDGER_ID
, GPS.CLOSING_STATUS CLOSING_STATUS
, GPS.START_DATE START_DATE
, GPS.END_DATE END_DATE
, GPS.PERIOD_YEAR PERIOD_YEAR
, GPS.PERIOD_NUM PERIOD_NUM
, GPS.EFFECTIVE_PERIOD_NUM EFFECTIVE_PERIOD_NUM
FROM GL_PERIOD_STATUSES GPS
, GL_LEDGERS GLL
WHERE GPS.APPLICATION_ID = 101
AND GLL.LEDGER_ID = GPS.LEDGER_ID
AND GPS.PERIOD_YEAR <= GLL.LATEST_ENCUMBRANCE_YEAR
Columns
Name |
PERIOD_NAME |
LEDGER_ID |
CLOSING_STATUS |
START_DATE |
END_DATE |
PERIOD_YEAR |
PERIOD_NUM |
EFFECTIVE_PERIOD_NUM |