This View contains the definition for the Organization Financial Statement dimension
Implementation/DBA Data:
Not implemented in this database
View Text
SELECT DISTINCT AFSB.FINANCIAL_STATEMENT_ID AS ID , AFSTL.NAME AS VALUE FROM AMW_FIN_STMNT_B AFSB , AMW_FIN_STMNT_TL AFSTL , AMW_FIN_ITEMS_KEY_ACC AFIKA WHERE AFSB.STATEMENT_GROUP_ID = AFSTL.STATEMENT_GROUP_ID AND AFSB.FINANCIAL_STATEMENT_ID = AFSTL.FINANCIAL_STATEMENT_ID AND AFSB.END_DATE IS NULL AND AFSTL.LANGUAGE = USERENV('LANG') AND AFSB.STATEMENT_GROUP_ID = AFIKA.STATEMENT_GROUP_ID AND AFSB.FINANCIAL_STATEMENT_ID = AFIKA.FINANCIAL_STATEMENT_ID