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.

[Home] [Help]

View: RG_REPORT_STANDARD_AXES_VL

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

View Text

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')

Columns

Name
APPLICATION_ID
STANDARD_AXIS_ID
LAST_UPDATE_DATE
LAST_UPDATED_BY
LAST_UPDATE_LOGIN
CREATION_DATE
CREATED_BY
STANDARD_AXIS_NAME
CLASS
DISPLAY_IN_STANDARD_LIST_FLAG
PRECEDENCE_LEVEL
DATABASE_COLUMN
SIMPLE_WHERE_NAME
PERIOD_QUERY
STANDARD_AXIS1_ID
AXIS1_OPERATOR
STANDARD_AXIS2_ID
AXIS2_OPERATOR
CONSTANT
DESCRIPTION
VARIANCE_FLAG
SIGN_FLAG