View: RG_REPORT_AXES_V

Product:	RG - Application Report Generator
Description:
Implementation/DBA Data:	APPS.RG_REPORT_AXES_V

View Text

SELECT AXES.ROWID
, AXES.APPLICATION_ID
, AXES.AXIS_SET_ID
, AXES.AXIS_SEQ
, AXES.LAST_UPDATE_DATE
, AXES.LAST_UPDATED_BY
, AXES.LAST_UPDATE_LOGIN
, AXES.CREATION_DATE
, AXES.CREATED_BY
, AXES.AXIS_TYPE
, AXES.AXIS_NAME
, AXES.AMOUNT_ID
, STD.STANDARD_AXIS_NAME
, AXES.STANDARD_AXIS_ID
, AXES.WIDTH
, AXES.POSITION
, AXES.STRUCTURE_ID
, AXES.UNIT_OF_MEASURE_ID
, AXES.PARAMETER_NUM
, AXES.PERIOD_OFFSET
, AXES.DESCRIPTION
, AXES.DISPLAY_FLAG
, AXES.BEFORE_AXIS_STRING
, AXES.AFTER_AXIS_STRING
, AXES.NUMBER_CHARACTERS_INDENTED
, AXES.PAGE_BREAK_AFTER_FLAG
, AXES.PAGE_BREAK_BEFORE_FLAG
, AXES.NUMBER_LINES_SKIPPED_BEFORE
, AXES.NUMBER_LINES_SKIPPED_AFTER
, L1.MEANING
, AXES.DISPLAY_LEVEL
, AXES.DISPLAY_ZERO_AMOUNT_FLAG
, AXES.CHANGE_SIGN_FLAG
, AXES.CHANGE_VARIANCE_SIGN_FLAG
, L2.MEANING
, AXES.DISPLAY_UNITS
, AXES.DISPLAY_FORMAT
, AXES.CALCULATION_PRECEDENCE_FLAG
, AXES.PERCENTAGE_DIVISOR_SEQ
, AXES.TRANSACTION_FLAG
, AXES.FORMAT_BEFORE_TEXT
, AXES.FORMAT_AFTER_TEXT
, AXES.FORMAT_MASK_WIDTH
, AXES.DISPLAY_PRECISION
, AXES.SEGMENT_OVERRIDE_VALUE
, AXES.OVERRIDE_ALC_LEDGER_CURRENCY
, AXES.CONTEXT
, AXES.ATTRIBUTE1
, AXES.ATTRIBUTE2
, AXES.ATTRIBUTE3
, AXES.ATTRIBUTE4
, AXES.ATTRIBUTE5
, AXES.ATTRIBUTE6
, AXES.ATTRIBUTE7
, AXES.ATTRIBUTE8
, AXES.ATTRIBUTE9
, AXES.ATTRIBUTE10
, AXES.ATTRIBUTE11
, AXES.ATTRIBUTE12
, AXES.ATTRIBUTE13
, AXES.ATTRIBUTE14
, AXES.ATTRIBUTE15
, ELM.ELEMENT_ID
, ELM.ELEMENT_NAME
, NVL(ELM.ELEMENT_LABEL
, ELM.ELEMENT_NAME)
FROM RG_REPORT_AXES AXES
, RG_REPORT_STANDARD_AXES_TL STD
, RG_XBRL_ELEMENTS ELM
, RG_LOOKUPS L1
, RG_LOOKUPS L2
WHERE AXES.STANDARD_AXIS_ID = STD.STANDARD_AXIS_ID(+)
AND STD.LANGUAGE(+) = USERENV('LANG')
AND L1.LOOKUP_TYPE(+) = 'GL_DISPLAY_LEVEL'
AND L1.LOOKUP_CODE(+) = AXES.DISPLAY_LEVEL
AND L2.LOOKUP_TYPE(+) = 'DISPLAY_UNITS'
AND L2.LOOKUP_CODE(+) = TO_CHAR(AXES.DISPLAY_UNITS)
AND AXES.ELEMENT_ID = ELM.ELEMENT_ID(+)

Columns