[Home] [Help]
View: AMW_GL_PERIODS_V
Product: | AMW - Internal Controls Manager (Obsolete) |
Description: | Stores Information of General Ledger Periods |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
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')
Columns
Name |
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 |