DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.RG_REPORT_STANDARD_AXES_VL

Object Details
Object Name: RG_REPORT_STANDARD_AXES_VL
Object Type: VIEW
Owner: APPS
FND Design Data: ViewRG.RG_REPORT_STANDARD_AXES_VL
Subobject Name:
Status: VALID

View Type

MultiLingual view (a language resolved view of the data.)

[View Source]

Columns
Name Datatype Length Mandatory Comments
APPLICATION_ID NUMBER (15) Yes Application defining column
STANDARD_AXIS_ID NUMBER (15) Yes Standard axis defining column
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER (15) Yes Standard Who column
LAST_UPDATE_LOGIN NUMBER (15) Yes Standard Who column
CREATION_DATE DATE
Yes Standard Who column
CREATED_BY NUMBER (15) Yes Standard Who column
STANDARD_AXIS_NAME VARCHAR2 (30) Yes Name of standard axis
CLASS VARCHAR2 (1) Yes Class of standard axis, calculated or primitive
DISPLAY_IN_STANDARD_LIST_FLAG VARCHAR2 (1) Yes Indicated whether to display in quickpick
PRECEDENCE_LEVEL NUMBER (2) Yes Determine which precedence level this amount type should use in calculation
DATABASE_COLUMN VARCHAR2 (30)
Indicates column in the data storage table to find the standard axis
SIMPLE_WHERE_NAME VARCHAR2 (30)
Query for this standard axis
PERIOD_QUERY CLOB (4000)
Query to find the period name
STANDARD_AXIS1_ID NUMBER (15)
First amount type that used to create this one
AXIS1_OPERATOR VARCHAR2 (1)
Operator used in first amount type
STANDARD_AXIS2_ID NUMBER (15)
Second amount type that use to create this one
AXIS2_OPERATOR VARCHAR2 (1)
Operator used in second amount type
CONSTANT NUMBER

Constant used for calculation
DESCRIPTION VARCHAR2 (240)
Description of standard axis
VARIANCE_FLAG VARCHAR2 (1)
Determine whether amount type is variance
SIGN_FLAG VARCHAR2 (1)
No longer used
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT 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
FROM APPS.RG_REPORT_STANDARD_AXES_VL;

Dependencies

[top of page]

APPS.RG_REPORT_STANDARD_AXES_VL references the following:

SchemaAPPS
SynonymRG_REPORT_STANDARD_AXES_B
SynonymRG_REPORT_STANDARD_AXES_TL

APPS.RG_REPORT_STANDARD_AXES_VL is not referenced by any database object