VIEW: APPS.GL_PERIODS_V

Source

View Text - Preformatted

SELECT per.rowid ROW_ID, per.period_name PERIOD_NAME, per.period_set_name PERIOD_SET_NAME, per.start_date START_DATE, per.end_date END_DATE, per.period_type PERIOD_TYPE, pt.user_period_type USER_PERIOD_TYPE, per.period_year PERIOD_YEAR, per.period_num PERIOD_NUM, per.quarter_num QUARTER_NUM, per.entered_period_name ENTERED_PERIOD_NAME, per.adjustment_period_flag ADJUSTMENT_PERIOD_FLAG, pt.number_per_fiscal_year NUMBER_PER_FISCAL_YEAR, per.description DESCRIPTION, per.creation_date CREATION_DATE, per.created_by CREATED_BY, per.last_update_date LAST_UPDATE_DATE, per.last_updated_by LAST_UPDATED_BY, per.last_update_login LAST_UPDATE_LOGIN, per.context CONTEXT, per.attribute1 ATTRIBUTE1, per.attribute2 ATTRIBUTE2, per.attribute3 ATTRIBUTE3, per.attribute4 ATTRIBUTE4, per.attribute5 ATTRIBUTE5, per.attribute6 ATTRIBUTE6, per.attribute7 ATTRIBUTE7, per.attribute8 ATTRIBUTE8 FROM gl_periods per, gl_period_types pt WHERE per.period_type = pt.period_type

View Text - HTML Formatted

SELECT PER.ROWID ROW_ID
, PER.PERIOD_NAME PERIOD_NAME
, PER.PERIOD_SET_NAME PERIOD_SET_NAME
, PER.START_DATE START_DATE
, PER.END_DATE END_DATE
, PER.PERIOD_TYPE PERIOD_TYPE
, PT.USER_PERIOD_TYPE USER_PERIOD_TYPE
, PER.PERIOD_YEAR PERIOD_YEAR
, PER.PERIOD_NUM PERIOD_NUM
, PER.QUARTER_NUM QUARTER_NUM
, PER.ENTERED_PERIOD_NAME ENTERED_PERIOD_NAME
, PER.ADJUSTMENT_PERIOD_FLAG ADJUSTMENT_PERIOD_FLAG
, PT.NUMBER_PER_FISCAL_YEAR NUMBER_PER_FISCAL_YEAR
, PER.DESCRIPTION DESCRIPTION
, PER.CREATION_DATE CREATION_DATE
, PER.CREATED_BY CREATED_BY
, PER.LAST_UPDATE_DATE LAST_UPDATE_DATE
, PER.LAST_UPDATED_BY LAST_UPDATED_BY
, PER.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, PER.CONTEXT CONTEXT
, PER.ATTRIBUTE1 ATTRIBUTE1
, PER.ATTRIBUTE2 ATTRIBUTE2
, PER.ATTRIBUTE3 ATTRIBUTE3
, PER.ATTRIBUTE4 ATTRIBUTE4
, PER.ATTRIBUTE5 ATTRIBUTE5
, PER.ATTRIBUTE6 ATTRIBUTE6
, PER.ATTRIBUTE7 ATTRIBUTE7
, PER.ATTRIBUTE8 ATTRIBUTE8
FROM GL_PERIODS PER
, GL_PERIOD_TYPES PT
WHERE PER.PERIOD_TYPE = PT.PERIOD_TYPE