FND Design Data [Home] [Help]

View: GL_CONS_BUDGET_PERIODS_V

Product: GL - General Ledger
Description: 10SC ONLY
Implementation/DBA Data: ViewAPPS.GL_CONS_BUDGET_PERIODS_V
View Text

SELECT DISTINCT BP.PERIOD_NAME
, BP.PERIOD_YEAR
, BP.PERIOD_NUM
, BP.BUDGET_VERSION_ID
FROM GL_PERIOD_STATUSES_BUD_V BP UNION SELECT L.MEANING
, 0
, 0
, -1
FROM GL_LOOKUPS L
WHERE L.LOOKUP_TYPE = 'LITERAL'
AND L.LOOKUP_CODE = 'ALL'

Columns

Name
PERIOD_NAME
PERIOD_YEAR
PERIOD_NUM
BUDGET_VERSION_ID