[Home] [Help]
View: GL_PERIOD_STATUSES_BUD_V
View Text
SELECT PS.PERIOD_NAME PERIOD_NAME
, BV.BUDGET_VERSION_ID BUDGET_VERSION_ID
, PS.START_DATE START_DATE
, PS.END_DATE END_DATE
, PS.PERIOD_YEAR PERIOD_YEAR
, PS.PERIOD_NUM PERIOD_NUM
, PS.QUARTER_NUM QUARTER_NUM
, PS.LEDGER_ID LEDGER_ID
FROM GL_BUDGET_VERSIONS BV
, GL_BUDGETS BUD
, GL_BUDGET_PERIOD_RANGES BPR
, GL_PERIOD_STATUSES PS
WHERE BUD.BUDGET_TYPE = BV.BUDGET_TYPE
AND BUD.BUDGET_NAME = BV.BUDGET_NAME
AND BPR.BUDGET_VERSION_ID = BV.BUDGET_VERSION_ID
AND BPR.PERIOD_YEAR = PS.PERIOD_YEAR
AND BPR.OPEN_FLAG = 'O'
AND PS.APPLICATION_ID = 101
AND PS.LEDGER_ID = BUD.LEDGER_ID
AND PS.EFFECTIVE_PERIOD_NUM BETWEEN BPR.PERIOD_YEAR * 10000 + BPR.START_PERIOD_NUM
AND BPR.PERIOD_YEAR * 10000 + BPR.END_PERIOD_NUM
Columns
Name |
PERIOD_NAME |
BUDGET_VERSION_ID |
START_DATE |
END_DATE |
PERIOD_YEAR |
PERIOD_NUM |
QUARTER_NUM |
LEDGER_ID |