[Home] [Help]
View: GL_PERIOD_STAT_BUD_PERA_V
Product: | GL - General Ledger |
Description: | |
Implementation/DBA Data: |
Not implemented in this database
|
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
Name |
PERIOD_NAME |
SET_OF_BOOKS_ID |
PERIOD_NUM |
PERIOD_YEAR |
START_DATE |
END_DATE |