Product: | OKL - Lease and Finance Management |
---|---|
Description: | |
Implementation/DBA Data: | APPS.OKL_PERIOD_TYPES_UV |
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