View: RCI_FINANCIAL_STATEMENT_V

Product:	AMW - Internal Controls Manager
Description:	This View contains the definition for the Organization Financial Statement dimension
Implementation/DBA Data:	APPS.RCI_FINANCIAL_STATEMENT_V

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

Columns