View: GL_PERIOD_STATUSES_BUD_V

Product:	GL - General Ledger
Description:
Implementation/DBA Data:	APPS.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