eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.RG_REPORT_STANDARD_AXES_VL

Source

View Text - Preformatted


SELECT AXS.APPLICATION_ID, AXS.STANDARD_AXIS_ID, AXS.LAST_UPDATE_DATE, AXS.LAST_UPDATED_BY, AXS.LAST_UPDATE_LOGIN, AXS.CREATION_DATE, AXS.CREATED_BY, AXT.STANDARD_AXIS_NAME, AXS.CLASS, AXS.DISPLAY_IN_STANDARD_LIST_FLAG, AXS.PRECEDENCE_LEVEL, AXS.DATABASE_COLUMN, AXS.SIMPLE_WHERE_NAME, AXS.PERIOD_QUERY, AXS.STANDARD_AXIS1_ID, AXS.AXIS1_OPERATOR, AXS.STANDARD_AXIS2_ID, AXS.AXIS2_OPERATOR, AXS.CONSTANT, AXT.DESCRIPTION, AXS.VARIANCE_FLAG, AXS.SIGN_FLAG FROM RG_REPORT_STANDARD_AXES_B AXS, RG_REPORT_STANDARD_AXES_TL AXT WHERE AXS.STANDARD_AXIS_ID = AXT.STANDARD_AXIS_ID AND AXT.LANGUAGE = USERENV('LANG')

View Text - HTML Formatted

SELECT AXS.APPLICATION_ID
, AXS.STANDARD_AXIS_ID
, AXS.LAST_UPDATE_DATE
, AXS.LAST_UPDATED_BY
, AXS.LAST_UPDATE_LOGIN
, AXS.CREATION_DATE
, AXS.CREATED_BY
, AXT.STANDARD_AXIS_NAME
, AXS.CLASS
, AXS.DISPLAY_IN_STANDARD_LIST_FLAG
, AXS.PRECEDENCE_LEVEL
, AXS.DATABASE_COLUMN
, AXS.SIMPLE_WHERE_NAME
, AXS.PERIOD_QUERY
, AXS.STANDARD_AXIS1_ID
, AXS.AXIS1_OPERATOR
, AXS.STANDARD_AXIS2_ID
, AXS.AXIS2_OPERATOR
, AXS.CONSTANT
, AXT.DESCRIPTION
, AXS.VARIANCE_FLAG
, AXS.SIGN_FLAG
FROM RG_REPORT_STANDARD_AXES_B AXS
, RG_REPORT_STANDARD_AXES_TL AXT
WHERE AXS.STANDARD_AXIS_ID = AXT.STANDARD_AXIS_ID
AND AXT.LANGUAGE = USERENV('LANG')