VIEW: APPS.RCI_FINANCIAL_LINE_V

Source

View Text - Preformatted

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 )

View Text - HTML Formatted

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 )