VIEW: APPS.AMW_FINANCIAL_ITEMS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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