Product: | GL - General Ledger |
---|---|
Description: | 10SC ONLY |
Implementation/DBA Data: | APPS.GL_PERIODS_V |
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