View: GL_PERIOD_STAT_BUD_PERA_V

View Text

SELECT PS.PERIOD_NAME PERIOD_NAME
, PS.SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, PS.PERIOD_NUM PERIOD_NUM
, PS.PERIOD_YEAR PERIOD_YEAR
, PS.START_DATE START_DATE
, PS.END_DATE END_DATE
FROM GL_PERIOD_STATUSES PS
WHERE PS.APPLICATION_ID = 101
AND PS.PERIOD_YEAR IN ( SELECT DISTINCT BPR.PERIOD_YEAR
FROM GL_BUDGET_PERIOD_RANGES BPR
, GL_BUDGET_VERSIONS BV
, GL_BUDGETS B
WHERE BPR.BUDGET_VERSION_ID = BV.BUDGET_VERSION_ID
AND BV.BUDGET_NAME = B.BUDGET_NAME
AND B.SET_OF_BOOKS_ID = PS.SET_OF_BOOKS_ID)

Columns