View: RCI_FINANCIAL_LINE_V

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

View Text

SELECT AFIV.FINANCIAL_ITEM_ID AS ID
, AFIV.NAME AS VALUE
, AFSI.FINANCIAL_STATEMENT_ID AS FINANCIAL_STATEMENT_ID
FROM AMW_FIN_STMNT_ITEMS_B AFSI
, (SELECT AXE.AXIS_SET_ID AS FINANCIAL_STATEMENT_ID
, AXE.SEQUENCE AS FINANCIAL_ITEM_ID
, AXE.NAME
, AXE.DESCRIPTION
, AXE.DISPLAY_FLAG
, NULL AS PARENT_FINANCIAL_ITEM_ID
FROM RG_REPORT_AXES_V AXE
, RG_REPORT_AXIS_SETS_V AXI
WHERE AXI.AXIS_SET_TYPE='R'
AND AXE.DISPLAY_FLAG='Y'
AND AXE.AXIS_SET_ID = AXI.AXIS_SET_ID) AFIV
WHERE AFSI.FINANCIAL_ITEM_ID = AFIV.FINANCIAL_ITEM_ID AND AFSI.STATEMENT_GROUP_ID = ( SELECT MAX(STATEMENT_GROUP_ID) FROM AMW_FIN_STMNT_ITEMS_B AFSI_INNER WHERE AFSI_INNER.FINANCIAL_STATEMENT_ID = AFSI.FINANCIAL_STATEMENT_ID )

Columns