VIEW: APPS.OKL_PERIOD_TYPES_UV

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, okl_accounting_util.get_lookup_meaning('YEAR_TYPE_IN_NAME', pt.YEAR_TYPE_IN_NAME, 101, 101) YEAR_TYPE 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
, OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('YEAR_TYPE_IN_NAME'
, PT.YEAR_TYPE_IN_NAME
, 101
, 101) YEAR_TYPE
FROM GL_PERIODS PER
, GL_PERIOD_TYPES PT
WHERE PER.PERIOD_TYPE = PT.PERIOD_TYPE