VIEW: APPS.RG_REPORT_AXES_V

Source

View Text - Preformatted

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(+)

View Text - HTML Formatted

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(+)