DBA Data[Home] [Help]

VIEW: APPS.AMW_GL_PERIODS_V

Source

View Text - Preformatted

SELECT PERIOD_NAME, PERIOD_SET_NAME, START_DATE, END_DATE, PERIOD_TYPE, USER_PERIOD_TYPE, PERIOD_YEAR, PERIOD_NUM, QUARTER_NUM, ENTERED_PERIOD_NAME, ADJUSTMENT_PERIOD_FLAG, NUMBER_PER_FISCAL_YEAR, DESCRIPTION FROM GL_PERIODS_V WHERE PERIOD_SET_NAME = FND_PROFILE.Value('AMW_CALENDAR')
View Text - HTML Formatted

SELECT PERIOD_NAME
, PERIOD_SET_NAME
, START_DATE
, END_DATE
, PERIOD_TYPE
, USER_PERIOD_TYPE
, PERIOD_YEAR
, PERIOD_NUM
, QUARTER_NUM
, ENTERED_PERIOD_NAME
, ADJUSTMENT_PERIOD_FLAG
, NUMBER_PER_FISCAL_YEAR
, DESCRIPTION
FROM GL_PERIODS_V
WHERE PERIOD_SET_NAME = FND_PROFILE.VALUE('AMW_CALENDAR')