GL_FISCAL_PERIOD_V

Details

• Schema: FUSION

• Object owner: GL

• Object type: VIEW

Columns

Name
FISCAL_PERIOD_SET_ID FISCAL_PERIOD_SET_NAME ADJUSTMENT_PERIOD_FLAG FISCAL_PERIOD_TYPE FISCAL_PERIOD_NAME FISCAL_PERIOD_NUMBER FISCAL_QUARTER_NUMBER FISCAL_YEAR_NUMBER FISCAL_PERIOD_START_DATE FISCAL_PERIOD_END_DATE FISCAL_QUARTER_START_DATE FISCAL_QUARTER_END_DATE FISCAL_YEAR_START_DATE FISCAL_YEAR_END_DATE FISCAL_PERIODSET_CREATION_DATE FISCAL_PERIOD_CREATION_DATE FISCAL_PERIOD_LAST_UPDATE_DATE

Query

SQL_Statement

SELECT GLPS.PERIOD_SET_ID Fiscal_Period_Set_Id, GLP.PERIOD_SET_NAME Fiscal_Period_Set_Name, GLP.ADJUSTMENT_PERIOD_FLAG Adjustment_Period_Flag, GLP.PERIOD_TYPE Fiscal_Period_Type, GLP.PERIOD_NAME Fiscal_Period_Name, GLP.PERIOD_NUM Fiscal_Period_Number, GLP.QUARTER_NUM Fiscal_Quarter_number, GLP.PERIOD_YEAR Fiscal_Year_Number, GLP.START_DATE Fiscal_Period_Start_Date, GLP.END_DATE Fiscal_Period_End_Date, GLP.QUARTER_START_DATE Fiscal_Quarter_Start_Date, MAX (END_DATE) OVER (PARTITION BY GLPS.PERIOD_SET_ID, GLP.PERIOD_TYPE, GLP.PERIOD_YEAR, GLP.QUARTER_NUM) Fiscal_Quarter_End_Date, GLP.YEAR_START_DATE Fiscal_Year_Start_Date, MAX (END_DATE) OVER (PARTITION BY GLPS.PERIOD_SET_ID, GLP.PERIOD_TYPE, GLP.PERIOD_YEAR) Fiscal_Year_End_Date, GLPS.CREATION_DATE FISCAL_PERIODSET_CREATION_DATE, GLP.CREATION_DATE FISCAL_PERIOD_CREATION_DATE, GLP.LAST_UPDATE_DATE FISCAL_PERIOD_LAST_UPDATE_DATE FROM GL_PERIODS GLP, GL_PERIOD_SETS GLPS WHERE GLP.PERIOD_SET_NAME = GLPS.PERIOD_SET_NAME