This View contains the definition for the Financial Statement Certification dimension
Implementation/DBA Data:
Not implemented in this database
View Text
SELECT ACB.CERTIFICATION_ID AS ID , ACTL.CERTIFICATION_NAME AS VALUE , FTEP.NAME AS PERIOD_NAME , FTEQ.NAME AS QTR_NAME , FTEY.NAME AS YEAR_NAME , FTD.ENT_PERIOD_ID AS ENT_PERIOD_ID , FTD.ENT_QTR_ID AS ENT_QTR_ID , FTD.ENT_YEAR_ID AS ENT_YEAR_ID FROM AMW_CERTIFICATION_B ACB , AMW_CERTIFICATION_TL ACTL , AMW_GL_PERIODS_V AGPV , FII_TIME_DAY FTD , FII_TIME_ENT_PERIOD FTEP , FII_TIME_ENT_QTR FTEQ , FII_TIME_ENT_YEAR FTEY WHERE ACB.CERTIFICATION_ID = ACTL.CERTIFICATION_ID AND ACB.OBJECT_TYPE = 'FIN_STMT' AND ACTL.LANGUAGE = USERENV('LANG') AND ACB.CERTIFICATION_PERIOD_NAME = AGPV.PERIOD_NAME AND ACB.CERTIFICATION_PERIOD_SET_NAME = AGPV.PERIOD_SET_NAME AND TO_NUMBER(TO_CHAR(AGPV.END_DATE , 'J')) = FTD.REPORT_DATE_JULIAN AND FTD.ENT_PERIOD_ID = FTEP.ENT_PERIOD_ID AND FTD.ENT_QTR_ID = FTEQ.ENT_QTR_ID AND FTD.ENT_YEAR_ID = FTEY.ENT_YEAR_ID