Oracle eBusiness Suite Technical Reference

Release 11i - Copyright (c) 2001 - 2005 Oracle

This Technical Reference Manual (TRM) in any form, software or printed matter, contains proprietary information of Oracle ; it is provided under an Oracle agreement containing restrictions on use and disclosure and is also protected by copyright, patent, and other intellectual property law. Restrictions applicable to this TRM include, but are not limited to: (a) exercising either the same degree of care to safeguard the confidentiality of this TRM as you exercise to safeguard the confidentiality of your own most important Confidential Information or a reasonable degree of care, whichever is greater; (b) maintaining agreements with your employees and agents that protect the Confidential Information of third parties such as Oracle and instructing such employees and agents of these requirements for this TRM; (c) restricting disclosure of this TRM to those of your employees who have a 'need to know' consistent with the purposes for which this TRM was disclosed to you; (d) maintaining this TRM at all times on your premises; (e) not removing or destroying any proprietary or confidential legends or markings placed upon this TRM in whatever form, software or printed matter; and (f) not reproducing or transmitting this TRM in any form or by any means, electronic or mechanical, for any purpose, without the express written permission of Oracle. You should not use this TRM in any form, software or printed matter, to create software that performs the same or similar functions as any Oracle products.

The information in this TRM is subject to change without notice. If you find any problems in the TRM in any form, software or printed matter, please report them to us in writing. Oracle does not warrant that this TRM is error free. This TRM is provided to customer 'as is' with no warranty of any kind. This TRM does not constitute Documentation as that term is defined in Oracle's agreements. Reverse engineering of the Programs (software and documentation) associated with this TRM are prohibited. The Programs associated with this TRM are not intended for use in any nuclear, aviation, mass transit, medical, or other inherently dangerous applications. It shall be licensee's responsibility to take all appropriate fail safe, backup, redundancy and other measures to ensure the safe use of such applications if the Programs are used for such purposes, and Oracle disclaims liability for any damages caused by such use of the Programs. Program Documentation is licensed for use solely to support the deployment of the Programs and not for any other any other purpose. Restricted Rights Legend

This TRM and the Programs associated with this TRM delivered subject to the DOD FAR Supplement are 'commercial computer software' and use, duplication and disclosure of the TRM and the Programs associated with this TRM shall be subject to the licensing restrictions set forth in the applicable Oracle license agreement. Otherwise, this TRM and the Programs associated with this TRM delivered subject to the Federal Acquisition Regulations are 'restricted computer software' and use, duplication and disclosure of the TRM and the Programs associated with this TRM shall be subject to the restrictions in FAR 52.227-14, Rights in Data General, including Alternate III (June 1987). Oracle, 500 Oracle Parkway, Redwood City, CA 94065.

Oracle is a registered trademark. AIM Advantage™, Big Business. Small Business. All Business.™, CDM Advantage™, .comference™, ConText®, Des40®, Easy*Query™, Easy*SQL®, Education Objects™, EMM Advantage™, Enabling the Information Age®, ExpertDetectSM, Express®, FastForwardSM, GEMMS®, Gist™, Hyper*SQL™, instantOracle™, "Internet Business Intelligence - Insight for Everyone"™, iSQL*Plus™, JInitiator™, NLS*Workbench®, Object Marketplace™, ODP Pulse™, ODP Techwire™, OLA™, On Oracle™, Oracle®, Oracle Book®, Oracle Bookbatch®, Oracle BookBuilder®, OracleBRONZE®, Oracle Business OnLine®, OracleDevConnectSM, Oracle® Discoverer™, Oracle® Expert™, Oracle Financials®, OracleGOLDSM, OracleIncidentSM, OracleJSP™, OracleLifeCycleSM, Oracle Media Objects®, OracleMERCURYSM, OracleMetaLinkSM, OraclemetalsSM, OracleMobile™, Oracle Names®, Oracle NetSolutions®, Oracle® One™, Oracle Open Gateways®, Oracle OpenWorld®, OraclePLATINUMSM, Oracle Power Objects®, Oracle Press®, Oracle Procedural Gateway®, Oracle Quality®, Oracle Secure Network Services®, OracleSILVERSM, Oracle® SQL/Services™, Oracle® SQL*TutorSM, OracleSTERLINGSM, Oracle Store®, Oracle Transparent Gateway®, OracleWare®, Oracle8i™, Oracle9i™, PC Express®, Personal Express®, PJM Advantage™, PL/SQL™, Pro*Ada®, Pro*C™, Pro*C/C++™, Pro*COBOL®, Pro*FORTRAN®, Pro*Pascal®, Pro*PL/1®, Pro*REXX®, Profit™, ProREXX™, Report Card™, Secure Access 2.0™, Secure Network Services®, Security Without Compromise™, SellingPoint®, SQL*Plus®, Tutor™ are trademarks or registered trademarks of Oracle. Other names may be trademarks of their respective owners. The absence of a product or service name, slogan, or logo from this list does not constitute a waiver of Oracle's trademark or other intellectual property rights concerning that name, slogan, or logo.

eTRM - RG Tables and Views

TABLE - RG.RG_DATABASE_LINKS
TABLE - RG.RG_DSS_DIMENSIONS
TABLE - RG.RG_DSS_DIM_SEGMENTS
TABLE - RG.RG_DSS_HIERARCHIES
TABLE - RG.RG_DSS_HIERARCHY_DETAILS
TABLE - RG.RG_DSS_REQUESTS
TABLE - RG.RG_DSS_SEG_RANGES
TABLE - RG.RG_DSS_SEG_RANGE_SETS
TABLE - RG.RG_DSS_SYSTEMS
TABLE - RG.RG_DSS_SYSTEM_SEG_ORDER
TABLE - RG.RG_DSS_SYSTEM_VARIABLES
TABLE - RG.RG_DSS_VARIABLES
TABLE - RG.RG_DSS_VAR_DIMENSIONS
TABLE - RG.RG_DSS_VAR_SELECTIONS
TABLE - RG.RG_DSS_VAR_TEMPLATES
TABLE - RG.RG_REPORTS
TABLE - RG.RG_REPORT_AXES
TABLE - RG.RG_REPORT_AXIS_CONTENTS
TABLE - RG.RG_REPORT_AXIS_SETS
TABLE - RG.RG_REPORT_CALCULATIONS
TABLE - RG.RG_REPORT_CONTENT_OVERRIDES
TABLE - RG.RG_REPORT_CONTENT_SETS
TABLE - RG.RG_REPORT_DISPLAYS
TABLE - RG.RG_REPORT_DISPLAY_GROUPS
TABLE - RG.RG_REPORT_DISPLAY_SETS
TABLE - RG.RG_REPORT_EXCEPTIONS
TABLE - RG.RG_REPORT_EXCEPTION_FLAGS
TABLE - RG.RG_REPORT_PARAMETERS
TABLE - RG.RG_REPORT_REQUESTS
TABLE - RG.RG_REPORT_REQUEST_LOBS
TABLE - RG.RG_REPORT_SETS
TABLE - RG.RG_REPORT_SET_REQUESTS
TABLE - RG.RG_REPORT_SET_REQ_DETAILS
TABLE - RG.RG_REPORT_STANDARD_AXES_B
TABLE - RG.RG_REPORT_STANDARD_AXES_TL
TABLE - RG.RG_REPORT_SUB_REQUEST_RUNS
TABLE - RG.RG_ROW_ORDERS
TABLE - RG.RG_ROW_SEGMENT_SEQUENCES
TABLE - RG.RG_SIMPLE_WHERE_CLAUSES
TABLE - RG.RG_TABLE_SIZES
TABLE - RG.RG_XBRL_ELEMENTS
TABLE - RG.RG_XBRL_MAP_ELEMENTS
TABLE - RG.RG_XBRL_TAXONOMIES
VIEW - APPS.RG_BUDGETS_V
VIEW - APPS.RG_CONSTANT_PERIODS_V
VIEW - APPS.RG_CURRENCIES_V
VIEW - APPS.RG_DSS_DIM_SEGMENTS_V
VIEW - APPS.RG_DSS_HIERARCHIES_V
VIEW - APPS.RG_DSS_HIERARCHY_DETAILS_V
VIEW - APPS.RG_DSS_REQUESTS_V
VIEW - APPS.RG_DSS_SEG_RANGE_SETS_V
VIEW - APPS.RG_DSS_SYSTEM_SEG_ORDER_V
VIEW - APPS.RG_DSS_SYSTEM_VARIABLES_V
VIEW - APPS.RG_DSS_VARIABLES_V
VIEW - APPS.RG_DSS_VAR_DIMENSIONS_V
VIEW - APPS.RG_DSS_VAR_SELECTIONS_V
VIEW - APPS.RG_DSS_VAR_TEMPLATES_V
VIEW - APPS.RG_ENCUMBRANCES_V
VIEW - APPS.RG_FACTOR_V
VIEW - APPS.RG_LEVEL_OF_DETAIL_V
VIEW - APPS.RG_LOOKUPS
VIEW - APPS.RG_PERIOD_YEARS_V
VIEW - APPS.RG_REPORTS_V
VIEW - APPS.RG_REPORT_AXES_V
VIEW - APPS.RG_REPORT_AXIS_SETS_LOV_V
VIEW - APPS.RG_REPORT_AXIS_SETS_V
VIEW - APPS.RG_REPORT_DISPLAYS_V
VIEW - APPS.RG_REPORT_DISPLAY_GROUPS_V
VIEW - APPS.RG_REPORT_DISPLAY_SETS_V
VIEW - APPS.RG_REPORT_NAME_V
VIEW - APPS.RG_REPORT_REQUESTS_V
VIEW - APPS.RG_REPORT_SET_NAME_V
VIEW - APPS.RG_REPORT_STANDARD_AXES_VL
VIEW - APPS.RG_ROW_SEGMENT_SEQUENCES_V
VIEW - APPS.RG_SRS_DSS_BUD_ENC_V
VIEW - APPS.RG_SRS_DSS_DOP_V
VIEW - APPS.RG_SRS_DSS_HIERARCHIES_V
VIEW - APPS.RG_SRS_DSS_TEMPLATE_V
VIEW - APPS.RG_XBRL_MAP_V

Table: RG_DATABASE_LINKS

Description: Database link definitions
Primary Key: RG_DATABASE_LINKS_PK
  1. DATABASE_LINK_ID
Comments

RG_DATABASE_LINKS stores information about the database links you define using the Database Links form. Each row includes the name of the link (NAME), the connect string (CONNECT_STRING), the domain name (DOMAIN_NAME), and the apps account (APPS_USERNAME) of the database you are linking to.
The information stored here is used in the list of values for the Source Database field while submitting FSG Transfer requests.

Indexes
Index Type Tablespace Column
RG_DATABASE_LINKS_U1 UNIQUE APPS_TS_TX_IDX DATABASE_LINK_ID
RG_DATABASE_LINKS_U2 UNIQUE APPS_TS_TX_IDX NAME
Columns
Name Datatype Length Mandatory Comments
DATABASE_LINK_ID NUMBER (15) Y Database Link defining column
NAME VARCHAR2 (30) Y Database Link name
DESCRIPTION VARCHAR2 (240)
Database Link description
CONNECT_STRING VARCHAR2 (150) Y Connect string for destination database
DOMAIN_NAME VARCHAR2 (150) Y Domain name for destination database
APPS_USERNAME VARCHAR2 (30) Y Apps account username for destination database
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15) Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER (15) Y Standard Who column
CONTEXT VARCHAR2 (30)
Descriptive Flexfield context
ATTRIBUTE1 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE11 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive Flexfield segment

[top of page]

RG.RG_DATABASE_LINKS does not reference any database object

RG.RG_DATABASE_LINKS is referenced by following:

RG
VIEW - RG_DATABASE_LINKS#

[top of page]

Table: RG_DSS_DIMENSIONS

Description: Financial Analyzer dimensions
Primary Key: RG_DSS_DIMENSIONS_PK
  1. DIMENSION_ID
Primary Key: RG_DSS_DIMENSIONS_UK1
  1. NAME
Primary Key: RG_DSS_DIMENSIONS_UK2
  1. OBJECT_NAME
Foreign Keys to this table:
Foreign Key Column Foreign Table
RG_DSS_DIM_SEGMENTS.DIMENSION_ID RG_DSS_DIMENSIONS
RG_DSS_HIERARCHIES.DIMENSION_ID RG_DSS_DIMENSIONS
RG_DSS_VAR_DIMENSIONS.DIMENSION_ID RG_DSS_DIMENSIONS
Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

Indexes
Index Type Tablespace Column
RG_DSS_DIMENSIONS_U1 UNIQUE APPS_TS_TX_IDX DIMENSION_ID
ZD_EDITION_NAME
RG_DSS_DIMENSIONS_U2 UNIQUE APPS_TS_TX_IDX NAME
ZD_EDITION_NAME
RG_DSS_DIMENSIONS_U3 UNIQUE APPS_TS_TX_IDX OBJECT_NAME
ZD_EDITION_NAME
Columns
Name Datatype Length Mandatory Comments
DIMENSION_ID NUMBER (15) Y Dimension defining column
NAME VARCHAR2 (60) Y Dimension name
OBJECT_NAME VARCHAR2 (16) Y Unique name of the dimension used by Financial Analyzer
OBJECT_PREFIX VARCHAR2 (6) Y Dimension's identifying prefix
VALUE_PREFIX VARCHAR2 (1) Y Prefix of dimension values
ROW_LABEL VARCHAR2 (1) Y Value used for row label (Value, Description, or Both)
COLUMN_LABEL VARCHAR2 (1) Y Value used for column label (Value, Description, or Both)
SELECTOR_LABEL VARCHAR2 (1) Y Value used for selector label (Value, Description, or Both)
LEVEL_CODE VARCHAR2 (1) Y Dimension level (Summary or Detail)
DIMENSION_TYPE VARCHAR2 (1) Y Dimension Type (Primitive, Single Segment, Multiple Segments, or Time)
DIMENSION_BY_CURRENCY VARCHAR2 (1) Y Not currently used
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15) Y Standard Who column
ID_FLEX_CODE VARCHAR2 (4)
Key flexfield code
ID_FLEX_NUM NUMBER (15)
Key flexfield structure number
DESCRIPTION VARCHAR2 (240)
Dimension description
CONTEXT VARCHAR2 (150)
Descriptive Flexfield context
ATTRIBUTE1 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE11 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive Flexfield segment
ZD_EDITION_NAME VARCHAR2 (30) Y

[top of page]

RG.RG_DSS_DIMENSIONS does not reference any database object

RG.RG_DSS_DIMENSIONS is referenced by following:

RG
VIEW - RG_DSS_DIMENSIONS#

[top of page]

Table: RG_DSS_DIM_SEGMENTS

Description: Financial Analyzer dimension segment mappings
Primary Key: RG_DSS_DIM_SEGMENTS_PK
  1. DIMENSION_ID
  2. SEQUENCE
Primary Key: RG_DSS_DIM_SEGMENTS_UK1
  1. DIMENSION_ID
  2. APPLICATION_COLUMN_NAME
Foreign Keys from this table:
Foreign Key Column Foreign Table
RG_DSS_DIM_SEGMENTS.RANGE_SET_ID RG_DSS_SEG_RANGE_SETS
RG_DSS_DIM_SEGMENTS.DIMENSION_ID RG_DSS_DIMENSIONS
Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

Indexes
Index Type Tablespace Column
RG_DSS_DIM_SEGMENTS_U1 UNIQUE APPS_TS_TX_IDX DIMENSION_ID
SEQUENCE
RG_DSS_DIM_SEGMENTS_U2 UNIQUE APPS_TS_TX_IDX DIMENSION_ID
APPLICATION_COLUMN_NAME
Columns
Name Datatype Length Mandatory Comments
DIMENSION_ID NUMBER (15) Y Dimension defining column
SEQUENCE NUMBER (15) Y Sequence in which the segment appears in the dimension
APPLICATION_COLUMN_NAME VARCHAR2 (30) Y Name of the column containing the segment
ID_FLEX_CODE VARCHAR2 (4) Y Key flexfield code
ID_FLEX_NUM NUMBER (15) Y Key flexfield structure number
MAX_DESC_SIZE NUMBER (3) Y Maximum size of segment description used by Financial Analyzer
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15) Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER (15) Y Standard Who column
RANGE_SET_ID NUMBER (15)
Filter defining column
ACCOUNT_TYPE VARCHAR2 (1)
Account type (Asset, Liability, Owner's Equity, Revenue, Expense, or All)
CONTEXT VARCHAR2 (30)
Descriptive Flexfield context
ATTRIBUTE1 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE11 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive Flexfield segment

[top of page]

RG.RG_DSS_DIM_SEGMENTS does not reference any database object

RG.RG_DSS_DIM_SEGMENTS is referenced by following:

RG
VIEW - RG_DSS_DIM_SEGMENTS#

[top of page]

Table: RG_DSS_HIERARCHIES

Description: Financial Analyzer hierarchies
Primary Key: RG_DSS_HIERARCHIES_PK
  1. HIERARCHY_ID
Primary Key: RG_DSS_HIERARCHIES_UK1
  1. NAME
Foreign Keys from this table:
Foreign Key Column Foreign Table
RG_DSS_HIERARCHIES.DIMENSION_ID RG_DSS_DIMENSIONS
Foreign Keys to this table:
Foreign Key Column Foreign Table
RG_DSS_HIERARCHY_DETAILS.HIERARCHY_ID RG_DSS_HIERARCHIES
RG_DSS_REQUESTS.HIERARCHY_ID RG_DSS_HIERARCHIES
Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

Indexes
Index Type Tablespace Column
RG_DSS_HIERARCHIES_U1 UNIQUE APPS_TS_TX_IDX HIERARCHY_ID
RG_DSS_HIERARCHIES_U2 UNIQUE APPS_TS_TX_IDX NAME
Columns
Name Datatype Length Mandatory Comments
HIERARCHY_ID NUMBER (15) Y Hierarchy defining column
NAME VARCHAR2 (60) Y Hierarchy name
ID_FLEX_CODE VARCHAR2 (4) Y Key flexfield code
ID_FLEX_NUM NUMBER (15) Y Key flexfield structure number
DIMENSION_ID NUMBER (15) Y Base dimension defining column
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15) Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER (15) Y Standard Who column
DESCRIPTION VARCHAR2 (240)
Hierarchy description
CONTEXT VARCHAR2 (30)
Descriptive Flexfield context
ATTRIBUTE1 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE11 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive Flexfield segment

[top of page]

RG.RG_DSS_HIERARCHIES does not reference any database object

RG.RG_DSS_HIERARCHIES is referenced by following:

RG
VIEW - RG_DSS_HIERARCHIES#

[top of page]

Table: RG_DSS_HIERARCHY_DETAILS

Description: Financial Analyzer hierarchy segment mappings
Primary Key: RG_DSS_HIERARCHY_DETAILS_PK
  1. HIERARCHY_ID
  2. SEQUENCE
Primary Key: RG_DSS_HIERARCHY_DETAILS_UK
  1. HIERARCHY_ID
  2. APPLICATION_COLUMN_NAME
Foreign Keys from this table:
Foreign Key Column Foreign Table
RG_DSS_HIERARCHY_DETAILS.HIERARCHY_ID RG_DSS_HIERARCHIES
Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

Indexes
Index Type Tablespace Column
RG_DSS_HIERARCHY_DETAILS_U1 UNIQUE APPS_TS_TX_IDX HIERARCHY_ID
APPLICATION_COLUMN_NAME
RG_DSS_HIERARCHY_DETAILS_U2 UNIQUE APPS_TS_TX_IDX HIERARCHY_ID
SEQUENCE
Columns
Name Datatype Length Mandatory Comments
HIERARCHY_ID NUMBER (15) Y Hierarchy defining column
SEQUENCE NUMBER (15) Y Hierarchy detail sequence
APPLICATION_COLUMN_NAME VARCHAR2 (30) Y Name of the column containing the segment
ROOT_NODE VARCHAR2 (60) Y Topmost parent node of the hierarchy
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15) Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER (15) Y Standard Who column
CONTEXT VARCHAR2 (30)
Descriptive Flexfield context
ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield segment

[top of page]

RG.RG_DSS_HIERARCHY_DETAILS does not reference any database object

RG.RG_DSS_HIERARCHY_DETAILS is referenced by following:

RG
VIEW - RG_DSS_HIERARCHY_DETAILS#

[top of page]

Table: RG_DSS_REQUESTS

Description: Financial Analyzer extract/load request tracking
Primary Key: RG_DSS_REQUESTS_PK
  1. REQUEST_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
RG_DSS_REQUESTS.CONCURRENT_REQUEST_ID FND_CONCURRENT_REQUESTS
RG_DSS_REQUESTS.LEDGER_ID GL_SETS_OF_BOOKS_11I
RG_DSS_REQUESTS.BUDGET_VERSION_ID GL_BUDGET_VERSIONS
RG_DSS_REQUESTS.ENCUMBRANCE_TYPE_ID GL_ENCUMBRANCE_TYPES
RG_DSS_REQUESTS.TEMPLATE_ID GL_SUMMARY_TEMPLATES
RG_DSS_REQUESTS.HIERARCHY_ID RG_DSS_HIERARCHIES
Comments

RG_DSS_REQUESTS stores information about the extraction and load requests. Each record stores one extract/load request: the name of the program (PROGRAM_TYPE), the parameters of the program, the location of the output file (FILE_SPEC), and the current status of the request (STATUS_FLAG).
The valid statuses are 'P' for Extracting, 'N' for New, 'L' for Loading, 'D' for Loaded, 'C' for Cancel, 'H' for Launched, and 'E' for Error.

Indexes
Index Type Tablespace Column
RG_DSS_REQUESTS_U1 UNIQUE APPS_TS_TX_IDX REQUEST_ID
RG_DSS_REQUESTS_N1 NONUNIQUE APPS_TS_TX_IDX PROGRAM_TYPE
Columns
Name Datatype Length Mandatory Comments
PROGRAM_TYPE VARCHAR2 (1) Y Program type (Segment, Balances, Hierarchy, Currency, Rates, or Calendar)
REQUEST_ID NUMBER (15) Y The request identifier of the current extract or load request
CONCURRENT_REQUEST_ID NUMBER (15) Y Concurrent request identifier of the extraction run
STATUS_FLAG VARCHAR2 (1) Y Status of the extraction request (Extracting, New, Loading, Loaded, Cancel, Launched, Error)
LEVEL_CODE VARCHAR2 (1)
Extraction level (Summary or Detail)
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15) Y Standard Who column
FILE_SPEC VARCHAR2 (240)
Location of the extraction file
EXTRACTION_START_DATE DATE

Start time of the extraction process
EXTRACTION_END_DATE DATE

End time of the extraction process
LOAD_START_DATE DATE

Start time of the load process
LOAD_END_DATE DATE

End time of the load process
CHART_OF_ACCOUNTS_ID NUMBER (15)
Key flexfield structure number
LEDGER_ID NUMBER (15)
Ledger defining column
FROM_PERIOD VARCHAR2 (15)
From period
TO_PERIOD VARCHAR2 (15)
To period
BALANCE_TYPE VARCHAR2 (4)
Balance Type
BUDGET_VERSION_ID NUMBER (15)
Budget version defining column
ENCUMBRANCE_TYPE_ID NUMBER (15)
Encumbrance defining column (-1 - total of all encumbrances, -2 - for all encumbrances)
TEMPLATE_ID NUMBER (15)
Summary template defining column (-1 - for all summary templates)
DAY_OF_PERIOD NUMBER (15)
Day of period to be used (-1 - for last day in each period)
HIERARCHY_ID NUMBER (15)
Hierarchy defining column
PERIOD_YEAR NUMBER (15)
Accounting period year

[top of page]

RG.RG_DSS_REQUESTS does not reference any database object

RG.RG_DSS_REQUESTS is referenced by following:

RG
VIEW - RG_DSS_REQUESTS#

[top of page]

Table: RG_DSS_SEG_RANGES

Description: Segment ranges for filters
Primary Key: RG_DSS_SEG_RANGES_PK
  1. RANGE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
RG_DSS_SEG_RANGES.RANGE_SET_ID RG_DSS_SEG_RANGE_SETS
Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

Indexes
Index Type Tablespace Column
RG_DSS_SEG_RANGES_U1 UNIQUE APPS_TS_TX_IDX RANGE_ID
RG_DSS_SEG_RANGES_N1 NONUNIQUE APPS_TS_TX_IDX RANGE_SET_ID
Columns
Name Datatype Length Mandatory Comments
RANGE_SET_ID NUMBER (15) Y Filter defining column
RANGE_ID NUMBER (15) Y Range defining column
INCLUDE_FLAG VARCHAR2 (1) Y Include or Exclude segment ranges
SEGMENT_LOW VARCHAR2 (60) Y Low value of the range
SEGMENT_HIGH VARCHAR2 (60) Y High value of the range
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15) Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER (15) Y Standard Who column
CONTEXT VARCHAR2 (30)
Descriptive Flexfield context
ATTRIBUTE1 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE11 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive Flexfield segment

[top of page]

RG.RG_DSS_SEG_RANGES does not reference any database object

RG.RG_DSS_SEG_RANGES is referenced by following:

RG
VIEW - RG_DSS_SEG_RANGES#

[top of page]

Table: RG_DSS_SEG_RANGE_SETS

Description: Filters
Primary Key: RG_DSS_SEG_RANGE_SETS_PK
  1. RANGE_SET_ID
Primary Key: RG_DSS_SEG_RANGE_SETS_UK1
  1. NAME
Foreign Keys to this table:
Foreign Key Column Foreign Table
RG_DSS_DIM_SEGMENTS.RANGE_SET_ID RG_DSS_SEG_RANGE_SETS
RG_DSS_SEG_RANGES.RANGE_SET_ID RG_DSS_SEG_RANGE_SETS
RG_DSS_VAR_SELECTIONS.RANGE_SET_ID RG_DSS_SEG_RANGE_SETS
Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

Indexes
Index Type Tablespace Column
RG_DSS_SEG_RANGE_SETS_U1 UNIQUE APPS_TS_TX_IDX RANGE_SET_ID
RG_DSS_SEG_RANGE_SETS_U2 UNIQUE APPS_TS_TX_IDX NAME
RG_DSS_SEG_RANGE_SETS_N1 NONUNIQUE APPS_TS_TX_IDX APPLICATION_COLUMN_NAME
Columns
Name Datatype Length Mandatory Comments
RANGE_SET_ID NUMBER (15) Y Filter defining column
NAME VARCHAR2 (60) Y Filter name
APPLICATION_COLUMN_NAME VARCHAR2 (30) Y Name of the column containing the segment used by the filter
ID_FLEX_CODE VARCHAR2 (4) Y Key flexfield code
ID_FLEX_NUM NUMBER (15) Y Key flexfield structure number
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15) Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER (15) Y Standard Who column
DESCRIPTION VARCHAR2 (240)
Filter description
CONTEXT VARCHAR2 (30)
Descriptive Flexfield context
ATTRIBUTE1 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE11 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive Flexfield segment

[top of page]

RG.RG_DSS_SEG_RANGE_SETS does not reference any database object

RG.RG_DSS_SEG_RANGE_SETS is referenced by following:

RG
VIEW - RG_DSS_SEG_RANGE_SETS#

[top of page]

Table: RG_DSS_SYSTEMS

Description: Financial Analyzer financial data sets
Primary Key: RG_DSS_SYSTEMS_PK
  1. SYSTEM_ID
Primary Key: RG_DSS_SYSTEMS_UK1
  1. NAME
Foreign Keys from this table:
Foreign Key Column Foreign Table
RG_DSS_SYSTEMS.PERIOD_SET_NAME GL_PERIOD_SETS
Foreign Keys to this table:
Foreign Key Column Foreign Table
RG_DSS_SYSTEM_SEG_ORDER.SYSTEM_ID RG_DSS_SYSTEMS
RG_DSS_SYSTEM_VARIABLES.SYSTEM_ID RG_DSS_SYSTEMS
Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

Indexes
Index Type Tablespace Column
RG_DSS_SYSTEMS_U1 UNIQUE APPS_TS_TX_IDX SYSTEM_ID
RG_DSS_SYSTEMS_U2 UNIQUE APPS_TS_TX_IDX NAME
Columns
Name Datatype Length Mandatory Comments
SYSTEM_ID NUMBER (15) Y Financial data set defining column
NAME VARCHAR2 (60) Y Financial data set name
FREEZE_FLAG VARCHAR2 (1) Y Flag to freeze the system
ID_FLEX_CODE VARCHAR2 (4) Y Key flexfield code
ID_FLEX_NUM NUMBER (15) Y Key flexfield structure number
PERIOD_SET_NAME VARCHAR2 (15) Y Calendar defining column
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15) Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER (15) Y Standard Who column
CONTEXT VARCHAR2 (30)
Descriptive flexfield context
ATTRIBUTE1 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE11 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive Flexfield segment
SAVE_INCREMENTAL_DATA_FLAG VARCHAR2 (1) Y Flag to save incremental balances

[top of page]

RG.RG_DSS_SYSTEMS does not reference any database object

RG.RG_DSS_SYSTEMS is referenced by following:

RG
VIEW - RG_DSS_SYSTEMS#

[top of page]

Table: RG_DSS_SYSTEM_SEG_ORDER

Description: Financial Analyzer financial data set segment sort order
Primary Key: RG_DSS_SYSTEM_SEG_ORDER_PK
  1. SYSTEM_ID
  2. SEQUENCE
Foreign Keys from this table:
Foreign Key Column Foreign Table
RG_DSS_SYSTEM_SEG_ORDER.SYSTEM_ID RG_DSS_SYSTEMS
Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

Indexes
Index Type Tablespace Column
RG_DSS_SYSTEM_SEG_ORDER_U1 UNIQUE APPS_TS_TX_IDX SYSTEM_ID
SEQUENCE
RG_DSS_SYSTEM_SEG_ORDER_U2 UNIQUE APPS_TS_TX_IDX SYSTEM_ID
APPLICATION_COLUMN_NAME
Columns
Name Datatype Length Mandatory Comments
SYSTEM_ID NUMBER (15) Y Financial data set defining column
SEQUENCE NUMBER (15) Y Position of column in the sort order
APPLICATION_COLUMN_NAME VARCHAR2 (30) Y Name of column that contains the segment
ID_FLEX_CODE VARCHAR2 (4) Y Key flexfield code
ID_FLEX_NUM NUMBER (15) Y Key flexfield structure number
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15) Y Standard Who column
CONTEXT VARCHAR2 (150)
Descriptive Flexfield context
ATTRIBUTE1 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE11 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive Flexfield segment

[top of page]

RG.RG_DSS_SYSTEM_SEG_ORDER does not reference any database object

RG.RG_DSS_SYSTEM_SEG_ORDER is referenced by following:

RG
VIEW - RG_DSS_SYSTEM_SEG_ORDER#

[top of page]

Table: RG_DSS_SYSTEM_VARIABLES

Description: Assignments of financial data items to financial data sets
Primary Key: RG_DSS_SYSTEM_VARIABLES_PK
  1. SYSTEM_VARIABLE_ID
Primary Key: RG_DSS_SYSTEM_VARIABLES_UK1
  1. SYSTEM_ID
  2. VARIABLE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
RG_DSS_SYSTEM_VARIABLES.SYSTEM_ID RG_DSS_SYSTEMS
RG_DSS_SYSTEM_VARIABLES.VARIABLE_ID RG_DSS_VARIABLES
Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

Indexes
Index Type Tablespace Column
RG_DSS_SYSTEM_VARIABLES_U1 UNIQUE APPS_TS_TX_IDX SYSTEM_VARIABLE_ID
RG_DSS_SYSTEM_VARIABLES_U2 UNIQUE APPS_TS_TX_IDX SYSTEM_ID
VARIABLE_ID
Columns
Name Datatype Length Mandatory Comments
SYSTEM_ID NUMBER (15) Y Financial data set defining column
VARIABLE_ID NUMBER (15) Y Financial data item defining column
SYSTEM_VARIABLE_ID NUMBER (15) Y Assignment defining column
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15) Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER (15) Y Standard Who column
CONTEXT VARCHAR2 (30)
Descriptive Flexfield context
ATTRIBUTE1 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE11 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive Flexfield segment

[top of page]

RG.RG_DSS_SYSTEM_VARIABLES does not reference any database object

RG.RG_DSS_SYSTEM_VARIABLES is referenced by following:

RG
VIEW - RG_DSS_SYSTEM_VARIABLES#

[top of page]

Table: RG_DSS_VARIABLES

Description: Financial Analyzer financial data items
Primary Key: RG_DSS_VARIABLES_PK
  1. VARIABLE_ID
Primary Key: RG_DSS_VARIABLES_UK1
  1. NAME
Primary Key: RG_DSS_VARIABLES_UK2
  1. OBJECT_NAME
Foreign Keys from this table:
Foreign Key Column Foreign Table
RG_DSS_VARIABLES.LEDGER_ID GL_SETS_OF_BOOKS_11I
RG_DSS_VARIABLES.CURRENCY_CODE FND_CURRENCIES
RG_DSS_VARIABLES.BUDGET_VERSION_ID GL_BUDGET_VERSIONS
RG_DSS_VARIABLES.ENCUMBRANCE_TYPE_ID GL_ENCUMBRANCE_TYPES
Foreign Keys to this table:
Foreign Key Column Foreign Table
RG_DSS_SYSTEM_VARIABLES.VARIABLE_ID RG_DSS_VARIABLES
RG_DSS_VAR_DIMENSIONS.VARIABLE_ID RG_DSS_VARIABLES
RG_DSS_VAR_SELECTIONS.VARIABLE_ID RG_DSS_VARIABLES
RG_DSS_VAR_TEMPLATES.VARIABLE_ID RG_DSS_VARIABLES
Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

Indexes
Index Type Tablespace Column
RG_DSS_VARIABLES_U1 UNIQUE APPS_TS_TX_IDX VARIABLE_ID
RG_DSS_VARIABLES_U2 UNIQUE APPS_TS_TX_IDX NAME
RG_DSS_VARIABLES_U3 UNIQUE APPS_TS_TX_IDX OBJECT_NAME
Columns
Name Datatype Length Mandatory Comments
VARIABLE_ID NUMBER (15) Y Financial data item defining column
NAME VARCHAR2 (60) Y Financial data item name
LEDGER_ID NUMBER (15) Y Ledger defining column
BALANCE_TYPE VARCHAR2 (4) Y Balance Type
CURRENCY_TYPE VARCHAR2 (2) Y Currency type (Foreign Entered, Foreign Translated, Functional Only, Statistical Only, Functional and Statistical)
LEVEL_CODE VARCHAR2 (1) Y Financial data item level (Summary or Detail)
STATUS_CODE VARCHAR2 (1) Y Financial data item status
OBJECT_NAME VARCHAR2 (16) Y Financial data item name in Financial Analyzer
COLUMN_LABEL VARCHAR2 (30) Y Column, row, and selector label used in Financial Analyzer
ID_FLEX_CODE VARCHAR2 (4) Y Key flexfield code
ID_FLEX_NUM NUMBER (15) Y Key flexfield structure number
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15) Y Standard Who column
CURRENCY_CODE VARCHAR2 (30)
Currency code
BUDGET_VERSION_ID NUMBER (15)
Budget version defining column
ENCUMBRANCE_TYPE_ID NUMBER (15)
Encumbrance type defining column
DESCRIPTION VARCHAR2 (240)
Financial data item description
SEGMENT1_TYPE VARCHAR2 (25)
Segment type column
SEGMENT2_TYPE VARCHAR2 (25)
Segment type column
SEGMENT3_TYPE VARCHAR2 (25)
Segment type column
SEGMENT4_TYPE VARCHAR2 (25)
Segment type column
SEGMENT5_TYPE VARCHAR2 (25)
Segment type column
SEGMENT6_TYPE VARCHAR2 (25)
Segment type column
SEGMENT7_TYPE VARCHAR2 (25)
Segment type column
SEGMENT8_TYPE VARCHAR2 (25)
Segment type column
SEGMENT9_TYPE VARCHAR2 (25)
Segment type column
SEGMENT10_TYPE VARCHAR2 (25)
Segment type column
SEGMENT11_TYPE VARCHAR2 (25)
Segment type column
SEGMENT12_TYPE VARCHAR2 (25)
Segment type column
SEGMENT13_TYPE VARCHAR2 (25)
Segment type column
SEGMENT14_TYPE VARCHAR2 (25)
Segment type column
SEGMENT15_TYPE VARCHAR2 (25)
Segment type column
SEGMENT16_TYPE VARCHAR2 (25)
Segment type column
SEGMENT17_TYPE VARCHAR2 (25)
Segment type column
SEGMENT18_TYPE VARCHAR2 (25)
Segment type column
SEGMENT19_TYPE VARCHAR2 (25)
Segment type column
SEGMENT20_TYPE VARCHAR2 (25)
Segment type column
SEGMENT21_TYPE VARCHAR2 (25)
Segment type column
SEGMENT22_TYPE VARCHAR2 (25)
Segment type column
SEGMENT23_TYPE VARCHAR2 (25)
Segment type column
SEGMENT24_TYPE VARCHAR2 (25)
Segment type column
SEGMENT25_TYPE VARCHAR2 (25)
Segment type column
SEGMENT26_TYPE VARCHAR2 (25)
Segment type column
SEGMENT27_TYPE VARCHAR2 (25)
Segment type column
SEGMENT28_TYPE VARCHAR2 (25)
Segment type column
SEGMENT29_TYPE VARCHAR2 (25)
Segment type column
SEGMENT30_TYPE VARCHAR2 (25)
Segment type column
CONTEXT VARCHAR2 (150)
Descriptive Flexfield context
ATTRIBUTE1 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE11 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive Flexfield segment

[top of page]

RG.RG_DSS_VARIABLES does not reference any database object

RG.RG_DSS_VARIABLES is referenced by following:

RG
VIEW - RG_DSS_VARIABLES#

[top of page]

Table: RG_DSS_VAR_DIMENSIONS

Description: Financial Analyzer financial data item dimensions
Primary Key: RG_DSS_VAR_DIMENSIONS_PK
  1. VARIABLE_ID
  2. SEQUENCE
Primary Key: RG_DSS_VAR_DIMENSIONS_UK1
  1. VARIABLE_ID
  2. DIMENSION_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
RG_DSS_VAR_DIMENSIONS.VARIABLE_ID RG_DSS_VARIABLES
RG_DSS_VAR_DIMENSIONS.DIMENSION_ID RG_DSS_DIMENSIONS
Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

Indexes
Index Type Tablespace Column
RG_DSS_VAR_DIMENSIONS_U1 UNIQUE APPS_TS_TX_IDX VARIABLE_ID
SEQUENCE
RG_DSS_VAR_DIMENSIONS_U2 UNIQUE APPS_TS_TX_IDX VARIABLE_ID
DIMENSION_ID
Columns
Name Datatype Length Mandatory Comments
VARIABLE_ID NUMBER (15) Y Variable defining column
SEQUENCE NUMBER (15) Y Assignment sequence
DIMENSION_ID NUMBER (15) Y Dimension defining column
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15) Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER (15) Y Standard Who column
CONTEXT VARCHAR2 (30)
Descriptive Flexfield context
ATTRIBUTE1 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE11 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive Flexfield segment

[top of page]

RG.RG_DSS_VAR_DIMENSIONS does not reference any database object

RG.RG_DSS_VAR_DIMENSIONS is referenced by following:

RG
VIEW - RG_DSS_VAR_DIMENSIONS#

[top of page]

Table: RG_DSS_VAR_SELECTIONS

Description: Financial Analyzer financial data item selections
Primary Key: RG_DSS_VAR_SELECTIONS_PK
  1. SELECTION_ID
Primary Key: RG_DSS_VAR_SELECTIONS_UK1
  1. VARIABLE_ID
  2. APPLICATION_COLUMN_NAME
Foreign Keys from this table:
Foreign Key Column Foreign Table
RG_DSS_VAR_SELECTIONS.VARIABLE_ID RG_DSS_VARIABLES
RG_DSS_VAR_SELECTIONS.RANGE_SET_ID RG_DSS_SEG_RANGE_SETS
Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

Indexes
Index Type Tablespace Column
RG_DSS_VAR_SELECTIONS_U1 UNIQUE APPS_TS_TX_IDX SELECTION_ID
RG_DSS_VAR_SELECTIONS_N1 NONUNIQUE APPS_TS_TX_IDX VARIABLE_ID
APPLICATION_COLUMN_NAME
Columns
Name Datatype Length Mandatory Comments
VARIABLE_ID NUMBER (15) Y Variable defining column
APPLICATION_COLUMN_NAME VARCHAR2 (30) Y Name of the column containing the segment
ID_FLEX_CODE VARCHAR2 (4) Y Key flexfield code
ID_FLEX_NUM NUMBER (15) Y Key flexfield structure number
SELECTION_ID NUMBER (15) Y Selection defining column
RANGE_SET_ID NUMBER (15) Y Filter defining column
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15) Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER (15) Y Standard Who column
CONTEXT VARCHAR2 (30)
Descriptive Flexfield context
ATTRIBUTE1 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE11 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive Flexfield segment

[top of page]

RG.RG_DSS_VAR_SELECTIONS does not reference any database object

RG.RG_DSS_VAR_SELECTIONS is referenced by following:

RG
VIEW - RG_DSS_VAR_SELECTIONS#

[top of page]

Table: RG_DSS_VAR_TEMPLATES

Description: Financial Analyzer financial data item summary templates
Primary Key: RG_DSS_VAR_TEMPLATES_PK
  1. VARIABLE_ID
  2. TEMPLATE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
RG_DSS_VAR_TEMPLATES.VARIABLE_ID RG_DSS_VARIABLES
RG_DSS_VAR_TEMPLATES.TEMPLATE_ID GL_SUMMARY_TEMPLATES
Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

Indexes
Index Type Tablespace Column
RG_DSS_VAR_TEMPLATES_N1 NONUNIQUE APPS_TS_TX_IDX VARIABLE_ID
Columns
Name Datatype Length Mandatory Comments
VARIABLE_ID NUMBER (15) Y Financial Data Item defining column
TEMPLATE_ID NUMBER (15) Y Summary Template defining column
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15) Y Standard Who column
SEGMENT1_TYPE VARCHAR2 (25)
Summary type flexfield segment
SEGMENT2_TYPE VARCHAR2 (25)
Summary type flexfield segment
SEGMENT3_TYPE VARCHAR2 (25)
Summary type flexfield segment
SEGMENT4_TYPE VARCHAR2 (25)
Summary type flexfield segment
SEGMENT5_TYPE VARCHAR2 (25)
Summary type flexfield segment
SEGMENT6_TYPE VARCHAR2 (25)
Summary type flexfield segment
SEGMENT7_TYPE VARCHAR2 (25)
Summary type flexfield segment
SEGMENT8_TYPE VARCHAR2 (25)
Summary type flexfield segment
SEGMENT9_TYPE VARCHAR2 (25)
Summary type flexfield segment
SEGMENT10_TYPE VARCHAR2 (25)
Summary type flexfield segment
SEGMENT11_TYPE VARCHAR2 (25)
Summary type flexfield segment
SEGMENT12_TYPE VARCHAR2 (25)
Summary type flexfield segment
SEGMENT13_TYPE VARCHAR2 (25)
Summary type flexfield segment
SEGMENT14_TYPE VARCHAR2 (25)
Summary type flexfield segment
SEGMENT15_TYPE VARCHAR2 (25)
Summary type flexfield segment
SEGMENT16_TYPE VARCHAR2 (25)
Summary type flexfield segment
SEGMENT17_TYPE VARCHAR2 (25)
Summary type flexfield segment
SEGMENT18_TYPE VARCHAR2 (25)
Summary type flexfield segment
SEGMENT19_TYPE VARCHAR2 (25)
Summary type flexfield segment
SEGMENT20_TYPE VARCHAR2 (25)
Summary type flexfield segment
SEGMENT21_TYPE VARCHAR2 (25)
Summary type flexfield segment
SEGMENT22_TYPE VARCHAR2 (25)
Summary type flexfield segment
SEGMENT23_TYPE VARCHAR2 (25)
Summary type flexfield segment
SEGMENT24_TYPE VARCHAR2 (25)
Summary type flexfield segment
SEGMENT25_TYPE VARCHAR2 (25)
Summary type flexfield segment
SEGMENT26_TYPE VARCHAR2 (25)
Summary type flexfield segment
SEGMENT27_TYPE VARCHAR2 (25)
Summary type flexfield segment
SEGMENT28_TYPE VARCHAR2 (25)
Summary type flexfield segment
SEGMENT29_TYPE VARCHAR2 (25)
Summary type flexfield segment
SEGMENT30_TYPE VARCHAR2 (25)
Summary type flexfield segment
CONTEXT VARCHAR2 (150)
Descriptive flexfield context
ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield segment

[top of page]

RG.RG_DSS_VAR_TEMPLATES does not reference any database object

RG.RG_DSS_VAR_TEMPLATES is referenced by following:

RG
VIEW - RG_DSS_VAR_TEMPLATES#

[top of page]

Table: RG_REPORTS

Description: Report definitions
Primary Key: RG_REPORTS_PK
  1. REPORT_ID
Primary Key: RG_REPORTS_UK1
  1. NAME
  2. APPLICATION_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
RG_REPORTS.REPORT_DISPLAY_SET_ID RG_REPORT_DISPLAY_SETS
RG_REPORTS.APPLICATION_ID
RG_REPORTS.ID_FLEX_CODE_11I
RG_REPORTS.STRUCTURE_ID
FND_ID_FLEX_STRUCTURES
RG_REPORTS.ROW_ORDER_ID RG_ROW_ORDERS
RG_REPORTS.UNIT_OF_MEASURE_ID_11I FND_CURRENCIES
RG_REPORTS.COLUMN_SET_ID RG_REPORT_AXIS_SETS
RG_REPORTS.ROW_SET_ID RG_REPORT_AXIS_SETS
RG_REPORTS.CONTENT_SET_ID RG_REPORT_CONTENT_SETS
Foreign Keys to this table:
Foreign Key Column Foreign Table
RG_REPORT_REQUESTS.REPORT_ID RG_REPORTS
RG_REPORT_SET_REQ_DETAILS.REPORT_ID RG_REPORTS
Comments

RG_REPORTS stores information about all of the reports currently defined in Financial Statement Generator, including the row and column sets associated with the report, any content set and row order that Financial Statement Generator uses, units of measure, and the budgets or encumbrances associated with the report. Each row includes a name, row set identifier, column set identifier, content set identifier, row order identifier and the unit of measure (currency) that each report uses. Each row contains information about one report defined in Financial Statement Generator.
Financial Statement Generator uses this information to link a row, a column, and an optional content set and row order together into one report that you can submit for a report request. If a budget or encumbrance amount type is assigned to a row or column in a row set or column set, a budget or encumbrance must also be linked to the report.
If a currency is assigned to particular rows or columns in a row set or column set, the currency assigned to the report that contains that row set and/or column set overrides the currencies in the rows or columns.

Indexes
Index Type Tablespace Column
RG_REPORTS_U1 UNIQUE APPS_TS_TX_IDX REPORT_ID
RG_REPORTS_U2 UNIQUE APPS_TS_TX_IDX NAME
APPLICATION_ID
Columns
Name Datatype Length Mandatory Comments
APPLICATION_ID NUMBER (15) Y Application defining column
REPORT_ID NUMBER (15) Y Report defining column
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15) Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER (15) Y Standard Who column
NAME VARCHAR2 (30) Y Name for this report
COLUMN_SET_ID NUMBER (15) Y Defining column for the column set for this report
ROW_SET_ID NUMBER (15) Y Defining column for the row set for this report
ROUNDING_OPTION VARCHAR2 (1) Y Report rounding method
OUTPUT_OPTION VARCHAR2 (1) Y Output option
REPORT_TITLE VARCHAR2 (240) Y Report title
REPORT_DISPLAY_SET_ID NUMBER (15)
Defining column for the optional report display set for this report
CONTENT_SET_ID NUMBER (15)
Defining column for the optional content set for this report
ROW_ORDER_ID NUMBER (15)
Defining column for the optional row order for this report
PARAMETER_SET_ID NUMBER (15)
Parameter set for running this report
UNIT_OF_MEASURE_ID_11I VARCHAR2 (30)
Obsolete
ID_FLEX_CODE_11I VARCHAR2 (4)
Obsolete
STRUCTURE_ID NUMBER (15)
Key Flexfield structure defining column
SEGMENT_OVERRIDE_11I VARCHAR2 (2000)
Obsolete
PERIOD_SET_NAME VARCHAR2 (15)
No longer used
MINIMUM_DISPLAY_LEVEL NUMBER (15)
Level of detail to run this predefined report at
DESCRIPTION VARCHAR2 (240)
Description of the report
CONTEXT VARCHAR2 (30)
Descriptive Flexfield context
ATTRIBUTE1 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE11 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive Flexfield segment
ID_FLEX_CODE VARCHAR2 (4)
GLLE
SEGMENT_OVERRIDE VARCHAR2 (2000)
Values of the segments to override at runtime
UNIT_OF_MEASURE_ID VARCHAR2 (30)
Currency
SECURITY_FLAG VARCHAR2 (1) Y Security flag
OVERRIDE_ALC_LEDGER_CURRENCY VARCHAR2 (30)
Override reporting ledger currency

[top of page]

RG.RG_REPORTS does not reference any database object

RG.RG_REPORTS is referenced by following:

RG
VIEW - RG_REPORTS#

[top of page]

Table: RG_REPORT_AXES

Description: Row and column definitions
Primary Key: RG_REPORT_AXES_PK
  1. AXIS_SET_ID
  2. AXIS_SEQ
Foreign Keys from this table:
Foreign Key Column Foreign Table
RG_REPORT_AXES.STANDARD_AXIS_ID RG_REPORT_STANDARD_AXES
RG_REPORT_AXES.UNIT_OF_MEASURE_ID FND_CURRENCIES
RG_REPORT_AXES.AXIS_SET_ID RG_REPORT_AXIS_SETS
RG_REPORT_AXES.ELEMENT_ID RG_XBRL_ELEMENTS
Foreign Keys to this table:
Foreign Key Column Foreign Table
RG_REPORT_AXIS_CONTENTS.AXIS_SET_ID
RG_REPORT_AXIS_CONTENTS.AXIS_SEQ
RG_REPORT_AXES
RG_REPORT_CALCULATIONS.AXIS_SET_ID
RG_REPORT_CALCULATIONS.AXIS_SEQ
RG_REPORT_AXES
RG_REPORT_CALCULATIONS.AXIS_SET_ID
RG_REPORT_CALCULATIONS.AXIS_SEQ_HIGH
RG_REPORT_AXES
RG_REPORT_CALCULATIONS.AXIS_SET_ID
RG_REPORT_CALCULATIONS.AXIS_SEQ_LOW
RG_REPORT_AXES
RG_REPORT_EXCEPTIONS.AXIS_SET_ID
RG_REPORT_EXCEPTIONS.AXIS_SEQ
RG_REPORT_AXES
RG_REPORT_EXCEPTION_FLAGS.AXIS_SET_ID
RG_REPORT_EXCEPTION_FLAGS.AXIS_SEQ
RG_REPORT_AXES
Comments

RG_REPORT_AXES stores information about all the rows and columns currently defined in Financial Statement Generator. Each row includes an axis set identifier to link the row or column to a row set or column set, a name, a currency and a parameter number to link the row or column to a specific budget or encumbrance. Each row also contains customizable formatting options. Each row contains information about one particular row or column currently defined in Financial Statement Generator.

Indexes
Index Type Tablespace Column
RG_REPORT_AXES_U1 UNIQUE APPS_TS_TX_IDX AXIS_SET_ID
AXIS_SEQ
ZD_EDITION_NAME
RG_REPORT_AXES_N1 NONUNIQUE APPS_TS_TX_IDX AXIS_NAME
AXIS_SET_ID
Columns
Name Datatype Length Mandatory Comments
APPLICATION_ID NUMBER (15) Y Application defining column
AXIS_SET_ID NUMBER (15) Y Axis set defining column for the column set or row set
AXIS_SEQ NUMBER
Y Sequence number for this column or row
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15) Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER (15) Y Standard Who column
AXIS_TYPE VARCHAR2 (1) Y Not currently used
AXIS_NAME VARCHAR2 (30)
Name of this column or row
AMOUNT_ID NUMBER (15)
Amount foreign key
STANDARD_AXIS_ID NUMBER (15)
Amount type for this column or row
WIDTH NUMBER (15)
No longer used
POSITION NUMBER (15)
Position of column (columns only)
STRUCTURE_ID NUMBER (15)
No longer used
UNIT_OF_MEASURE_ID VARCHAR2 (30)
Currency
PARAMETER_NUM NUMBER (15)
Control value to tie this column or row to a budget, encumbrance, or currency
PERIOD_OFFSET NUMBER (15)
Number of periods or days this row or column value should be offset from the runtime period or day
DESCRIPTION VARCHAR2 (240)
Description of the column or row
DISPLAY_FLAG VARCHAR2 (1)
Display flag indicating whether this row or column should be displayed on the report
BEFORE_AXIS_STRING VARCHAR2 (10)
Character to print on report before this row
AFTER_AXIS_STRING VARCHAR2 (10)
Character to print on report after this row
NUMBER_CHARACTERS_INDENTED NUMBER (15)
Number of characters to indent when printing this row
PAGE_BREAK_AFTER_FLAG VARCHAR2 (1)
Flag to indicate whether to insert a page break after this row
PAGE_BREAK_BEFORE_FLAG VARCHAR2 (1)
Flag to indicate whether to insert a page break before this row
NUMBER_LINES_SKIPPED_BEFORE NUMBER (15)
Number of lines to skip before displaying this row
NUMBER_LINES_SKIPPED_AFTER NUMBER (15)
Number of lines to skip after displaying this row
DISPLAY_LEVEL NUMBER (15)
Level of detail for this row or column
DISPLAY_ZERO_AMOUNT_FLAG VARCHAR2 (1)
Flag indicating whether to display zeros for row or column
CHANGE_SIGN_FLAG VARCHAR2 (1)
Flag to change sign of all the row or column values displayed on the report
CHANGE_VARIANCE_SIGN_FLAG VARCHAR2 (1)
Flag to change sign on row or column variances displayed
DISPLAY_UNITS NUMBER (15)
Units to display the row or column values on the report (thousands, hundreds, etc.)
DISPLAY_FORMAT VARCHAR2 (30)
Format string of row or column values indicating number of characters and position of decimal point (eg. 999.99)
CALCULATION_PRECEDENCE_FLAG VARCHAR2 (1)
Flag to indicate whether row or column calculation overrides
CONTEXT VARCHAR2 (30)
Descriptive flexfield context
ATTRIBUTE1 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE11 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive Flexfield segment
PERCENTAGE_DIVISOR_SEQ NUMBER

Sequence for percentage divisor
TRANSACTION_FLAG VARCHAR2 (1)
No longer used
FORMAT_BEFORE_TEXT VARCHAR2 (30)
Character to print in report before the format mask
FORMAT_AFTER_TEXT VARCHAR2 (30)
Character to print in report after the format mask
FORMAT_MASK_WIDTH NUMBER (15)
Width of the display format
DISPLAY_PRECISION NUMBER (15)
The precision to display the row or column values on the report
SEGMENT_OVERRIDE_VALUE VARCHAR2 (60)
Value of segment override
ELEMENT_ID NUMBER (15)
Oracle Internal use only - reserved for future use
OVERRIDE_ALC_LEDGER_CURRENCY VARCHAR2 (30)
Override reporting ledger currency
ZD_EDITION_NAME VARCHAR2 (30) Y

[top of page]

RG.RG_REPORT_AXES does not reference any database object

RG.RG_REPORT_AXES is referenced by following:

RG
VIEW - RG_REPORT_AXES#

[top of page]

Table: RG_REPORT_AXIS_CONTENTS

Description: Assignments of account ranges to rows and columns
Foreign Keys from this table:
Foreign Key Column Foreign Table
RG_REPORT_AXIS_CONTENTS.LEDGER_ID GL_LEDGERS
RG_REPORT_AXIS_CONTENTS.AXIS_SET_ID
RG_REPORT_AXIS_CONTENTS.AXIS_SEQ
RG_REPORT_AXES
Comments

RG_REPORT_AXIS_CONTENTS stores information about all of the account assignments to rows and columns. Each row includes a specific account range, and an axis set identifier to link the account range to a specific row or column set. Each row also contains an axis sequence number to link the account range to a specific row or column. Financial Statement Generator uses this information to determine ranges of a report.

Indexes
Index Type Tablespace Column
RG_REPORT_AXIS_CONTENTS_N1 NONUNIQUE APPS_TS_TX_IDX AXIS_SET_ID
AXIS_SEQ
Columns
Name Datatype Length Mandatory Comments
APPLICATION_ID NUMBER (15) Y Application defining column
AXIS_SET_ID NUMBER (15) Y Defining column of the column set or row set these flexfield details refer to
AXIS_SEQ NUMBER
Y Sequence number of the column or row these flexfield details refer to
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15) Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER (15) Y Standard Who column
RANGE_MODE VARCHAR2 (1) Y Summary flag to indicate whether this flexfield range specifies summary values
SIGN VARCHAR2 (1) Y Sign for this flexfield range to indicate whether to add or subtract this range
DR_CR_NET_CODE VARCHAR2 (1)
Activity type (eg. debit, credit)
LEDGER_ID NUMBER (15)
Ledger defining column associated with this flexfield
SEGMENT1_LOW VARCHAR2 (60)
Key Flexfield range segment
SEGMENT1_HIGH VARCHAR2 (60)
Key Flexfield range segment
SEGMENT1_TYPE VARCHAR2 (1)
Key Flexfield segment type
SEGMENT2_LOW VARCHAR2 (60)
Key Flexfield range segment
SEGMENT2_HIGH VARCHAR2 (60)
Key Flexfield range segment
SEGMENT2_TYPE VARCHAR2 (1)
Key Flexfield segment type
SEGMENT3_LOW VARCHAR2 (60)
Key Flexfield range segment
SEGMENT3_HIGH VARCHAR2 (60)
Key Flexfield range segment
SEGMENT3_TYPE VARCHAR2 (1)
Key Flexfield segment type
SEGMENT4_LOW VARCHAR2 (60)
Key Flexfield range segment
SEGMENT4_HIGH VARCHAR2 (60)
Key Flexfield range segment
SEGMENT4_TYPE VARCHAR2 (1)
Key Flexfield segment type
SEGMENT5_LOW VARCHAR2 (60)
Key Flexfield range segment
SEGMENT5_HIGH VARCHAR2 (60)
Key Flexfield range segment
SEGMENT5_TYPE VARCHAR2 (1)
Key Flexfield segment type
SEGMENT6_LOW VARCHAR2 (60)
Key Flexfield range segment
SEGMENT6_HIGH VARCHAR2 (60)
Key Flexfield range segment
SEGMENT6_TYPE VARCHAR2 (1)
Key Flexfield segment type
SEGMENT7_LOW VARCHAR2 (60)
Key Flexfield range segment
SEGMENT7_HIGH VARCHAR2 (60)
Key Flexfield range segment
SEGMENT7_TYPE VARCHAR2 (1)
Key Flexfield segment type
SEGMENT8_LOW VARCHAR2 (60)
Key Flexfield range segment
SEGMENT8_HIGH VARCHAR2 (60)
Key Flexfield range segment
SEGMENT8_TYPE VARCHAR2 (1)
Key Flexfield segment type
SEGMENT9_LOW VARCHAR2 (60)
Key Flexfield range segment
SEGMENT9_HIGH VARCHAR2 (60)
Key Flexfield range segment
SEGMENT9_TYPE VARCHAR2 (1)
Key Flexfield segment type
SEGMENT10_LOW VARCHAR2 (60)
Key Flexfield range segment
SEGMENT10_HIGH VARCHAR2 (60)
Key Flexfield range segment
SEGMENT10_TYPE VARCHAR2 (1)
Key Flexfield segment type
SEGMENT11_LOW VARCHAR2 (60)
Key Flexfield range segment
SEGMENT11_HIGH VARCHAR2 (60)
Key Flexfield range segment
SEGMENT11_TYPE VARCHAR2 (1)
Key Flexfield segment type
SEGMENT12_LOW VARCHAR2 (60)
Key Flexfield range segment
SEGMENT12_HIGH VARCHAR2 (60)
Key Flexfield range segment
SEGMENT12_TYPE VARCHAR2 (1)
Key Flexfield segment type
SEGMENT13_LOW VARCHAR2 (60)
Key Flexfield range segment
SEGMENT13_HIGH VARCHAR2 (60)
Key Flexfield range segment
SEGMENT13_TYPE VARCHAR2 (1)
Key Flexfield segment type
SEGMENT14_LOW VARCHAR2 (60)
Key Flexfield range segment
SEGMENT14_HIGH VARCHAR2 (60)
Key Flexfield range segment
SEGMENT14_TYPE VARCHAR2 (1)
Key Flexfield segment type
SEGMENT15_LOW VARCHAR2 (60)
Key Flexfield range segment
SEGMENT15_HIGH VARCHAR2 (60)
Key Flexfield range segment
SEGMENT15_TYPE VARCHAR2 (1)
Key Flexfield segment type
SEGMENT16_LOW VARCHAR2 (60)
Key Flexfield range segment
SEGMENT16_HIGH VARCHAR2 (60)
Key Flexfield range segment
SEGMENT16_TYPE VARCHAR2 (1)
Key Flexfield segment type
SEGMENT17_LOW VARCHAR2 (60)
Key Flexfield range segment
SEGMENT17_HIGH VARCHAR2 (60)
Key Flexfield range segment
SEGMENT17_TYPE VARCHAR2 (1)
Key Flexfield segment type
SEGMENT18_LOW VARCHAR2 (60)
Key Flexfield range segment
SEGMENT18_HIGH VARCHAR2 (60)
Key Flexfield range segment
SEGMENT18_TYPE VARCHAR2 (1)
Key Flexfield segment type
SEGMENT19_LOW VARCHAR2 (60)
Key Flexfield range segment
SEGMENT19_HIGH VARCHAR2 (60)
Key Flexfield range segment
SEGMENT19_TYPE VARCHAR2 (1)
Key Flexfield segment type
SEGMENT20_LOW VARCHAR2 (60)
Key Flexfield range segment
SEGMENT20_HIGH VARCHAR2 (60)
Key Flexfield range segment
SEGMENT20_TYPE VARCHAR2 (1)
Key Flexfield segment type
SEGMENT21_LOW VARCHAR2 (60)
Key Flexfield range segment
SEGMENT21_HIGH VARCHAR2 (60)
Key Flexfield range segment
SEGMENT21_TYPE VARCHAR2 (1)
Key Flexfield segment type
SEGMENT22_LOW VARCHAR2 (60)
Key Flexfield range segment
SEGMENT22_HIGH VARCHAR2 (60)
Key Flexfield range segment
SEGMENT22_TYPE VARCHAR2 (1)
Key Flexfield segment type
SEGMENT23_LOW VARCHAR2 (60)
Key Flexfield range segment
SEGMENT23_HIGH VARCHAR2 (60)
Key Flexfield range segment
SEGMENT23_TYPE VARCHAR2 (1)
Key Flexfield segment type
SEGMENT24_LOW VARCHAR2 (60)
Key Flexfield range segment
SEGMENT24_HIGH VARCHAR2 (60)
Key Flexfield range segment
SEGMENT24_TYPE VARCHAR2 (1)
Key Flexfield segment type
SEGMENT25_LOW VARCHAR2 (60)
Key Flexfield range segment
SEGMENT25_HIGH VARCHAR2 (60)
Key Flexfield range segment
SEGMENT25_TYPE VARCHAR2 (1)
Key Flexfield segment type
SEGMENT26_LOW VARCHAR2 (60)
Key Flexfield range segment
SEGMENT26_HIGH VARCHAR2 (60)
Key Flexfield range segment
SEGMENT26_TYPE VARCHAR2 (1)
Key Flexfield segment type
SEGMENT27_LOW VARCHAR2 (60)
Key Flexfield range segment
SEGMENT27_HIGH VARCHAR2 (60)
Key Flexfield range segment
SEGMENT27_TYPE VARCHAR2 (1)
Key Flexfield segment type
SEGMENT28_LOW VARCHAR2 (60)
Key Flexfield range segment
SEGMENT28_HIGH VARCHAR2 (60)
Key Flexfield range segment
SEGMENT28_TYPE VARCHAR2 (1)
Key Flexfield segment type
SEGMENT29_LOW VARCHAR2 (60)
Key Flexfield range segment
SEGMENT29_HIGH VARCHAR2 (60)
Key Flexfield range segment
SEGMENT29_TYPE VARCHAR2 (1)
Key Flexfield segment type
SEGMENT30_LOW VARCHAR2 (60)
Key Flexfield range segment
SEGMENT30_HIGH VARCHAR2 (60)
Key Flexfield range segment
SEGMENT30_TYPE VARCHAR2 (1)
Key Flexfield segment type
CONTEXT VARCHAR2 (30)
Descriptive flexfield context
ATTRIBUTE1 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE11 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive Flexfield segment
SEGMENT_ATTRIBUTE1_LOW VARCHAR2 (60)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE1_HIGH VARCHAR2 (60)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE1_TYPE VARCHAR2 (1)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE2_LOW VARCHAR2 (60)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE2_HIGH VARCHAR2 (60)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE2_TYPE VARCHAR2 (1)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE3_LOW VARCHAR2 (60)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE3_HIGH VARCHAR2 (60)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE3_TYPE VARCHAR2 (1)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE4_LOW VARCHAR2 (60)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE4_HIGH VARCHAR2 (60)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE4_TYPE VARCHAR2 (1)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE5_LOW VARCHAR2 (60)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE5_HIGH VARCHAR2 (60)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE5_TYPE VARCHAR2 (1)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE6_LOW VARCHAR2 (60)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE6_HIGH VARCHAR2 (60)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE6_TYPE VARCHAR2 (1)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE7_LOW VARCHAR2 (60)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE7_HIGH VARCHAR2 (60)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE7_TYPE VARCHAR2 (1)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE8_LOW VARCHAR2 (60)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE8_HIGH VARCHAR2 (60)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE8_TYPE VARCHAR2 (1)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE9_LOW VARCHAR2 (60)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE9_HIGH VARCHAR2 (60)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE9_TYPE VARCHAR2 (1)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE10_LOW VARCHAR2 (60)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE10_HIGH VARCHAR2 (60)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE10_TYPE VARCHAR2 (1)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE11_LOW VARCHAR2 (60)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE11_HIGH VARCHAR2 (60)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE11_TYPE VARCHAR2 (1)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE12_LOW VARCHAR2 (60)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE12_HIGH VARCHAR2 (60)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE12_TYPE VARCHAR2 (1)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE13_LOW VARCHAR2 (60)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE13_HIGH VARCHAR2 (60)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE13_TYPE VARCHAR2 (1)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE14_LOW VARCHAR2 (60)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE14_HIGH VARCHAR2 (60)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE14_TYPE VARCHAR2 (1)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE15_LOW VARCHAR2 (60)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE15_HIGH VARCHAR2 (60)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE15_TYPE VARCHAR2 (1)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE16_LOW VARCHAR2 (60)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE16_HIGH VARCHAR2 (60)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE16_TYPE VARCHAR2 (1)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE17_LOW VARCHAR2 (60)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE17_HIGH VARCHAR2 (60)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE17_TYPE VARCHAR2 (1)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE18_LOW VARCHAR2 (60)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE18_HIGH VARCHAR2 (60)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE18_TYPE VARCHAR2 (1)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE19_LOW VARCHAR2 (60)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE19_HIGH VARCHAR2 (60)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE19_TYPE VARCHAR2 (1)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE20_LOW VARCHAR2 (60)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE20_HIGH VARCHAR2 (60)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE20_TYPE VARCHAR2 (1)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE21_LOW VARCHAR2 (60)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE21_HIGH VARCHAR2 (60)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE21_TYPE VARCHAR2 (1)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE22_LOW VARCHAR2 (60)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE22_HIGH VARCHAR2 (60)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE22_TYPE VARCHAR2 (1)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE23_LOW VARCHAR2 (60)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE23_HIGH VARCHAR2 (60)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE23_TYPE VARCHAR2 (1)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE24_LOW VARCHAR2 (60)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE24_HIGH VARCHAR2 (60)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE24_TYPE VARCHAR2 (1)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE25_LOW VARCHAR2 (60)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE25_HIGH VARCHAR2 (60)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE25_TYPE VARCHAR2 (1)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE26_LOW VARCHAR2 (60)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE26_HIGH VARCHAR2 (60)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE26_TYPE VARCHAR2 (1)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE27_LOW VARCHAR2 (60)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE27_HIGH VARCHAR2 (60)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE27_TYPE VARCHAR2 (1)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE28_LOW VARCHAR2 (60)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE28_HIGH VARCHAR2 (60)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE28_TYPE VARCHAR2 (1)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE29_LOW VARCHAR2 (60)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE29_HIGH VARCHAR2 (60)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE29_TYPE VARCHAR2 (1)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE30_LOW VARCHAR2 (60)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE30_HIGH VARCHAR2 (60)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE30_TYPE VARCHAR2 (1)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE31_LOW VARCHAR2 (60)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE31_HIGH VARCHAR2 (60)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE31_TYPE VARCHAR2 (1)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE32_LOW VARCHAR2 (60)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE32_HIGH VARCHAR2 (60)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE32_TYPE VARCHAR2 (1)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE33_LOW VARCHAR2 (60)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE33_HIGH VARCHAR2 (60)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE33_TYPE VARCHAR2 (1)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE34_LOW VARCHAR2 (60)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE34_HIGH VARCHAR2 (60)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE34_TYPE VARCHAR2 (1)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE35_LOW VARCHAR2 (60)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE35_HIGH VARCHAR2 (60)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE35_TYPE VARCHAR2 (1)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE36_LOW VARCHAR2 (60)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE36_HIGH VARCHAR2 (60)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE36_TYPE VARCHAR2 (1)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE37_LOW VARCHAR2 (60)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE37_HIGH VARCHAR2 (60)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE37_TYPE VARCHAR2 (1)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE38_LOW VARCHAR2 (60)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE38_HIGH VARCHAR2 (60)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE38_TYPE VARCHAR2 (1)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE39_LOW VARCHAR2 (60)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE39_HIGH VARCHAR2 (60)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE39_TYPE VARCHAR2 (1)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE40_LOW VARCHAR2 (60)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE40_HIGH VARCHAR2 (60)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE40_TYPE VARCHAR2 (1)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE41_LOW VARCHAR2 (60)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE41_HIGH VARCHAR2 (60)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE41_TYPE VARCHAR2 (1)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE42_LOW VARCHAR2 (60)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE42_HIGH VARCHAR2 (60)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE42_TYPE VARCHAR2 (1)
Reporting Attribute Segment (Public Sector Financials)
LEDGER_SEGMENT_TYPE VARCHAR2 (1) Y Ledger segment type
ALC_LEDGER_CURRENCY VARCHAR2 (30)
Reporting ledger currency

[top of page]

RG.RG_REPORT_AXIS_CONTENTS does not reference any database object

RG.RG_REPORT_AXIS_CONTENTS is referenced by following:

RG
VIEW - RG_REPORT_AXIS_CONTENTS#

[top of page]

Table: RG_REPORT_AXIS_SETS

Description: Row and column set definitions
Primary Key: RG_REPORT_AXIS_SETS_PK
  1. AXIS_SET_ID
Primary Key: RG_REPORT_AXIS_SETS_UK1
  1. NAME
  2. AXIS_SET_TYPE
  3. APPLICATION_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
RG_REPORT_AXIS_SETS.APPLICATION_ID
RG_REPORT_AXIS_SETS.ID_FLEX_CODE_11I
RG_REPORT_AXIS_SETS.STRUCTURE_ID
FND_ID_FLEX_STRUCTURES
RG_REPORT_AXIS_SETS.TAXONOMY_ID RG_XBRL_TAXONOMIES
Foreign Keys to this table:
Foreign Key Column Foreign Table
RG_REPORTS.COLUMN_SET_ID RG_REPORT_AXIS_SETS
RG_REPORTS.ROW_SET_ID RG_REPORT_AXIS_SETS
RG_REPORT_AXES.AXIS_SET_ID RG_REPORT_AXIS_SETS
RG_REPORT_DISPLAY_GROUPS.COLUMN_SET_ID RG_REPORT_AXIS_SETS
RG_REPORT_DISPLAY_GROUPS.ROW_SET_ID RG_REPORT_AXIS_SETS
RG_REPORT_DISPLAY_SETS.COLUMN_SET_ID RG_REPORT_AXIS_SETS
RG_REPORT_DISPLAY_SETS.ROW_SET_ID RG_REPORT_AXIS_SETS
Comments

RG_REPORT_AXIS_SETS stores information about all of the row sets and column sets currently defined in Financial Statement Generator. Each row includes an axis set identifier, a row set name or a column set name, and a structure identifier to assign a specific chart of accounts to the row set or column set.
Financial Statement Generator uses the report axis sets as the basis which many report axes, axis contents, and report calculations can be linked for later reporting.

Indexes
Index Type Tablespace Column
RG_REPORT_AXIS_SETS_U1 UNIQUE APPS_TS_TX_IDX AXIS_SET_ID
ZD_EDITION_NAME
RG_REPORT_AXIS_SETS_U2 UNIQUE APPS_TS_TX_IDX NAME
AXIS_SET_TYPE
APPLICATION_ID
ZD_EDITION_NAME
SYS_IL0000045474C00033$$ UNIQUE APPS_TS_TX_DATA
RG_REPORT_AXIS_SETS_N1 NONUNIQUE APPS_TS_TX_IDX SEEDED_NAME
Columns
Name Datatype Length Mandatory Comments
APPLICATION_ID NUMBER (15) Y Application defining column
AXIS_SET_ID NUMBER (15) Y Row set or column set defining column
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15) Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER (15) Y Standard Who column
NAME VARCHAR2 (30) Y Row set or column set name
AXIS_SET_TYPE VARCHAR2 (1) Y Row set or column set
DISPLAY_IN_LIST_FLAG VARCHAR2 (1)
No longer used
PERIOD_SET_NAME VARCHAR2 (15)
No longer used
DESCRIPTION VARCHAR2 (240)
Row set or column set description
ROW_SET_TITLE VARCHAR2 (240)
No longer used
SEGMENT_NAME VARCHAR2 (30)
Override segment
ID_FLEX_CODE_11I VARCHAR2 (4)
Obsolete
STRUCTURE_ID NUMBER (15)
Key flexfield structure defining column
CONTEXT VARCHAR2 (30)
Descriptive flexfield context
ATTRIBUTE1 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE11 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive Flexfield segment
COLUMN_SET_HEADER CLOB (4000)
Column set header
TAXONOMY_ID NUMBER (15)
Oracle Internal use only - reserved for future use
ID_FLEX_CODE VARCHAR2 (4)
GLLE
SECURITY_FLAG VARCHAR2 (1) Y Security flag
SEEDED_NAME VARCHAR2 (30)
Seeded name
ZD_EDITION_NAME VARCHAR2 (30) Y

[top of page]

RG.RG_REPORT_AXIS_SETS does not reference any database object

RG.RG_REPORT_AXIS_SETS is referenced by following:

RG
VIEW - RG_REPORT_AXIS_SETS#

[top of page]

Table: RG_REPORT_CALCULATIONS

Description: Calculations defined for rows and columns
Primary Key: RG_REPORT_CALCULATIONS_PK
  1. AXIS_SET_ID
  2. AXIS_SEQ
  3. CALCULATION_SEQ
Foreign Keys from this table:
Foreign Key Column Foreign Table
RG_REPORT_CALCULATIONS.AXIS_SET_ID
RG_REPORT_CALCULATIONS.AXIS_SEQ
RG_REPORT_AXES
RG_REPORT_CALCULATIONS.AXIS_SET_ID
RG_REPORT_CALCULATIONS.AXIS_SEQ_HIGH
RG_REPORT_AXES
RG_REPORT_CALCULATIONS.AXIS_SET_ID
RG_REPORT_CALCULATIONS.AXIS_SEQ_LOW
RG_REPORT_AXES
Comments

RG_REPORT_CALCULATIONS stores information about all of the calculations defined in Financial Statement Generator. Each row includes an axis set identifier and an axis sequence which are used to link the calculations to a particular row or column. It also contains information about one specific calculation operation defined in Financial Statement Generator.

Indexes
Index Type Tablespace Column
RG_REPORT_CALCULATIONS_N1 NONUNIQUE APPS_TS_TX_IDX AXIS_SET_ID
AXIS_SEQ
Columns
Name Datatype Length Mandatory Comments
APPLICATION_ID NUMBER (15) Y Application defining column
AXIS_SET_ID NUMBER (15) Y Defining column for the column set or row set these calculations belong to
AXIS_SEQ NUMBER
Y Sequence number of the column or row these calculations belong to
CALCULATION_SEQ NUMBER
Y Sequence number of the calculation step
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15) Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER (15) Y Standard Who column
OPERATOR VARCHAR2 (10)
Operator to use in the calculation
AXIS_SEQ_LOW NUMBER

Sequence number range low to perform calculation with
AXIS_SEQ_HIGH NUMBER

Sequence number range high to perform calculation with
AXIS_NAME_LOW VARCHAR2 (30)
Name of column or row to perform calculation with
AXIS_NAME_HIGH VARCHAR2 (30)
Name of column or row to perform calculation with (same as axis_name_low)
CONSTANT NUMBER

Constant value to perform calculation with
CONTEXT VARCHAR2 (30)
Descriptive Flexfield context
ATTRIBUTE1 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE11 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive Flexfield segment

[top of page]

RG.RG_REPORT_CALCULATIONS does not reference any database object

RG.RG_REPORT_CALCULATIONS is referenced by following:

RG
VIEW - RG_REPORT_CALCULATIONS#

[top of page]

Table: RG_REPORT_CONTENT_OVERRIDES

Description: Assignments of account ranges to content sets
Primary Key: RG_REPORT_CONTENT_OVERRIDES_PK
  1. CONTENT_SET_ID
  2. OVERRIDE_SEQ
Foreign Keys from this table:
Foreign Key Column Foreign Table
RG_REPORT_CONTENT_OVERRIDES.CONTENT_SET_ID RG_REPORT_CONTENT_SETS
RG_REPORT_CONTENT_OVERRIDES.LEDGER_ID GL_LEDGERS
Comments

RG_REPORT_CONTENT_OVERRIDES stores information about all of the content overrides defined in Financial Statement Generator.
Each row includes a content set identifier and a specific set of override contents associated with the content set identifier. It also contains information about one set of content overrides.
Financial Statement Generator links report content overrides to a override set. Financial Statement Generator then uses the combination of the content override and the report content set to override specific segment values in a row set or a column set.

Indexes
Index Type Tablespace Column
RG_REPORT_CONTENT_OVERRIDES_U1 UNIQUE APPS_TS_TX_IDX CONTENT_SET_ID
OVERRIDE_SEQ
Columns
Name Datatype Length Mandatory Comments
APPLICATION_ID NUMBER (15) Y Application defining column
CONTENT_SET_ID NUMBER (15) Y Defining column for the content set these flexfield ranges belong to
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15) Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER (15) Y Standard Who column
OVERRIDE_SEQ NUMBER (15) Y Sequence number for this flexfield range
RANGE_MODE VARCHAR2 (1)
Summary flag indicating whether summary values are in the flexfield range
SEGMENT1_LOW VARCHAR2 (60)
Key Flexfield range segment
SEGMENT1_HIGH VARCHAR2 (60)
Key Flexfield range segment
SEGMENT1_TYPE VARCHAR2 (2)
Key Flexfield segment type
SEGMENT2_LOW VARCHAR2 (60)
Key Flexfield range segment
SEGMENT2_HIGH VARCHAR2 (60)
Key Flexfield range segment
SEGMENT2_TYPE VARCHAR2 (2)
Key Flexfield segment type
SEGMENT3_LOW VARCHAR2 (60)
Key Flexfield range segment
SEGMENT3_HIGH VARCHAR2 (60)
Key Flexfield range segment
SEGMENT3_TYPE VARCHAR2 (2)
Key Flexfield segment type
SEGMENT4_LOW VARCHAR2 (60)
Key Flexfield range segment
SEGMENT4_HIGH VARCHAR2 (60)
Key Flexfield range segment
SEGMENT4_TYPE VARCHAR2 (2)
Key Flexfield segment type
SEGMENT5_LOW VARCHAR2 (60)
Key Flexfield range segment
SEGMENT5_HIGH VARCHAR2 (60)
Key Flexfield range segment
SEGMENT5_TYPE VARCHAR2 (2)
Key Flexfield segment type
SEGMENT6_LOW VARCHAR2 (60)
Key Flexfield range segment
SEGMENT6_HIGH VARCHAR2 (60)
Key Flexfield range segment
SEGMENT6_TYPE VARCHAR2 (2)
Key Flexfield segment type
SEGMENT7_LOW VARCHAR2 (60)
Key Flexfield range segment
SEGMENT7_HIGH VARCHAR2 (60)
Key Flexfield range segment
SEGMENT7_TYPE VARCHAR2 (2)
Key Flexfield segment type
SEGMENT8_LOW VARCHAR2 (60)
Key Flexfield range segment
SEGMENT8_HIGH VARCHAR2 (60)
Key Flexfield range segment
SEGMENT8_TYPE VARCHAR2 (2)
Key Flexfield segment type
SEGMENT9_LOW VARCHAR2 (60)
Key Flexfield range segment
SEGMENT9_HIGH VARCHAR2 (60)
Key Flexfield range segment
SEGMENT9_TYPE VARCHAR2 (2)
Key Flexfield segment type
SEGMENT10_LOW VARCHAR2 (60)
Key Flexfield range segment
SEGMENT10_HIGH VARCHAR2 (60)
Key Flexfield range segment
SEGMENT10_TYPE VARCHAR2 (2)
Key Flexfield segment type
SEGMENT11_LOW VARCHAR2 (60)
Key Flexfield range segment
SEGMENT11_HIGH VARCHAR2 (60)
Key Flexfield range segment
SEGMENT11_TYPE VARCHAR2 (2)
Key Flexfield segment type
SEGMENT12_LOW VARCHAR2 (60)
Key Flexfield range segment
SEGMENT12_HIGH VARCHAR2 (60)
Key Flexfield range segment
SEGMENT12_TYPE VARCHAR2 (2)
Key Flexfield segment type
SEGMENT13_LOW VARCHAR2 (60)
Key Flexfield range segment
SEGMENT13_HIGH VARCHAR2 (60)
Key Flexfield range segment
SEGMENT13_TYPE VARCHAR2 (2)
Key Flexfield segment type
SEGMENT14_LOW VARCHAR2 (60)
Key Flexfield range segment
SEGMENT14_HIGH VARCHAR2 (60)
Key Flexfield range segment
SEGMENT14_TYPE VARCHAR2 (2)
Key Flexfield segment type
SEGMENT15_LOW VARCHAR2 (60)
Key Flexfield range segment
SEGMENT15_HIGH VARCHAR2 (60)
Key Flexfield range segment
SEGMENT15_TYPE VARCHAR2 (2)
Key Flexfield segment type
SEGMENT16_LOW VARCHAR2 (60)
Key Flexfield range segment
SEGMENT16_HIGH VARCHAR2 (60)
Key Flexfield range segment
SEGMENT16_TYPE VARCHAR2 (2)
Key Flexfield segment type
SEGMENT17_LOW VARCHAR2 (60)
Key Flexfield range segment
SEGMENT17_HIGH VARCHAR2 (60)
Key Flexfield range segment
SEGMENT17_TYPE VARCHAR2 (2)
Key Flexfield segment type
SEGMENT18_LOW VARCHAR2 (60)
Key Flexfield range segment
SEGMENT18_HIGH VARCHAR2 (60)
Key Flexfield range segment
SEGMENT18_TYPE VARCHAR2 (2)
Key Flexfield segment type
SEGMENT19_LOW VARCHAR2 (60)
Key Flexfield range segment
SEGMENT19_HIGH VARCHAR2 (60)
Key Flexfield range segment
SEGMENT19_TYPE VARCHAR2 (2)
Key Flexfield segment type
SEGMENT20_LOW VARCHAR2 (60)
Key Flexfield range segment
SEGMENT20_HIGH VARCHAR2 (60)
Key Flexfield range segment
SEGMENT20_TYPE VARCHAR2 (2)
Key Flexfield segment type
SEGMENT21_LOW VARCHAR2 (60)
Key Flexfield range segment
SEGMENT21_HIGH VARCHAR2 (60)
Key Flexfield range segment
SEGMENT21_TYPE VARCHAR2 (2)
Key Flexfield segment type
SEGMENT22_LOW VARCHAR2 (60)
Key Flexfield range segment
SEGMENT22_HIGH VARCHAR2 (60)
Key Flexfield range segment
SEGMENT22_TYPE VARCHAR2 (2)
Key Flexfield segment type
SEGMENT23_LOW VARCHAR2 (60)
Key Flexfield range segment
SEGMENT23_HIGH VARCHAR2 (60)
Key Flexfield range segment
SEGMENT23_TYPE VARCHAR2 (2)
Key Flexfield segment type
SEGMENT24_LOW VARCHAR2 (60)
Key Flexfield range segment
SEGMENT24_HIGH VARCHAR2 (60)
Key Flexfield range segment
SEGMENT24_TYPE VARCHAR2 (2)
Key Flexfield segment type
SEGMENT25_LOW VARCHAR2 (60)
Key Flexfield range segment
SEGMENT25_HIGH VARCHAR2 (60)
Key Flexfield range segment
SEGMENT25_TYPE VARCHAR2 (2)
Key Flexfield segment type
SEGMENT26_LOW VARCHAR2 (60)
Key Flexfield range segment
SEGMENT26_HIGH VARCHAR2 (60)
Key Flexfield range segment
SEGMENT26_TYPE VARCHAR2 (2)
Key Flexfield segment type
SEGMENT27_LOW VARCHAR2 (60)
Key Flexfield range segment
SEGMENT27_HIGH VARCHAR2 (60)
Key Flexfield range segment
SEGMENT27_TYPE VARCHAR2 (2)
Key Flexfield segment type
SEGMENT28_LOW VARCHAR2 (60)
Key Flexfield range segment
SEGMENT28_HIGH VARCHAR2 (60)
Key Flexfield range segment
SEGMENT28_TYPE VARCHAR2 (2)
Key Flexfield segment type
SEGMENT29_LOW VARCHAR2 (60)
Key Flexfield range segment
SEGMENT29_HIGH VARCHAR2 (60)
Key Flexfield range segment
SEGMENT29_TYPE VARCHAR2 (2)
Key Flexfield segment type
SEGMENT30_LOW VARCHAR2 (60)
Key Flexfield range segment
SEGMENT30_HIGH VARCHAR2 (60)
Key Flexfield range segment
SEGMENT30_TYPE VARCHAR2 (2)
Key Flexfield segment type
CONTEXT VARCHAR2 (30)
Descriptive Flexfield context
ATTRIBUTE1 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE11 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive Flexfield segment
SEGMENT_ATTRIBUTE1_LOW VARCHAR2 (60)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE1_HIGH VARCHAR2 (60)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE1_TYPE VARCHAR2 (2)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE2_LOW VARCHAR2 (60)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE2_HIGH VARCHAR2 (60)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE2_TYPE VARCHAR2 (2)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE3_LOW VARCHAR2 (60)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE3_HIGH VARCHAR2 (60)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE3_TYPE VARCHAR2 (2)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE4_LOW VARCHAR2 (60)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE4_HIGH VARCHAR2 (60)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE4_TYPE VARCHAR2 (2)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE5_LOW VARCHAR2 (60)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE5_HIGH VARCHAR2 (60)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE5_TYPE VARCHAR2 (2)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE6_LOW VARCHAR2 (60)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE6_HIGH VARCHAR2 (60)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE6_TYPE VARCHAR2 (2)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE7_LOW VARCHAR2 (60)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE7_HIGH VARCHAR2 (60)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE7_TYPE VARCHAR2 (2)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE8_LOW VARCHAR2 (60)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE8_HIGH VARCHAR2 (60)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE8_TYPE VARCHAR2 (2)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE9_LOW VARCHAR2 (60)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE9_HIGH VARCHAR2 (60)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE9_TYPE VARCHAR2 (2)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE10_LOW VARCHAR2 (60)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE10_HIGH VARCHAR2 (60)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE10_TYPE VARCHAR2 (2)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE11_LOW VARCHAR2 (60)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE11_HIGH VARCHAR2 (60)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE11_TYPE VARCHAR2 (2)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE12_LOW VARCHAR2 (60)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE12_HIGH VARCHAR2 (60)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE12_TYPE VARCHAR2 (2)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE13_LOW VARCHAR2 (60)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE13_HIGH VARCHAR2 (60)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE13_TYPE VARCHAR2 (2)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE14_LOW VARCHAR2 (60)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE14_HIGH VARCHAR2 (60)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE14_TYPE VARCHAR2 (2)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE15_LOW VARCHAR2 (60)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE15_HIGH VARCHAR2 (60)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE15_TYPE VARCHAR2 (2)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE16_LOW VARCHAR2 (60)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE16_HIGH VARCHAR2 (60)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE16_TYPE VARCHAR2 (2)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE17_LOW VARCHAR2 (60)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE17_HIGH VARCHAR2 (60)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE17_TYPE VARCHAR2 (2)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE18_LOW VARCHAR2 (60)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE18_HIGH VARCHAR2 (60)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE18_TYPE VARCHAR2 (2)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE19_LOW VARCHAR2 (60)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE19_HIGH VARCHAR2 (60)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE19_TYPE VARCHAR2 (2)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE20_LOW VARCHAR2 (60)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE20_HIGH VARCHAR2 (60)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE20_TYPE VARCHAR2 (2)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE21_LOW VARCHAR2 (60)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE21_HIGH VARCHAR2 (60)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE21_TYPE VARCHAR2 (2)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE22_LOW VARCHAR2 (60)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE22_HIGH VARCHAR2 (60)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE22_TYPE VARCHAR2 (2)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE23_LOW VARCHAR2 (60)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE23_HIGH VARCHAR2 (60)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE23_TYPE VARCHAR2 (2)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE24_LOW VARCHAR2 (60)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE24_HIGH VARCHAR2 (60)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE24_TYPE VARCHAR2 (2)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE25_LOW VARCHAR2 (60)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE25_HIGH VARCHAR2 (60)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE25_TYPE VARCHAR2 (2)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE26_LOW VARCHAR2 (60)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE26_HIGH VARCHAR2 (60)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE26_TYPE VARCHAR2 (2)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE27_LOW VARCHAR2 (60)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE27_HIGH VARCHAR2 (60)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE27_TYPE VARCHAR2 (2)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE28_LOW VARCHAR2 (60)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE28_HIGH VARCHAR2 (60)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE28_TYPE VARCHAR2 (2)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE29_LOW VARCHAR2 (60)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE29_HIGH VARCHAR2 (60)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE29_TYPE VARCHAR2 (2)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE30_LOW VARCHAR2 (60)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE30_HIGH VARCHAR2 (60)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE30_TYPE VARCHAR2 (2)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE31_LOW VARCHAR2 (60)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE31_HIGH VARCHAR2 (60)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE31_TYPE VARCHAR2 (2)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE32_LOW VARCHAR2 (60)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE32_HIGH VARCHAR2 (60)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE32_TYPE VARCHAR2 (2)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE33_LOW VARCHAR2 (60)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE33_HIGH VARCHAR2 (60)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE33_TYPE VARCHAR2 (2)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE34_LOW VARCHAR2 (60)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE34_HIGH VARCHAR2 (60)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE34_TYPE VARCHAR2 (2)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE35_LOW VARCHAR2 (60)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE35_HIGH VARCHAR2 (60)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE35_TYPE VARCHAR2 (2)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE36_LOW VARCHAR2 (60)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE36_HIGH VARCHAR2 (60)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE36_TYPE VARCHAR2 (2)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE37_LOW VARCHAR2 (60)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE37_HIGH VARCHAR2 (60)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE37_TYPE VARCHAR2 (2)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE38_LOW VARCHAR2 (60)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE38_HIGH VARCHAR2 (60)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE38_TYPE VARCHAR2 (2)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE39_LOW VARCHAR2 (60)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE39_HIGH VARCHAR2 (60)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE39_TYPE VARCHAR2 (2)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE40_LOW VARCHAR2 (60)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE40_HIGH VARCHAR2 (60)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE40_TYPE VARCHAR2 (2)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE41_LOW VARCHAR2 (60)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE41_HIGH VARCHAR2 (60)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE41_TYPE VARCHAR2 (2)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE42_LOW VARCHAR2 (60)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE42_HIGH VARCHAR2 (60)
Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE42_TYPE VARCHAR2 (2)
Reporting Attribute Segment (Public Sector Financials)
LEDGER_SEGMENT_TYPE VARCHAR2 (2) Y Ledger segment type
LEDGER_ID NUMBER (15)
Ledger defining column
ALC_LEDGER_CURRENCY VARCHAR2 (30)
Reporting ledger currency

[top of page]

RG.RG_REPORT_CONTENT_OVERRIDES does not reference any database object

RG.RG_REPORT_CONTENT_OVERRIDES is referenced by following:

RG
VIEW - RG_REPORT_CONTENT_OVERRIDES#

[top of page]

Table: RG_REPORT_CONTENT_SETS

Description: Content set definitions
Primary Key: RG_REPORT_CONTENT_SETS_PK
  1. CONTENT_SET_ID
Primary Key: RG_REPORT_CONTENT_SETS_UK
  1. NAME
  2. APPLICATION_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
RG_REPORT_CONTENT_SETS.APPLICATION_ID
RG_REPORT_CONTENT_SETS.ID_FLEX_CODE_11I
RG_REPORT_CONTENT_SETS.STRUCTURE_ID
FND_ID_FLEX_STRUCTURES
Foreign Keys to this table:
Foreign Key Column Foreign Table
RG_REPORTS.CONTENT_SET_ID RG_REPORT_CONTENT_SETS
RG_REPORT_CONTENT_OVERRIDES.CONTENT_SET_ID RG_REPORT_CONTENT_SETS
RG_REPORT_REQUESTS.CONTENT_SET_ID RG_REPORT_CONTENT_SETS
Comments

RG_REPORT_CONTENT_SETS stores information about all of the content sets currently defined in Financial Statement Generator. Each row includes a content set identifier, a name, and a structure identifier that links account assignments to the content set. Financial Statement Generator uses this information to link the content set to content overrides and then uses the combination of the content set and content overrides to override specific row or column account segment values at the report level.

Indexes
Index Type Tablespace Column
RG_REPORT_CONTENT_SETS_U1 UNIQUE APPS_TS_TX_IDX CONTENT_SET_ID
RG_REPORT_CONTENT_SETS_U2 UNIQUE APPS_TS_TX_IDX NAME
APPLICATION_ID
Columns
Name Datatype Length Mandatory Comments
APPLICATION_ID NUMBER (15) Y Application defining column
CONTENT_SET_ID NUMBER (15) Y Content set defining column
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15) Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER (15) Y Standard Who column
NAME VARCHAR2 (30) Y Content set name
REPORT_RUN_TYPE VARCHAR2 (1) Y Report run type (parallel or sequential)
ID_FLEX_CODE_11I VARCHAR2 (4)
GL# or GLAT
STRUCTURE_ID NUMBER (15) Y Key Flexfield structure defining column
DESCRIPTION VARCHAR2 (240)
Content set description
CONTEXT VARCHAR2 (30)
Descriptive Flexfield context
ATTRIBUTE1 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE11 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive Flexfield segment
SECURITY_FLAG VARCHAR2 (1) Y Security flag
ID_FLEX_CODE VARCHAR2 (4) Y GLLE

[top of page]

RG.RG_REPORT_CONTENT_SETS does not reference any database object

RG.RG_REPORT_CONTENT_SETS is referenced by following:

RG
VIEW - RG_REPORT_CONTENT_SETS#

[top of page]

Table: RG_REPORT_DISPLAYS

Description: Assignments of report display groups to report display sets
Primary Key: RG_REPORT_DISPLAYS_PK
  1. REPORT_DISPLAY_ID
Primary Key: RG_REPORT_DISPLAYS_UK
  1. REPORT_DISPLAY_SET_ID
  2. SEQUENCE
Foreign Keys from this table:
Foreign Key Column Foreign Table
RG_REPORT_DISPLAYS.REPORT_DISPLAY_SET_ID RG_REPORT_DISPLAY_SETS
RG_REPORT_DISPLAYS.ROW_GROUP_ID RG_REPORT_DISPLAY_GROUPS
RG_REPORT_DISPLAYS.COLUMN_GROUP_ID RG_REPORT_DISPLAY_GROUPS
Comments

RG_REPORT_DISPLAYS stores report display group assignments to report display sets. Each row includes a sequence number, a row group, a column group and a description. It also includes a display flag to determine whether the value will be displayed or not.

Indexes
Index Type Tablespace Column
RG_REPORT_DISPLAYS_U1 UNIQUE APPS_TS_TX_IDX REPORT_DISPLAY_ID
RG_REPORT_DISPLAYS_U2 UNIQUE APPS_TS_TX_IDX REPORT_DISPLAY_SET_ID
SEQUENCE
RG_REPORT_DISPLAYS_N1 NONUNIQUE APPS_TS_TX_IDX ROW_GROUP_ID
RG_REPORT_DISPLAYS_N2 NONUNIQUE APPS_TS_TX_IDX COLUMN_GROUP_ID
Columns
Name Datatype Length Mandatory Comments
REPORT_DISPLAY_ID NUMBER (15) Y Report display group defining column
REPORT_DISPLAY_SET_ID NUMBER (15) Y Report display set defining column
SEQUENCE NUMBER
Y Display sequence in the display set
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15) Y Standard Who column
DISPLAY_FLAG VARCHAR2 (1) Y Flag to determine whether the value will be displayed
ROW_GROUP_ID NUMBER (15)
Row display group defining column
COLUMN_GROUP_ID NUMBER (15)
Column display group defining column
DESCRIPTION VARCHAR2 (240)
Report display descriptions
CONTEXT VARCHAR2 (30)
context
ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield segment

[top of page]

RG.RG_REPORT_DISPLAYS does not reference any database object

RG.RG_REPORT_DISPLAYS is referenced by following:

RG
VIEW - RG_REPORT_DISPLAYS#

[top of page]

Table: RG_REPORT_DISPLAY_GROUPS

Description: Report display group definitions
Primary Key: RG_REPORT_DISPLAY_GROUPS_PK
  1. REPORT_DISPLAY_GROUP_ID
Primary Key: RG_REPORT_DISPLAY_GROUPS_UK
  1. NAME
Foreign Keys from this table:
Foreign Key Column Foreign Table
RG_REPORT_DISPLAY_GROUPS.COLUMN_SET_ID RG_REPORT_AXIS_SETS
RG_REPORT_DISPLAY_GROUPS.ROW_SET_ID RG_REPORT_AXIS_SETS
Foreign Keys to this table:
Foreign Key Column Foreign Table
RG_REPORT_DISPLAYS.ROW_GROUP_ID RG_REPORT_DISPLAY_GROUPS
RG_REPORT_DISPLAYS.COLUMN_GROUP_ID RG_REPORT_DISPLAY_GROUPS
Comments

RG_REPORT_DISPLAY_GROUPS stores report display groups information which is used in report display sets. Each row includes a row set identifier, a column set identifier and a range of sequences.

Indexes
Index Type Tablespace Column
RG_REPORT_DISPLAY_GROUPS_U1 UNIQUE APPS_TS_TX_IDX REPORT_DISPLAY_GROUP_ID
RG_REPORT_DISPLAY_GROUPS_U2 UNIQUE APPS_TS_TX_IDX NAME
Columns
Name Datatype Length Mandatory Comments
REPORT_DISPLAY_GROUP_ID NUMBER (15) Y Display group defining column
NAME VARCHAR2 (30) Y Report display group name
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15) Y Standard Who column
FROM_SEQUENCE NUMBER
Y Starting axis sequence
TO_SEQUENCE NUMBER
Y Ending axis sequence
DESCRIPTION VARCHAR2 (240)
Report display group description
ROW_SET_ID NUMBER (15)
Row set defining column
COLUMN_SET_ID NUMBER (15)
Column set defining column
CONTEXT VARCHAR2 (30)
Descriptive flexfield context
ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield segment

[top of page]

RG.RG_REPORT_DISPLAY_GROUPS does not reference any database object

RG.RG_REPORT_DISPLAY_GROUPS is referenced by following:

RG
VIEW - RG_REPORT_DISPLAY_GROUPS#

[top of page]

Table: RG_REPORT_DISPLAY_SETS

Description: Report display set definitions
Primary Key: RG_REPORT_DISPLAY_SETS_PK
  1. REPORT_DISPLAY_SET_ID
Primary Key: RG_REPORT_DISPLAY_SETS_UK
  1. NAME
Foreign Keys from this table:
Foreign Key Column Foreign Table
RG_REPORT_DISPLAY_SETS.COLUMN_SET_ID RG_REPORT_AXIS_SETS
RG_REPORT_DISPLAY_SETS.ROW_SET_ID RG_REPORT_AXIS_SETS
Foreign Keys to this table:
Foreign Key Column Foreign Table
RG_REPORTS.REPORT_DISPLAY_SET_ID RG_REPORT_DISPLAY_SETS
RG_REPORT_DISPLAYS.REPORT_DISPLAY_SET_ID RG_REPORT_DISPLAY_SETS
RG_REPORT_REQUESTS.REPORT_DISPLAY_SET_ID RG_REPORT_DISPLAY_SETS
Comments

RG_REPORT_DISPLAY_SETS stores information about report display sets currently defined in Financial Statement Generator. Each row includes a report display set identifier, a report display set name, a row set identifier and a column set identifier.
Financial Statement Generator uses the Display Set form to define report display sets for specific row and column sets or generic report display sets which work with any row and column set. You can even create report display sets which work with only one row set but without any column set or vice versa. You cannot delete a report display set if it is used in any report.

Indexes
Index Type Tablespace Column
RG_REPORT_DISPLAY_SETS_U1 UNIQUE APPS_TS_TX_IDX REPORT_DISPLAY_SET_ID
RG_REPORT_DISPLAY_SETS_U2 UNIQUE APPS_TS_TX_IDX NAME
RG_REPORT_DISPLAY_SETS_N1 NONUNIQUE APPS_TS_TX_IDX ROW_SET_ID
RG_REPORT_DISPLAY_SETS_N2 NONUNIQUE APPS_TS_TX_IDX COLUMN_SET_ID
Columns
Name Datatype Length Mandatory Comments
REPORT_DISPLAY_SET_ID NUMBER (15) Y Display set defining column
NAME VARCHAR2 (30) Y Report display set name
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15) Y Standard Who column
ROW_SET_ID NUMBER (15)
Row set defining column
COLUMN_SET_ID NUMBER (15)
Column set defining column
DESCRIPTION VARCHAR2 (240)
Report display set description
CONTEXT VARCHAR2 (30)
Descriptive flexfield context
ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield segment

[top of page]

RG.RG_REPORT_DISPLAY_SETS does not reference any database object

RG.RG_REPORT_DISPLAY_SETS is referenced by following:

RG
VIEW - RG_REPORT_DISPLAY_SETS#

[top of page]

Table: RG_REPORT_EXCEPTIONS

Description: Exception conditions for columns
Primary Key: RG_REPORT_EXCEPTIONS_PK
  1. EXCEPTION_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
RG_REPORT_EXCEPTIONS.AXIS_SET_ID
RG_REPORT_EXCEPTIONS.AXIS_SEQ
RG_REPORT_AXES
Foreign Keys to this table:
Foreign Key Column Foreign Table
RG_REPORT_EXCEPTION_FLAGS.EXCEPTION_ID RG_REPORT_EXCEPTIONS
Comments

RG_REPORT_EXCEPTIONS stores information about the conditions that must be met in order for each exception to be true. Each row contains an axis set identifier, an axis sequence number, an exception identifier, and a condition.
Financial Statement Generator uses this information to link exception conditions and the exception flag to a particular column in a column set. You can define only one flag and one set of conditions per column. .

Indexes
Index Type Tablespace Column
RG_REPORT_EXCEPTIONS_N1 NONUNIQUE APPS_TS_TX_IDX EXCEPTION_ID
AXIS_SET_ID
AXIS_SEQ
Columns
Name Datatype Length Mandatory Comments
APPLICATION_ID NUMBER (15) Y Application defining column
AXIS_SET_ID NUMBER (15) Y Defining column for the column set the exception refers to
AXIS_SEQ NUMBER
Y Sequence number of the column the exception is defined on
EXCEPTION_ID NUMBER (15) Y Exception defining column
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15) Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER (15) Y Standard Who column
CONDITION VARCHAR2 (2) Y Condition for this exception (>, <, <=, etc.)
CONSTANT NUMBER
Y Constant value to compare column value against
CONTEXT VARCHAR2 (30)
Descriptive Flexfield context
ATTRIBUTE1 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE11 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive Flexfield segment

[top of page]

RG.RG_REPORT_EXCEPTIONS does not reference any database object

RG.RG_REPORT_EXCEPTIONS is referenced by following:

RG
VIEW - RG_REPORT_EXCEPTIONS#

[top of page]

Table: RG_REPORT_EXCEPTION_FLAGS

Description: Symbols used to indicate exceptions
Primary Key: RG_REPORT_EXCEPTION_FLAGS_PK
  1. EXCEPTION_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
RG_REPORT_EXCEPTION_FLAGS.EXCEPTION_ID RG_REPORT_EXCEPTIONS
RG_REPORT_EXCEPTION_FLAGS.AXIS_SET_ID
RG_REPORT_EXCEPTION_FLAGS.AXIS_SEQ
RG_REPORT_AXES
Comments

RG_REPORT_EXCEPTION_FLAGS stores information about all of the symbols used to indicate exceptions and descriptions of the symbols.
Each row contains information about one particular symbol used to indicate an exception, the description of the symbol, an axis set identifier, an axis sequence number, and an exception identifier.
Financial Statement Generator uses this information to link the exception flag to a set of exception conditions assigned in a particular column.

Indexes
Index Type Tablespace Column
RG_REPORT_EXCEPTION_FLAGS_U1 UNIQUE APPS_TS_TX_IDX EXCEPTION_ID
RG_REPORT_EXCEPTION_FLAGS_U2 UNIQUE APPS_TS_TX_IDX AXIS_SET_ID
AXIS_SEQ
Columns
Name Datatype Length Mandatory Comments
APPLICATION_ID NUMBER (15) Y Application defining column
AXIS_SET_ID NUMBER (15) Y Defining column for the column set this exception refers to
AXIS_SEQ NUMBER
Y Sequence number of the column this exception is defined on
EXCEPTION_ID NUMBER (15) Y Exception defining column
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15) Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER (15) Y Standard Who column
FLAG VARCHAR2 (1)
Flag to use on the report to mark records meeting the exception
DESCRIPTION VARCHAR2 (30)
Description of the exception that uses this flag
CONTEXT VARCHAR2 (30)
Descriptive Flexfield context
ATTRIBUTE1 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE11 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive Flexfield segment

[top of page]

RG.RG_REPORT_EXCEPTION_FLAGS does not reference any database object

RG.RG_REPORT_EXCEPTION_FLAGS is referenced by following:

RG
VIEW - RG_REPORT_EXCEPTION_FLAGS#

[top of page]

Table: RG_REPORT_PARAMETERS

Description: Assignments of budgets, encumbrances, and currencies to reports
Primary Key: RG_REPORT_PARAMETERS_PK
  1. PARAMETER_SET_ID
  2. DATA_TYPE
  3. PARAMETER_NUM
Foreign Keys from this table:
Foreign Key Column Foreign Table
RG_REPORT_PARAMETERS.PARAMETER_ID GL_BUDGET_VERSIONS
RG_REPORT_PARAMETERS.PARAMETER_ID GL_ENCUMBRANCE_TYPES
RG_REPORT_PARAMETERS.UNIT_OF_MEASURE_ID_11I FND_CURRENCIES
RG_REPORT_PARAMETERS.ENTERED_CURRENCY FND_CURRENCIES
RG_REPORT_PARAMETERS.LEDGER_CURRENCY FND_CURRENCIES
Comments

RG_REPORT_PARAMETERS stores information about the budgets, encumbrances, and currencies associated with reports for Financial Statement Generator. Each row includes a parameter set identifier, a parameter identifier, a parameter number, and a data type to identify whether Financial Statement Generator is using budget, encumbrance, or currency information.

Indexes
Index Type Tablespace Column
RG_REPORT_PARAMETERS_U1 UNIQUE APPS_TS_TX_IDX PARAMETER_SET_ID
DATA_TYPE
PARAMETER_NUM
Columns
Name Datatype Length Mandatory Comments
PARAMETER_SET_ID NUMBER (15) Y Parameter set defining column
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15) Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER (15) Y Standard Who column
PARAMETER_NUM NUMBER (15) Y Control value when defining rows or columns
DATA_TYPE VARCHAR2 (1) Y Indicates budget, encumbrance and currency data
PARAMETER_ID NUMBER (15)
Indicates budget or encumbrance id
UNIT_OF_MEASURE_ID_11I VARCHAR2 (30)
No Longer Used in R12
CURRENCY_TYPE_11I VARCHAR2 (1)
Obsolete
CONTEXT VARCHAR2 (30)
Descriptive Flexfield context
ATTRIBUTE1 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE11 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive Flexfield segment
ENTERED_CURRENCY VARCHAR2 (30)
Entered currency
LEDGER_CURRENCY VARCHAR2 (30)
Ledger functional currency
CURRENCY_TYPE VARCHAR2 (1)
Currency
PERIOD_NUM NUMBER (15)
Period number
FISCAL_YEAR_OFFSET NUMBER (15)
Fiscal year offset

[top of page]

RG.RG_REPORT_PARAMETERS does not reference any database object

RG.RG_REPORT_PARAMETERS is referenced by following:

RG
VIEW - RG_REPORT_PARAMETERS#

[top of page]

Table: RG_REPORT_REQUESTS

Description: Report request tracking and assignments of reports to report sets
Primary Key: RG_REPORT_REQUESTS_PK
  1. REPORT_REQUEST_ID
Primary Key: RG_REPORT_REQUESTS_UK1
  1. REPORT_SET_ID
  2. REPORT_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
RG_REPORT_REQUESTS.REPORT_ID RG_REPORTS
RG_REPORT_REQUESTS.REPORT_SET_ID RG_REPORT_SETS
RG_REPORT_REQUESTS.APPLICATION_ID
RG_REPORT_REQUESTS.ID_FLEX_CODE_11I
RG_REPORT_REQUESTS.STRUCTURE_ID
FND_ID_FLEX_STRUCTURES
RG_REPORT_REQUESTS.UNIT_OF_MEASURE_ID_11I FND_CURRENCIES
RG_REPORT_REQUESTS.CONCURRENT_REQUEST_ID FND_CONCURRENT_REQUESTS
RG_REPORT_REQUESTS.LEDGER_ID GL_LEDGERS
RG_REPORT_REQUESTS.CONTENT_SET_ID RG_REPORT_CONTENT_SETS
RG_REPORT_REQUESTS.ROW_ORDER_ID RG_ROW_ORDERS
RG_REPORT_REQUESTS.REPORT_DISPLAY_SET_ID RG_REPORT_DISPLAY_SETS
Comments

RG_REPORT_REQUESTS stores information about the reports in a report set in Financial Statement Generator. It also tracks information about the report submissions.
Each row includes a report identifier, a row set identifier, a column set identifier, and a sequence number for a report in a report set. Financial Statement Generator uses this information to join all of the report components together for creating financial statements.
The report request may belong to, and be submitted for, analysis as part of a report set, or the report request may be submitted as an independent request.

Indexes
Index Type Tablespace Column
RG_REPORT_REQUESTS_U1 UNIQUE APPS_TS_TX_IDX REPORT_REQUEST_ID
RG_REPORT_REQUESTS_N1 NONUNIQUE APPS_TS_TX_IDX CONCURRENT_REQUEST_ID
RG_REPORT_REQUESTS_N2 NONUNIQUE APPS_TS_TX_IDX REPORT_ID
RG_REPORT_REQUESTS_N3 NONUNIQUE APPS_TS_TX_IDX REPORT_SET_ID
SEQUENCE
Columns
Name Datatype Length Mandatory Comments
APPLICATION_ID NUMBER (15) Y Application defining column
REPORT_REQUEST_ID NUMBER (15) Y Primary key for table
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15) Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER (15) Y Standard Who column
ACCOUNTING_DATE DATE

Accounting date for which report is to be run
REPORT_ID NUMBER (15) Y Report defining column
SEQUENCE NUMBER

Report sequence in the report set
FORM_SUBMISSION_FLAG VARCHAR2 (1)
Flag used to indicate whether the request has been submitted by the form
CONCURRENT_REQUEST_ID NUMBER (15)
System generated id used to monitor job using concurrent manager
REPORT_SET_ID NUMBER (15)
Report set defining column
CONTENT_SET_ID NUMBER (15)
Content set defining column
ROW_ORDER_ID NUMBER (15)
Row order defining column
EXCEPTIONS_FLAG VARCHAR2 (1)
Display only exception rows flag
ROUNDING_OPTION VARCHAR2 (1)
Rounding method
LEDGER_ID NUMBER (15)
Ledger defining column
REPORT_DISPLAY_SET_ID NUMBER (15)
Report display set defining column
ID_FLEX_CODE_11I VARCHAR2 (4)
Obsolete
STRUCTURE_ID NUMBER (15)
Key Flexfield structure defining column
SEGMENT_OVERRIDE_11I VARCHAR2 (2000)
Obsolete
PERIOD_NAME VARCHAR2 (15)
Period for which report is to be run
UNIT_OF_MEASURE_ID_11I VARCHAR2 (30)
Obsolete
CONTEXT VARCHAR2 (30)
Descriptive Flexfield context
ATTRIBUTE1 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE11 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive Flexfield segment
RUNTIME_OPTION_CONTEXT VARCHAR2 (30)
RG_RUNTIME_OPTION descriptive flexfield structure defining column
OUTPUT_OPTION VARCHAR2 (1)
Output option
ID_FLEX_CODE VARCHAR2 (4)
GLLE
SEGMENT_OVERRIDE VARCHAR2 (2000)
Segment override value
UNIT_OF_MEASURE_ID VARCHAR2 (30)
Currency
ALC_LEDGER_CURRENCY VARCHAR2 (30)
Reporting ledger currency
OVERRIDE_ALC_LEDGER_CURRENCY VARCHAR2 (30)
Override reporting ledger currency

[top of page]

RG.RG_REPORT_REQUESTS does not reference any database object

RG.RG_REPORT_REQUESTS is referenced by following:

RG
VIEW - RG_REPORT_REQUESTS#

[top of page]

Table: RG_REPORT_REQUEST_LOBS

Description: RG_REPORT_REQUEST_LOBS stores the XML output associated with each Financial Statement Generator request that is run in XML mode. The XML output is used for drilldown purposes
Primary Key: RG_REPORT_REQUEST_LOBS_PK
  1. REQUEST_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
RG_REPORT_REQUEST_LOBS.REQUEST_ID FND_CONCURRENT_REQUESTS
Comments

RG_REPORT_REQUEST_LOBS stores the XML output associated with each Financial Statement Generator request that is run in XML mode. The XML output is used for drilldown purposes

Indexes
Index Type Tablespace Column
RG_REPORT_REQUEST_LOBS_U1 UNIQUE APPS_TS_TX_IDX REQUEST_ID
SYS_IL0000457992C00002$$ UNIQUE APPS_TS_TX_DATA
SYS_IL0000457992C00008$$ UNIQUE APPS_TS_TX_DATA
Columns
Name Datatype Length Mandatory Comments
REQUEST_ID NUMBER (15) Y Concurrent reuest defining column
REPORT_DATA CLOB (4000)
XML output
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15) Y Standard Who column
CREATED_BY NUMBER (15) Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
REPORT_DATA_BLOB BLOB (4000)
XML output in binary format

[top of page]

RG.RG_REPORT_REQUEST_LOBS does not reference any database object

RG.RG_REPORT_REQUEST_LOBS is referenced by following:

RG
VIEW - RG_REPORT_REQUEST_LOBS#

[top of page]

Table: RG_REPORT_SETS

Description: Report set definitions
Primary Key: RG_REPORT_SETS_PK
  1. REPORT_SET_ID
Primary Key: RG_REPORT_SETS_UK1
  1. NAME
  2. APPLICATION_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
RG_REPORT_SETS.APPLICATION_ID
RG_REPORT_SETS.ID_FLEX_CODE_11I
RG_REPORT_SETS.STRUCTURE_ID
FND_ID_FLEX_STRUCTURES
RG_REPORT_SETS.UNIT_OF_MEASURE_ID FND_CURRENCIES
Foreign Keys to this table:
Foreign Key Column Foreign Table
RG_REPORT_REQUESTS.REPORT_SET_ID RG_REPORT_SETS
Comments

RG_REPORT_SETS stores information about all of the report sets defined in Financial Statement Generator.
Each row includes a report set identifier, an application identifier and the name of the report set.

Indexes
Index Type Tablespace Column
RG_REPORT_SETS_U1 UNIQUE APPS_TS_TX_IDX REPORT_SET_ID
RG_REPORT_SETS_U2 UNIQUE APPS_TS_TX_IDX NAME
APPLICATION_ID
Columns
Name Datatype Length Mandatory Comments
APPLICATION_ID NUMBER (15) Y Application defining column
REPORT_SET_ID NUMBER (15) Y Report set defining column
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15) Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER (15) Y Standard Who column
NAME VARCHAR2 (30) Y Name of report set
ID_FLEX_CODE_11I VARCHAR2 (4)
Obsolete
PERIOD_TYPE VARCHAR2 (15)
No longer used
PERIOD_NAME VARCHAR2 (15)
No longer used
STRUCTURE_ID NUMBER (15)
Key Flexfield structure defining column
DESCRIPTION VARCHAR2 (240)
Description of the report set
CONTEXT VARCHAR2 (30)
Descriptive Flexfield context
ATTRIBUTE1 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE11 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive Flexfield segment
UNIT_OF_MEASURE_ID VARCHAR2 (30)
Default currency of the report set
SECURITY_FLAG VARCHAR2 (1) Y Security flag
ID_FLEX_CODE VARCHAR2 (4)
GLLE

[top of page]

RG.RG_REPORT_SETS does not reference any database object

RG.RG_REPORT_SETS is referenced by following:

RG
VIEW - RG_REPORT_SETS#

[top of page]

Table: RG_REPORT_SET_REQUESTS

Description: RG_REPORT_SET_REQUESTS tracks submission of report sets. It stores the report set that was submitted, the it was submitted, and who it was submitted by. If the report set was submitted using the Multiple Report Sets tab in the Run Financi
Primary Key: RG_REPORT_SET_REQUESTS_PK
  1. REPORT_SET_REQUEST_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
RG_REPORT_SET_REQUESTS.UNIT_OF_MEASURE_ID FND_CURRENCIES
Foreign Keys to this table:
Foreign Key Column Foreign Table
RG_REPORT_SET_REQ_DETAILS.REPORT_SET_REQUEST_ID RG_REPORT_SET_REQUESTS
Comments

Report set submission tracking

Indexes
Index Type Tablespace Column
RG_REPORT_SET_REQUESTS_U1 UNIQUE APPS_TS_TX_IDX REPORT_SET_REQUEST_ID
RG_REPORT_SET_REQUESTS_N1 NONUNIQUE APPS_TS_TX_IDX LAST_UPDATED_BY
Columns
Name Datatype Length Mandatory Comments
REPORT_SET_REQUEST_ID NUMBER (15) Y Report set request defining column
REPORT_SET_ID NUMBER (15) Y Report set defining column
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15) Y Standard Who column
CREATED_BY NUMBER (15) Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
PERIOD_NAME VARCHAR2 (15)
Period name
ACCOUNTING_DATE DATE

Accounting date
UNIT_OF_MEASURE_ID VARCHAR2 (30)
Currency

[top of page]

RG.RG_REPORT_SET_REQUESTS does not reference any database object

RG.RG_REPORT_SET_REQUESTS is referenced by following:

RG
VIEW - RG_REPORT_SET_REQUESTS#

[top of page]

Table: RG_REPORT_SET_REQ_DETAILS

Description: RG_REPORT_SET_REQ_DETAILS tracks the individual reports that were run for each report set submission. There will be one row in this table for each report run as part of a report set submission.
Primary Key: RG_REPORT_SET_REQ_DETAILS_PK
  1. REPORT_SET_REQUEST_ID
  2. SEQUENCE
Foreign Keys from this table:
Foreign Key Column Foreign Table
RG_REPORT_SET_REQ_DETAILS.REPORT_SET_REQUEST_ID RG_REPORT_SET_REQUESTS
RG_REPORT_SET_REQ_DETAILS.REPORT_ID RG_REPORTS
RG_REPORT_SET_REQ_DETAILS.CONCURRENT_REQUEST_ID FND_CONCURRENT_REQUESTS
Comments

Report set details submission tracking

Indexes
Index Type Tablespace Column
RG_REPORT_SET_REQ_DETAILS_U1 UNIQUE APPS_TS_TX_IDX REPORT_SET_REQUEST_ID
SEQUENCE
Columns
Name Datatype Length Mandatory Comments
REPORT_SET_REQUEST_ID NUMBER (15) Y Report set request defining column
SEQUENCE NUMBER
Y Report sequence in the report set
REPORT_ID NUMBER (15) Y Report defining column
CONCURRENT_REQUEST_ID NUMBER (15) Y Report concurrent request id
REPORT_SEQUENCE NUMBER (15) Y

[top of page]

RG.RG_REPORT_SET_REQ_DETAILS does not reference any database object

RG.RG_REPORT_SET_REQ_DETAILS is referenced by following:

RG
VIEW - RG_REPORT_SET_REQ_DETAILS#

[top of page]

Table: RG_REPORT_STANDARD_AXES_B

Description: Amount types used in rows and columns
Primary Key: RG_REPORT_STANDARD_AXES_B_PK
  1. STANDARD_AXIS_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
RG_REPORT_STANDARD_AXES_B.STANDARD_AXIS1_ID RG_REPORT_STANDARD_AXES_B
RG_REPORT_STANDARD_AXES_B.STANDARD_AXIS2_ID RG_REPORT_STANDARD_AXES_B
Foreign Keys to this table:
Foreign Key Column Foreign Table
RG_REPORT_STANDARD_AXES_B.STANDARD_AXIS1_ID RG_REPORT_STANDARD_AXES_B
RG_REPORT_STANDARD_AXES_B.STANDARD_AXIS2_ID RG_REPORT_STANDARD_AXES_B
RG_REPORT_STANDARD_AXES_TL.STANDARD_AXIS_ID RG_REPORT_STANDARD_AXES_B
Comments

RG_REPORT_STANDARD_AXES_B stores information about all of the amount types used for reporting by Financial Statement Generator. This information is represented by period-to-date, quarter-to-date, and year-to-date budget, encumbrance, and actual amounts.
Each row includes a standard axis identifier, a class, and the axis identifiers of those amount types used to create this one. Financial Statement Generator uses this information to define the contents of rows and columns in terms of whether the amounts are period-to-date, quarter-to-date, or year-to-date budget, encumbrance, or actual amounts.
The translated amount type name and descriptions for these amount types are stored in RG_REPORT_STANDARD_AXES_TL.

Indexes
Index Type Tablespace Column
RG_REPORT_STANDARD_AXES_B_U1 UNIQUE APPS_TS_SEED STANDARD_AXIS_ID
ZD_EDITION_NAME
SYS_IL0000331698C00013$$ UNIQUE APPS_TS_SEED
Columns
Name Datatype Length Mandatory Comments
APPLICATION_ID NUMBER (15) Y Application defining column
STANDARD_AXIS_ID NUMBER (15) Y Standard axis defining column
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15) Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER (15) Y Standard Who column
CLASS VARCHAR2 (1) Y Class of standard axis, calculated or primitive
DISPLAY_IN_STANDARD_LIST_FLAG VARCHAR2 (1) Y Indicated whether to display in quick pick or not
PRECEDENCE_LEVEL NUMBER (2) Y 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
VARIANCE_FLAG VARCHAR2 (1)
Determine whether amount type is variance
SIGN_FLAG VARCHAR2 (1)
No longer used
ZD_EDITION_NAME VARCHAR2 (30) Y

[top of page]

RG.RG_REPORT_STANDARD_AXES_B does not reference any database object

RG.RG_REPORT_STANDARD_AXES_B is referenced by following:

RG
VIEW - RG_REPORT_STANDARD_AXES_B#

[top of page]

Table: RG_REPORT_STANDARD_AXES_TL

Description: Translations for RG_REPORT_STANDARD_AXES
Primary Key: RG_REPORT_STANDARD_AXES_TL_PK
  1. STANDARD_AXIS_ID
  2. LANGUAGE
Foreign Keys from this table:
Foreign Key Column Foreign Table
RG_REPORT_STANDARD_AXES_TL.STANDARD_AXIS_ID RG_REPORT_STANDARD_AXES_B
Comments

RG_REPORT_STANDARD_AXES_TL stores translated information about the amount types used for reporting by Financial Statement Generator. Each row includes the amount type name, the amount type description, and the language code to indicate what language the information is in. You need one row for each amount type in each of the installed languages.

Indexes
Index Type Tablespace Column
RG_REPORT_STANDARD_AXES_TL_U1 UNIQUE APPS_TS_SEED STANDARD_AXIS_ID
LANGUAGE
ZD_EDITION_NAME
RG_REPORT_STANDARD_AXES_TL_U2 UNIQUE APPS_TS_SEED STANDARD_AXIS_NAME
LANGUAGE
ZD_EDITION_NAME
Columns
Name Datatype Length Mandatory Comments
STANDARD_AXIS_ID NUMBER (15) Y Standard axis defining column
LANGUAGE VARCHAR2 (4) Y Language
SOURCE_LANG VARCHAR2 (4) Y The language the text will mirror. If text is not yet translated into LANGUAGE, than any changes to the text in the source language row will be reflected here as well.
STANDARD_AXIS_NAME VARCHAR2 (30) Y Name of standard axis
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER (15) Y Standard Who column
DESCRIPTION VARCHAR2 (240)
Description of standard axis
ZD_EDITION_NAME VARCHAR2 (30) Y

[top of page]

RG.RG_REPORT_STANDARD_AXES_TL does not reference any database object

RG.RG_REPORT_STANDARD_AXES_TL is referenced by following:

RG
VIEW - RG_REPORT_STANDARD_AXES_TL#

[top of page]

Table: RG_REPORT_SUB_REQUEST_RUNS

Description: Sub request information for parallel content sets
Foreign Keys from this table:
Foreign Key Column Foreign Table
RG_REPORT_SUB_REQUEST_RUNS.REQUEST_ID FND_CONCURRENT_REQUESTS
Comments

RG_REPORT_SUB_REQUEST_RUNS stores the override segment number and value to be used by the Financial Statement Generator program, along with a system-generated sub-request run identifier, the concurrent request identifier, and the override sequence number for the content. . The FSG Controller program inserts the values in the table.

Indexes
Index Type Tablespace Column
RG_REPORT_SUB_REQUEST_RUNS_N1 NONUNIQUE APPS_TS_TX_IDX SUB_REQUEST_RUN_ID
Columns
Name Datatype Length Mandatory Comments
SUB_REQUEST_RUN_ID NUMBER (15) Y Sub request report defining column
CREATED_BY NUMBER (15) Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
PROGRAM_APPLICATION_ID NUMBER (15)
Enhanced Who column
PROGRAM_ID NUMBER (15)
Enhanced Who column
PROGRAM_UPDATE_DATE DATE

Enhanced Who column
REQUEST_ID NUMBER (15)
Enhanced Who column
OVERRIDE_SEG_NUMBER NUMBER (4)
Override segment number
OVERRIDE_SEG_NAME VARCHAR2 (30)
Override segment name
OVERRIDE_SEG_VALUE VARCHAR2 (60)
Override segment value
OVERRIDE_CONTENT_SEQ NUMBER (15)
Sequence of the override content set
PARENT_REQUEST_ID NUMBER (15)
Concurrent request defining column of the parent request
PRINT_WIDTH NUMBER (4)
Report width for printing

[top of page]

RG.RG_REPORT_SUB_REQUEST_RUNS does not reference any database object

RG.RG_REPORT_SUB_REQUEST_RUNS is referenced by following:

RG
VIEW - RG_REPORT_SUB_REQUEST_RUNS#

[top of page]

Table: RG_ROW_ORDERS

Description: Row order definitions
Primary Key: RG_ROW_ORDERS_PK
  1. ROW_ORDER_ID
Primary Key: RG_ROW_ORDERS_UK1
  1. NAME
  2. APPLICATION_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
RG_ROW_ORDERS.APPLICATION_ID
RG_ROW_ORDERS.ID_FLEX_CODE_11I
RG_ROW_ORDERS.STRUCTURE_ID
FND_ID_FLEX_STRUCTURES
Foreign Keys to this table:
Foreign Key Column Foreign Table
RG_REPORTS.ROW_ORDER_ID RG_ROW_ORDERS
RG_REPORT_REQUESTS.ROW_ORDER_ID RG_ROW_ORDERS
RG_ROW_SEGMENT_SEQUENCES.ROW_ORDER_ID RG_ROW_ORDERS
Comments

RG_ROW_ORDERS stores information about how to expand rows in a report. Each row includes a row order identifier, a row rank type (ascending or descending), the name and sequence number of the column used to rank the report and the row order name used to identify that particular row order.
Financial Statement Generator uses this information to order the values in an expanded row, by linking that row order to a particular row and/or row ranking sequence.

Indexes
Index Type Tablespace Column
RG_ROW_ORDERS_U1 UNIQUE APPS_TS_TX_IDX ROW_ORDER_ID
RG_ROW_ORDERS_U2 UNIQUE APPS_TS_TX_IDX NAME
APPLICATION_ID
Columns
Name Datatype Length Mandatory Comments
APPLICATION_ID NUMBER (15) Y Application defining column
ROW_ORDER_ID NUMBER (15) Y Row order defining column
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15) Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER (15) Y Standard Who column
NAME VARCHAR2 (30) Y Name of this row order
ROW_RANK_TYPE VARCHAR2 (1)
Indicates whether report information is ranked in ascending or descending order
ID_FLEX_CODE_11I VARCHAR2 (4)
Obsolete
STRUCTURE_ID NUMBER (15)
Key Flexfield structure defining column
DESCRIPTION VARCHAR2 (240)
Description of the row order
COLUMN_NUMBER NUMBER (15)
The sequence number of the column used to rank your report
COLUMN_NAME VARCHAR2 (30)
The name of the column used to rank the report. Denormalized from RG_REPORT_AXES
CONTEXT VARCHAR2 (30)
Descriptive Flexfield context
ATTRIBUTE1 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE11 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive Flexfield segment
SECURITY_FLAG VARCHAR2 (1) Y Reserved for future use
ID_FLEX_CODE VARCHAR2 (4)
Reserved for future use

[top of page]

RG.RG_ROW_ORDERS does not reference any database object

RG.RG_ROW_ORDERS is referenced by following:

RG
VIEW - RG_ROW_ORDERS#

[top of page]

Table: RG_ROW_SEGMENT_SEQUENCES

Description: Assignments of segments to row orders
Primary Key: RG_ROW_SEGMENT_SEQUENCES_PK
  1. ROW_SEGMENT_SEQUENCE_ID
Primary Key: RG_ROW_SEGMENT_SEQUENCES_UK1
  1. ROW_ORDER_ID
  2. SEGMENT_SEQUENCE
  3. STRUCTURE_ID
Primary Key: RG_ROW_SEGMENT_SEQUENCES_UK2
  1. ROW_ORDER_ID
  2. STRUCTURE_ID
  3. SEGMENT_NAME
Foreign Keys from this table:
Foreign Key Column Foreign Table
RG_ROW_SEGMENT_SEQUENCES.ROW_ORDER_ID RG_ROW_ORDERS
Comments

RG_ROW_SEGMENT_SEQUENCES stores different segment sequence information currently defined in Financial Statement Generator. Financial Statement Generator uses this information to arrange segments and to link the segment arrangement in a particular row order.

Indexes
Index Type Tablespace Column
RG_ROW_SEGMENT_SEQUENCES_U1 UNIQUE APPS_TS_TX_IDX ROW_SEGMENT_SEQUENCE_ID
RG_ROW_SEGMENT_SEQUENCES_U2 UNIQUE APPS_TS_TX_IDX ROW_ORDER_ID
STRUCTURE_ID
SEGMENT_SEQUENCE
RG_ROW_SEGMENT_SEQUENCES_U3 UNIQUE APPS_TS_TX_IDX ROW_ORDER_ID
STRUCTURE_ID
APPLICATION_COLUMN_NAME
Columns
Name Datatype Length Mandatory Comments
APPLICATION_ID NUMBER (15) Y Application defining column
ROW_ORDER_ID NUMBER (15) Y Row order defining column
ROW_SEGMENT_SEQUENCE_ID NUMBER (15) Y Primary key for table
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15) Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER (15) Y Standard Who column
SEGMENT_SEQUENCE NUMBER (15) Y The sequence that the flexfield segment appears on the report
SEG_ORDER_TYPE VARCHAR2 (1) Y Indicates whether the segments are ordered alphabetically or by the column ranking
SEG_DISPLAY_TYPE VARCHAR2 (1) Y Indicates whether the flexfield segment value and/or description is displayed
STRUCTURE_ID NUMBER (15) Y Key Flexfield structure defining column
SEGMENT_NAME VARCHAR2 (30)
The name of the segment used for sequencing. Denormalized from FND_ID_FLEX_SEGMENTS
SEGMENT_WIDTH NUMBER (15)
The number of characters that display on the report for a flexfield segment
CONTEXT VARCHAR2 (30)
Descriptive Flexfield context
ATTRIBUTE1 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE11 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive Flexfield segment
APPLICATION_COLUMN_NAME VARCHAR2 (30)
Key Flexfield segment column

[top of page]

RG.RG_ROW_SEGMENT_SEQUENCES does not reference any database object

RG.RG_ROW_SEGMENT_SEQUENCES is referenced by following:

RG
VIEW - RG_ROW_SEGMENT_SEQUENCES#

[top of page]

Table: RG_SIMPLE_WHERE_CLAUSES

Description: Query information for specific amount types
Comments

RG_SIMPLE_WHERE_CLAUSES stores information about the values for columns in GL_BALANCES and GL_CODE_COMBINATIONS.
Each row includes a name, a column name, and a value. Each row contains information for one value for one column in GL_CODE_COMBINATIONS and GL_BALANCES.
Financial Statement Generator uses this information to determine whether the data returned from GL_BALANCES are budget, encumbrance, or actual values.

Columns
Name Datatype Length Mandatory Comments
SIMPLE_WHERE_NAME VARCHAR2 (30) Y Name of where clause used to load seeded amount types
WHERE_COLUMN VARCHAR2 (30) Y Name of column this where clause is defined on
WHERE_VALUE VARCHAR2 (240) Y Value of the where column that the where clause is created with

[top of page]

RG.RG_SIMPLE_WHERE_CLAUSES does not reference any database object

RG.RG_SIMPLE_WHERE_CLAUSES is referenced by following:

RG
VIEW - RG_SIMPLE_WHERE_CLAUSES#

[top of page]

Table: RG_TABLE_SIZES

Description: Sizes of selected Oracle General Ledger tables
Primary Key: RG_TABLE_SIZES_PK
  1. TABLE_ID
Comments

RG_TABLE_SIZES stores the number of rows in various Oracle General Ledger tables. Each row includes a table identifier and the number of rows in the table. Financial Statement Generator uses this information to optimize queries.

Indexes
Index Type Tablespace Column
RG_TABLE_SIZES_U1 UNIQUE APPS_TS_TX_IDX TABLE_ID
Columns
Name Datatype Length Mandatory Comments
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15) Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER (15) Y Standard Who column
TABLE_ID NUMBER (2) Y Table defining column
NUMBER_ROWS NUMBER (15) Y Number of records in this table

[top of page]

RG.RG_TABLE_SIZES does not reference any database object

RG.RG_TABLE_SIZES is referenced by following:

RG
VIEW - RG_TABLE_SIZES#

[top of page]

Table: RG_XBRL_ELEMENTS

Description:
Primary Key: RG_XBRL_ELEMENTS_PK
  1. ELEMENT_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
RG_XBRL_ELEMENTS.TAXONOMY_ID RG_XBRL_TAXONOMIES
Foreign Keys to this table:
Foreign Key Column Foreign Table
RG_REPORT_AXES.ELEMENT_ID RG_XBRL_ELEMENTS
RG_XBRL_MAP_ELEMENTS.ELEMENT_ID RG_XBRL_ELEMENTS
Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

Indexes
Index Type Tablespace Column
RG_XBRL_ELEMENTS_U1 UNIQUE APPS_TS_TX_IDX ELEMENT_ID
RG_XBRL_ELEMENTS_U2 UNIQUE APPS_TS_TX_IDX TAXONOMY_ID
ELEMENT_IDENTIFIER
Columns
Name Datatype Length Mandatory Comments
ELEMENT_ID NUMBER (15) Y Element defining column - Primary Key
TAXONOMY_ID NUMBER (15) Y Taxonomy defining column
ELEMENT_IDENTIFIER VARCHAR2 (240) Y Taxonomy element identifier
ELEMENT_NAME VARCHAR2 (240) Y Taxonomy element name
ELEMENT_TYPE VARCHAR2 (240)
Taxonomy element type
ELEMENT_GROUP VARCHAR2 (240)
Taxonomy element group
ELEMENT_DESCR VARCHAR2 (3000)
Taxonomy element description
ELEMENT_LABEL VARCHAR2 (240)
Taxonomy element label
PARENT_ID NUMBER (15)
Element parent defining column
PARENT_IDENTIFIER VARCHAR2 (240)
Taxonomy element parent identifier
HAS_CHILD_FLAG VARCHAR2 (1) Y Indicates whether element has a child
HAS_PARENT_FLAG VARCHAR2 (1) Y Indicates whether element has a parent
HIERARCHY_LEVEL NUMBER (15) Y Element hierarchy level
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column

[top of page]

RG.RG_XBRL_ELEMENTS does not reference any database object

RG.RG_XBRL_ELEMENTS is referenced by following:

RG
VIEW - RG_XBRL_ELEMENTS#

[top of page]

Table: RG_XBRL_MAP_ELEMENTS

Description: Elements mapped to taxonomy
Primary Key: RG_XBRL_MAP_ELEMENTS_PK
  1. TAXONOMY_ID
  2. ELEMENT_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
RG_XBRL_MAP_ELEMENTS.TAXONOMY_ID RG_XBRL_TAXONOMIES
RG_XBRL_MAP_ELEMENTS.ELEMENT_ID RG_XBRL_ELEMENTS
Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

Indexes
Index Type Tablespace Column
RG_XBRL_MAP_ELEMENTS_U1 UNIQUE APPS_TS_TX_IDX TAXONOMY_ID
ELEMENT_ID
Columns
Name Datatype Length Mandatory Comments
TAXONOMY_ID NUMBER (15) Y Taxonomy defining column
ELEMENT_ID NUMBER (15) Y Element defining column
ENABLED_FLAG VARCHAR2 (1) Y Indicated whether element is enabled
CREATION_DATE DATE
Y Standard Who Column
CREATED_BY NUMBER (15) Y Standard Who Column
LAST_UPDATE_DATE DATE
Y Standard Who Column
LAST_UPDATED_BY NUMBER (15) Y Standard Who Column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who Column

[top of page]

RG.RG_XBRL_MAP_ELEMENTS does not reference any database object

RG.RG_XBRL_MAP_ELEMENTS is referenced by following:

RG
VIEW - RG_XBRL_MAP_ELEMENTS#

[top of page]

Table: RG_XBRL_TAXONOMIES

Description:
Primary Key: RG_XBRL_TAXONOMIES_PK
  1. TAXONOMY_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
RG_REPORT_AXIS_SETS.TAXONOMY_ID RG_XBRL_TAXONOMIES
RG_XBRL_ELEMENTS.TAXONOMY_ID RG_XBRL_TAXONOMIES
RG_XBRL_MAP_ELEMENTS.TAXONOMY_ID RG_XBRL_TAXONOMIES
Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

Indexes
Index Type Tablespace Column
RG_XBRL_TAXONOMIES_U1 UNIQUE APPS_TS_TX_IDX TAXONOMY_ID
RG_XBRL_TAXONOMIES_U2 UNIQUE APPS_TS_TX_IDX TAXONOMY_ALIAS
Columns
Name Datatype Length Mandatory Comments
TAXONOMY_ID NUMBER (15) Y Taxonomy defining column - Primary Key
TAXONOMY_ALIAS VARCHAR2 (240) Y Taxonomy alias including version
TAXONOMY_NAME VARCHAR2 (240) Y Taxonomy name
TAXONOMY_DESCR VARCHAR2 (240) Y Taxonomy description
TAXONOMY_URL VARCHAR2 (240) Y Taxonomy Universal Resource Locator
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
TAXONOMY_IMPORT_FLAG VARCHAR2 (1) Y Indicated whether taxonomy imports other taxonomies.

[top of page]

RG.RG_XBRL_TAXONOMIES does not reference any database object

RG.RG_XBRL_TAXONOMIES is referenced by following:

RG
VIEW - RG_XBRL_TAXONOMIES#

[top of page]

View: RG_BUDGETS_V

Comments
View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)

PARAMETER_SET_ID NUMBER (15) Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
LAST_UPDATE_LOGIN NUMBER (15) Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER (15) Y
PARAMETER_NUM NUMBER (15) Y
PARAMETER_ID NUMBER (15)

BUDGET_NAME VARCHAR2 (15) Y
DESCRIPTION VARCHAR2 (240)

DATA_TYPE VARCHAR2 (1) Y
CONTEXT VARCHAR2 (30)

ATTRIBUTE1 VARCHAR2 (150)

ATTRIBUTE2 VARCHAR2 (150)

ATTRIBUTE3 VARCHAR2 (150)

ATTRIBUTE4 VARCHAR2 (150)

ATTRIBUTE5 VARCHAR2 (150)

ATTRIBUTE6 VARCHAR2 (150)

ATTRIBUTE7 VARCHAR2 (150)

ATTRIBUTE8 VARCHAR2 (150)

ATTRIBUTE9 VARCHAR2 (150)

ATTRIBUTE10 VARCHAR2 (150)

ATTRIBUTE11 VARCHAR2 (150)

ATTRIBUTE12 VARCHAR2 (150)

ATTRIBUTE13 VARCHAR2 (150)

ATTRIBUTE14 VARCHAR2 (150)

ATTRIBUTE15 VARCHAR2 (150)

[top of page]

APPS.RG_BUDGETS_V references the following:

APPS
SYNONYM - GL_BUDGETS
SYNONYM - GL_BUDGET_VERSIONS
SYNONYM - RG_REPORT_PARAMETERS

APPS.RG_BUDGETS_V is not referenced by any database object

[top of page]

View: RG_CONSTANT_PERIODS_V

Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
PARAMETER_SET_ID NUMBER (15) Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
LAST_UPDATE_LOGIN NUMBER (15) Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER (15) Y
PARAMETER_NUM NUMBER (15) Y
PERIOD_NUM NUMBER (15)
FISCAL_YEAR_OFFSET NUMBER (15)
DATA_TYPE VARCHAR2 (1) Y
CONTEXT VARCHAR2 (30)
ATTRIBUTE1 VARCHAR2 (150)
ATTRIBUTE2 VARCHAR2 (150)
ATTRIBUTE3 VARCHAR2 (150)
ATTRIBUTE4 VARCHAR2 (150)
ATTRIBUTE5 VARCHAR2 (150)
ATTRIBUTE6 VARCHAR2 (150)
ATTRIBUTE7 VARCHAR2 (150)
ATTRIBUTE8 VARCHAR2 (150)
ATTRIBUTE9 VARCHAR2 (150)
ATTRIBUTE10 VARCHAR2 (150)
ATTRIBUTE11 VARCHAR2 (150)
ATTRIBUTE12 VARCHAR2 (150)
ATTRIBUTE13 VARCHAR2 (150)
ATTRIBUTE14 VARCHAR2 (150)
ATTRIBUTE15 VARCHAR2 (150)

[top of page]

APPS.RG_CONSTANT_PERIODS_V references the following:

APPS
SYNONYM - RG_REPORT_PARAMETERS

APPS.RG_CONSTANT_PERIODS_V is not referenced by any database object

[top of page]

View: RG_CURRENCIES_V

Comments
View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
PARAMETER_SET_ID NUMBER (15) Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
LAST_UPDATE_LOGIN NUMBER (15) Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER (15) Y
PARAMETER_NUM NUMBER (15) Y
CURRENCY_TYPE VARCHAR2 (1)
ENTERED_CURRENCY VARCHAR2 (30)
LEDGER_CURRENCY VARCHAR2 (30)
DATA_TYPE VARCHAR2 (1) Y
CONTEXT VARCHAR2 (30)
ATTRIBUTE1 VARCHAR2 (150)
ATTRIBUTE2 VARCHAR2 (150)
ATTRIBUTE3 VARCHAR2 (150)
ATTRIBUTE4 VARCHAR2 (150)
ATTRIBUTE5 VARCHAR2 (150)
ATTRIBUTE6 VARCHAR2 (150)
ATTRIBUTE7 VARCHAR2 (150)
ATTRIBUTE8 VARCHAR2 (150)
ATTRIBUTE9 VARCHAR2 (150)
ATTRIBUTE10 VARCHAR2 (150)
ATTRIBUTE11 VARCHAR2 (150)
ATTRIBUTE12 VARCHAR2 (150)
ATTRIBUTE13 VARCHAR2 (150)
ATTRIBUTE14 VARCHAR2 (150)
ATTRIBUTE15 VARCHAR2 (150)

[top of page]

APPS.RG_CURRENCIES_V references the following:

APPS
SYNONYM - RG_REPORT_PARAMETERS

APPS.RG_CURRENCIES_V is not referenced by any database object

[top of page]

View: RG_DSS_DIM_SEGMENTS_V

Comments
View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)

DIMENSION_ID NUMBER (15) Y
SEQUENCE NUMBER (15) Y
SEGMENT_NAME VARCHAR2 (30) Y
APPLICATION_COLUMN_NAME VARCHAR2 (30) Y
ID_FLEX_CODE VARCHAR2 (4) Y
ID_FLEX_NUM NUMBER (15) Y
MAX_DESC_SIZE NUMBER (3) Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
LAST_UPDATE_LOGIN NUMBER (15) Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER (15) Y
RANGE_SET_NAME VARCHAR2 (60)

RANGE_SET_ID NUMBER (15)

ACCOUNT_TYPE VARCHAR2 (1)

CONTEXT VARCHAR2 (30)

ATTRIBUTE1 VARCHAR2 (150)

ATTRIBUTE2 VARCHAR2 (150)

ATTRIBUTE3 VARCHAR2 (150)

ATTRIBUTE4 VARCHAR2 (150)

ATTRIBUTE5 VARCHAR2 (150)

ATTRIBUTE6 VARCHAR2 (150)

ATTRIBUTE7 VARCHAR2 (150)

ATTRIBUTE8 VARCHAR2 (150)

ATTRIBUTE9 VARCHAR2 (150)

ATTRIBUTE10 VARCHAR2 (150)

ATTRIBUTE11 VARCHAR2 (150)

ATTRIBUTE12 VARCHAR2 (150)

ATTRIBUTE13 VARCHAR2 (150)

ATTRIBUTE14 VARCHAR2 (150)

ATTRIBUTE15 VARCHAR2 (150)

[top of page]

APPS.RG_DSS_DIM_SEGMENTS_V references the following:

APPS
SYNONYM - FND_ID_FLEX_SEGMENTS
SYNONYM - RG_DSS_DIM_SEGMENTS
SYNONYM - RG_DSS_SEG_RANGE_SETS

APPS.RG_DSS_DIM_SEGMENTS_V is not referenced by any database object

[top of page]

View: RG_DSS_HIERARCHIES_V

Comments
View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)

HIERARCHY_ID NUMBER (15) Y
NAME VARCHAR2 (60) Y
ID_FLEX_CODE VARCHAR2 (4) Y
ID_FLEX_NUM NUMBER (15) Y
DIMENSION_ID NUMBER (15) Y
DIMENSION_NAME VARCHAR2 (60) Y
DESCRIPTION VARCHAR2 (240)

LAST_UPDATE_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
LAST_UPDATE_LOGIN NUMBER (15) Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER (15) Y
CONTEXT VARCHAR2 (30)

ATTRIBUTE1 VARCHAR2 (150)

ATTRIBUTE2 VARCHAR2 (150)

ATTRIBUTE3 VARCHAR2 (150)

ATTRIBUTE4 VARCHAR2 (150)

ATTRIBUTE5 VARCHAR2 (150)

ATTRIBUTE6 VARCHAR2 (150)

ATTRIBUTE7 VARCHAR2 (150)

ATTRIBUTE8 VARCHAR2 (150)

ATTRIBUTE9 VARCHAR2 (150)

ATTRIBUTE10 VARCHAR2 (150)

ATTRIBUTE11 VARCHAR2 (150)

ATTRIBUTE12 VARCHAR2 (150)

ATTRIBUTE13 VARCHAR2 (150)

ATTRIBUTE14 VARCHAR2 (150)

ATTRIBUTE15 VARCHAR2 (150)

[top of page]

APPS.RG_DSS_HIERARCHIES_V references the following:

APPS
SYNONYM - RG_DSS_DIMENSIONS
SYNONYM - RG_DSS_HIERARCHIES

APPS.RG_DSS_HIERARCHIES_V is not referenced by any database object

[top of page]

View: RG_DSS_HIERARCHY_DETAILS_V

Comments
View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)

HIERARCHY_ID NUMBER (15) Y
SEQUENCE NUMBER (15) Y
APPLICATION_COLUMN_NAME VARCHAR2 (30) Y
ID_FLEX_CODE VARCHAR2 (4) Y
ID_FLEX_NUM NUMBER (15) Y
SEGMENT_NAME VARCHAR2 (30) Y
SEGMENT_NUM NUMBER (3) Y
ROOT_NODE VARCHAR2 (60) Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
LAST_UPDATE_LOGIN NUMBER (15) Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER (15) Y
CONTEXT VARCHAR2 (30)

ATTRIBUTE1 VARCHAR2 (150)

ATTRIBUTE2 VARCHAR2 (150)

ATTRIBUTE3 VARCHAR2 (150)

ATTRIBUTE4 VARCHAR2 (150)

ATTRIBUTE5 VARCHAR2 (150)

ATTRIBUTE6 VARCHAR2 (150)

ATTRIBUTE7 VARCHAR2 (150)

ATTRIBUTE8 VARCHAR2 (150)

ATTRIBUTE9 VARCHAR2 (150)

ATTRIBUTE10 VARCHAR2 (150)

ATTRIBUTE11 VARCHAR2 (150)

ATTRIBUTE12 VARCHAR2 (150)

ATTRIBUTE13 VARCHAR2 (150)

ATTRIBUTE14 VARCHAR2 (150)

ATTRIBUTE15 VARCHAR2 (150)

[top of page]

APPS.RG_DSS_HIERARCHY_DETAILS_V references the following:

APPS
SYNONYM - FND_ID_FLEX_SEGMENTS
SYNONYM - RG_DSS_HIERARCHIES
SYNONYM - RG_DSS_HIERARCHY_DETAILS

APPS.RG_DSS_HIERARCHY_DETAILS_V is not referenced by any database object

[top of page]

View: RG_DSS_REQUESTS_V

Comments
View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns
Name Datatype Length Mandatory Comments
PROGRAM_TYPE VARCHAR2 (1) Y Program type (Segment, Balances, Hierarchy, Currency, Rates, or Calendar)
PROGRAM_NAME VARCHAR2 (80) Y
REQUEST_ID NUMBER (15) Y
CONCURRENT_REQUEST_ID NUMBER (15) Y
STATUS_FLAG VARCHAR2 (1) Y
FILE_SPEC VARCHAR2 (240)
EXTRACTION_START_DATE DATE

EXTRACTION_END_DATE DATE

LOAD_START_DATE DATE

LOAD_END_DATE DATE

CHART_OF_ACCOUNTS_ID NUMBER (15)
CHART_OF_ACCOUNTS_NAME VARCHAR2 (30)
LEDGER_ID NUMBER (15)
LEDGER_NAME VARCHAR2 (30)
FROM_PERIOD VARCHAR2 (15)
TO_PERIOD VARCHAR2 (15)
BALANCE_TYPE VARCHAR2 (4)
BALANCE_MEANING VARCHAR2 (80)
BUDGET_VERSION_ID NUMBER (15)
ENCUMBRANCE_TYPE_ID NUMBER (15)
BUDGET_ENC_NAME VARCHAR2 (30)
TEMPLATE_ID NUMBER (15)
TEMPLATE_NAME VARCHAR2 (50)
DAY_OF_PERIOD NUMBER (15)
HIERARCHY_ID NUMBER (15)
HIERARCHY_NAME VARCHAR2 (60)
PERIOD_YEAR NUMBER (15)
LAST_UPDATE_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
LAST_UPDATE_LOGIN NUMBER (15) Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER (15) Y

[top of page]

APPS.RG_DSS_REQUESTS_V references the following:

APPS
SYNONYM - FND_ID_FLEX_STRUCTURES_TL
SYNONYM - GL_BUDGET_VERSIONS
SYNONYM - GL_ENCUMBRANCE_TYPES
SYNONYM - GL_LEDGERS
SYNONYM - GL_SUMMARY_TEMPLATES
SYNONYM - RG_DSS_HIERARCHIES
SYNONYM - RG_DSS_REQUESTS
- GL_LOOKUPS

APPS.RG_DSS_REQUESTS_V is not referenced by any database object

[top of page]

View: RG_DSS_SEG_RANGE_SETS_V

Comments
View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)

RANGE_SET_ID NUMBER (15) Y
NAME VARCHAR2 (60) Y
SEGMENT_NAME VARCHAR2 (30) Y
SEGMENT_NUM NUMBER (3) Y
APPLICATION_COLUMN_NAME VARCHAR2 (30) Y
ID_FLEX_CODE VARCHAR2 (4) Y
ID_FLEX_NUM NUMBER (15) Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
LAST_UPDATE_LOGIN NUMBER (15) Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER (15) Y
DESCRIPTION VARCHAR2 (240)

CONTEXT VARCHAR2 (30)

ATTRIBUTE1 VARCHAR2 (150)

ATTRIBUTE2 VARCHAR2 (150)

ATTRIBUTE3 VARCHAR2 (150)

ATTRIBUTE4 VARCHAR2 (150)

ATTRIBUTE5 VARCHAR2 (150)

ATTRIBUTE6 VARCHAR2 (150)

ATTRIBUTE7 VARCHAR2 (150)

ATTRIBUTE8 VARCHAR2 (150)

ATTRIBUTE9 VARCHAR2 (150)

ATTRIBUTE10 VARCHAR2 (150)

ATTRIBUTE11 VARCHAR2 (150)

ATTRIBUTE12 VARCHAR2 (150)

ATTRIBUTE13 VARCHAR2 (150)

ATTRIBUTE14 VARCHAR2 (150)

ATTRIBUTE15 VARCHAR2 (150)

[top of page]

APPS.RG_DSS_SEG_RANGE_SETS_V references the following:

APPS
SYNONYM - FND_ID_FLEX_SEGMENTS
SYNONYM - RG_DSS_SEG_RANGE_SETS

APPS.RG_DSS_SEG_RANGE_SETS_V is not referenced by any database object

[top of page]

View: RG_DSS_SYSTEM_SEG_ORDER_V

Comments
View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)

SYSTEM_ID NUMBER (15) Y
SEQUENCE NUMBER (15) Y
SEGMENT_NAME VARCHAR2 (30) Y
APPLICATION_COLUMN_NAME VARCHAR2 (30) Y
ID_FLEX_CODE VARCHAR2 (4) Y
ID_FLEX_NUM NUMBER (15) Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER (15) Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
LAST_UPDATE_LOGIN NUMBER (15) Y
CONTEXT VARCHAR2 (150)

ATTRIBUTE1 VARCHAR2 (150)

ATTRIBUTE2 VARCHAR2 (150)

ATTRIBUTE3 VARCHAR2 (150)

ATTRIBUTE4 VARCHAR2 (150)

ATTRIBUTE5 VARCHAR2 (150)

ATTRIBUTE6 VARCHAR2 (150)

ATTRIBUTE7 VARCHAR2 (150)

ATTRIBUTE8 VARCHAR2 (150)

ATTRIBUTE9 VARCHAR2 (150)

ATTRIBUTE10 VARCHAR2 (150)

ATTRIBUTE11 VARCHAR2 (150)

ATTRIBUTE12 VARCHAR2 (150)

ATTRIBUTE13 VARCHAR2 (150)

ATTRIBUTE14 VARCHAR2 (150)

ATTRIBUTE15 VARCHAR2 (150)

[top of page]

APPS.RG_DSS_SYSTEM_SEG_ORDER_V references the following:

APPS
SYNONYM - FND_ID_FLEX_SEGMENTS
SYNONYM - RG_DSS_SYSTEM_SEG_ORDER

APPS.RG_DSS_SYSTEM_SEG_ORDER_V is not referenced by any database object

[top of page]

View: RG_DSS_SYSTEM_VARIABLES_V

Comments
View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
SYSTEM_ID NUMBER (15) Y
VARIABLE_ID NUMBER (15) Y
VARIABLE_NAME VARCHAR2 (60) Y
SYSTEM_VARIABLE_ID NUMBER (15) Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
LAST_UPDATE_LOGIN NUMBER (15) Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER (15) Y
CONTEXT VARCHAR2 (30)
ATTRIBUTE1 VARCHAR2 (150)
ATTRIBUTE2 VARCHAR2 (150)
ATTRIBUTE3 VARCHAR2 (150)
ATTRIBUTE4 VARCHAR2 (150)
ATTRIBUTE5 VARCHAR2 (150)
ATTRIBUTE6 VARCHAR2 (150)
ATTRIBUTE7 VARCHAR2 (150)
ATTRIBUTE8 VARCHAR2 (150)
ATTRIBUTE9 VARCHAR2 (150)
ATTRIBUTE10 VARCHAR2 (150)
ATTRIBUTE11 VARCHAR2 (150)
ATTRIBUTE12 VARCHAR2 (150)
ATTRIBUTE13 VARCHAR2 (150)
ATTRIBUTE14 VARCHAR2 (150)
ATTRIBUTE15 VARCHAR2 (150)

[top of page]

APPS.RG_DSS_SYSTEM_VARIABLES_V references the following:

APPS
SYNONYM - RG_DSS_SYSTEM_VARIABLES
SYNONYM - RG_DSS_VARIABLES

APPS.RG_DSS_SYSTEM_VARIABLES_V is not referenced by any database object

[top of page]

View: RG_DSS_VARIABLES_V

Comments
View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
VARIABLE_ID NUMBER (15) Y
NAME VARCHAR2 (60) Y
DESCRIPTION VARCHAR2 (240)
LEVEL_CODE VARCHAR2 (1) Y
STATUS_CODE VARCHAR2 (1) Y
OBJECT_NAME VARCHAR2 (16) Y
COLUMN_LABEL VARCHAR2 (30) Y
BALANCE_TYPE VARCHAR2 (4) Y
CURRENCY_TYPE VARCHAR2 (2) Y
CURRENCY_CODE VARCHAR2 (30)
ID_FLEX_CODE VARCHAR2 (4) Y
ID_FLEX_NUM NUMBER (15) Y
LEDGER_ID NUMBER (15) Y
LEDGER_NAME VARCHAR2 (30) Y
ADB_FLAG VARCHAR2 (1) Y
FUNC_CURR_CODE VARCHAR2 (15) Y
BUDGET_VERSION_ID NUMBER (15)
BUDGET_NAME VARCHAR2 (15)
ENCUMBRANCE_TYPE_ID NUMBER (15)
ENCUMBRANCE_TYPE VARCHAR2 (80)
LAST_UPDATE_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
LAST_UPDATE_LOGIN NUMBER (15) Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER (15) Y
CONTEXT VARCHAR2 (150)
ATTRIBUTE1 VARCHAR2 (150)
ATTRIBUTE2 VARCHAR2 (150)
ATTRIBUTE3 VARCHAR2 (150)
ATTRIBUTE4 VARCHAR2 (150)
ATTRIBUTE5 VARCHAR2 (150)
ATTRIBUTE6 VARCHAR2 (150)
ATTRIBUTE7 VARCHAR2 (150)
ATTRIBUTE8 VARCHAR2 (150)
ATTRIBUTE9 VARCHAR2 (150)
ATTRIBUTE10 VARCHAR2 (150)
ATTRIBUTE11 VARCHAR2 (150)
ATTRIBUTE12 VARCHAR2 (150)
ATTRIBUTE13 VARCHAR2 (150)
ATTRIBUTE14 VARCHAR2 (150)
ATTRIBUTE15 VARCHAR2 (150)
SEGMENT1_TYPE VARCHAR2 (25)
SEGMENT2_TYPE VARCHAR2 (25)
SEGMENT3_TYPE VARCHAR2 (25)
SEGMENT4_TYPE VARCHAR2 (25)
SEGMENT5_TYPE VARCHAR2 (25)
SEGMENT6_TYPE VARCHAR2 (25)
SEGMENT7_TYPE VARCHAR2 (25)
SEGMENT8_TYPE VARCHAR2 (25)
SEGMENT9_TYPE VARCHAR2 (25)
SEGMENT10_TYPE VARCHAR2 (25)
SEGMENT11_TYPE VARCHAR2 (25)
SEGMENT12_TYPE VARCHAR2 (25)
SEGMENT13_TYPE VARCHAR2 (25)
SEGMENT14_TYPE VARCHAR2 (25)
SEGMENT15_TYPE VARCHAR2 (25)
SEGMENT16_TYPE VARCHAR2 (25)
SEGMENT17_TYPE VARCHAR2 (25)
SEGMENT18_TYPE VARCHAR2 (25)
SEGMENT19_TYPE VARCHAR2 (25)
SEGMENT20_TYPE VARCHAR2 (25)
SEGMENT21_TYPE VARCHAR2 (25)
SEGMENT22_TYPE VARCHAR2 (25)
SEGMENT23_TYPE VARCHAR2 (25)
SEGMENT24_TYPE VARCHAR2 (25)
SEGMENT25_TYPE VARCHAR2 (25)
SEGMENT26_TYPE VARCHAR2 (25)
SEGMENT27_TYPE VARCHAR2 (25)
SEGMENT28_TYPE VARCHAR2 (25)
SEGMENT29_TYPE VARCHAR2 (25)
SEGMENT30_TYPE VARCHAR2 (25)

[top of page]

APPS.RG_DSS_VARIABLES_V references the following:

APPS
SYNONYM - GL_BUDGET_VERSIONS
SYNONYM - GL_ENCUMBRANCE_TYPES
SYNONYM - GL_LEDGERS
SYNONYM - RG_DSS_VARIABLES
- GL_LOOKUPS

APPS.RG_DSS_VARIABLES_V is not referenced by any database object

[top of page]

View: RG_DSS_VAR_DIMENSIONS_V

Comments
View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
VARIABLE_ID NUMBER (15) Y
SEQUENCE NUMBER (15) Y
DIMENSION_ID NUMBER (15) Y
DIMENSION_NAME VARCHAR2 (60) Y
LEVEL_CODE VARCHAR2 (1) Y
LEVEL_DISP VARCHAR2 (80) Y
DIMENSION_TYPE VARCHAR2 (1) Y
DIMENSION_BY_CURRENCY VARCHAR2 (1) Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
LAST_UPDATE_LOGIN NUMBER (15) Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER (15) Y
CONTEXT VARCHAR2 (30)
ATTRIBUTE1 VARCHAR2 (150)
ATTRIBUTE2 VARCHAR2 (150)
ATTRIBUTE3 VARCHAR2 (150)
ATTRIBUTE4 VARCHAR2 (150)
ATTRIBUTE5 VARCHAR2 (150)
ATTRIBUTE6 VARCHAR2 (150)
ATTRIBUTE7 VARCHAR2 (150)
ATTRIBUTE8 VARCHAR2 (150)
ATTRIBUTE9 VARCHAR2 (150)
ATTRIBUTE10 VARCHAR2 (150)
ATTRIBUTE11 VARCHAR2 (150)
ATTRIBUTE12 VARCHAR2 (150)
ATTRIBUTE13 VARCHAR2 (150)
ATTRIBUTE14 VARCHAR2 (150)
ATTRIBUTE15 VARCHAR2 (150)

[top of page]

APPS.RG_DSS_VAR_DIMENSIONS_V references the following:

APPS
SYNONYM - RG_DSS_DIMENSIONS
SYNONYM - RG_DSS_VAR_DIMENSIONS
- GL_LOOKUPS

APPS.RG_DSS_VAR_DIMENSIONS_V is not referenced by any database object

[top of page]

View: RG_DSS_VAR_SELECTIONS_V

Comments
View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)

VARIABLE_ID NUMBER (15) Y
ID_FLEX_CODE VARCHAR2 (4) Y
ID_FLEX_NUM NUMBER (15) Y
APPLICATION_COLUMN_NAME VARCHAR2 (30) Y
SEGMENT_NAME VARCHAR2 (30) Y
SELECTION_ID NUMBER (15) Y
RANGE_SET_ID NUMBER (15) Y
RANGE_SET_NAME VARCHAR2 (60) Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
LAST_UPDATE_LOGIN NUMBER (15) Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER (15) Y
CONTEXT VARCHAR2 (30)

ATTRIBUTE1 VARCHAR2 (150)

ATTRIBUTE2 VARCHAR2 (150)

ATTRIBUTE3 VARCHAR2 (150)

ATTRIBUTE4 VARCHAR2 (150)

ATTRIBUTE5 VARCHAR2 (150)

ATTRIBUTE6 VARCHAR2 (150)

ATTRIBUTE7 VARCHAR2 (150)

ATTRIBUTE8 VARCHAR2 (150)

ATTRIBUTE9 VARCHAR2 (150)

ATTRIBUTE10 VARCHAR2 (150)

ATTRIBUTE11 VARCHAR2 (150)

ATTRIBUTE12 VARCHAR2 (150)

ATTRIBUTE13 VARCHAR2 (150)

ATTRIBUTE14 VARCHAR2 (150)

ATTRIBUTE15 VARCHAR2 (150)

[top of page]

APPS.RG_DSS_VAR_SELECTIONS_V references the following:

APPS
SYNONYM - FND_ID_FLEX_SEGMENTS
SYNONYM - RG_DSS_SEG_RANGE_SETS
SYNONYM - RG_DSS_VAR_SELECTIONS

APPS.RG_DSS_VAR_SELECTIONS_V is not referenced by any database object

[top of page]

View: RG_DSS_VAR_TEMPLATES_V

Comments
View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns
Name Datatype Length Mandatory Comments
TEMPLATE_NAME VARCHAR2 (50)
Summary template name
ROW_ID ROWID (10)
VARIABLE_ID NUMBER (15) Y
TEMPLATE_ID NUMBER (15) Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
LAST_UPDATE_LOGIN NUMBER (15) Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER (15) Y
SEGMENT1_TYPE VARCHAR2 (25)
SEGMENT2_TYPE VARCHAR2 (25)
SEGMENT3_TYPE VARCHAR2 (25)
SEGMENT4_TYPE VARCHAR2 (25)
SEGMENT5_TYPE VARCHAR2 (25)
SEGMENT6_TYPE VARCHAR2 (25)
SEGMENT7_TYPE VARCHAR2 (25)
SEGMENT8_TYPE VARCHAR2 (25)
SEGMENT9_TYPE VARCHAR2 (25)
SEGMENT10_TYPE VARCHAR2 (25)
SEGMENT11_TYPE VARCHAR2 (25)
SEGMENT12_TYPE VARCHAR2 (25)
SEGMENT13_TYPE VARCHAR2 (25)
SEGMENT14_TYPE VARCHAR2 (25)
SEGMENT15_TYPE VARCHAR2 (25)
SEGMENT16_TYPE VARCHAR2 (25)
SEGMENT17_TYPE VARCHAR2 (25)
SEGMENT18_TYPE VARCHAR2 (25)
SEGMENT19_TYPE VARCHAR2 (25)
SEGMENT20_TYPE VARCHAR2 (25)
SEGMENT21_TYPE VARCHAR2 (25)
SEGMENT22_TYPE VARCHAR2 (25)
SEGMENT23_TYPE VARCHAR2 (25)
SEGMENT24_TYPE VARCHAR2 (25)
SEGMENT25_TYPE VARCHAR2 (25)
SEGMENT26_TYPE VARCHAR2 (25)
SEGMENT27_TYPE VARCHAR2 (25)
SEGMENT28_TYPE VARCHAR2 (25)
SEGMENT29_TYPE VARCHAR2 (25)
SEGMENT30_TYPE VARCHAR2 (25)
CONTEXT VARCHAR2 (150)
ATTRIBUTE1 VARCHAR2 (150)
ATTRIBUTE2 VARCHAR2 (150)
ATTRIBUTE3 VARCHAR2 (150)
ATTRIBUTE4 VARCHAR2 (150)
ATTRIBUTE5 VARCHAR2 (150)
ATTRIBUTE6 VARCHAR2 (150)
ATTRIBUTE7 VARCHAR2 (150)
ATTRIBUTE8 VARCHAR2 (150)
ATTRIBUTE9 VARCHAR2 (150)
ATTRIBUTE10 VARCHAR2 (150)
ATTRIBUTE11 VARCHAR2 (150)
ATTRIBUTE12 VARCHAR2 (150)
ATTRIBUTE13 VARCHAR2 (150)
ATTRIBUTE14 VARCHAR2 (150)
ATTRIBUTE15 VARCHAR2 (150)

[top of page]

APPS.RG_DSS_VAR_TEMPLATES_V references the following:

APPS
SYNONYM - GL_SUMMARY_TEMPLATES
SYNONYM - RG_DSS_VAR_TEMPLATES

APPS.RG_DSS_VAR_TEMPLATES_V is not referenced by any database object

[top of page]

View: RG_ENCUMBRANCES_V

Comments
View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)

PARAMETER_SET_ID NUMBER (15) Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
LAST_UPDATE_LOGIN NUMBER (15) Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER (15) Y
PARAMETER_NUM NUMBER (15) Y
PARAMETER_ID NUMBER (15)

ENCUMBRANCE_TYPE VARCHAR2 (30) Y
DESCRIPTION VARCHAR2 (240)

DATA_TYPE VARCHAR2 (1) Y
CONTEXT VARCHAR2 (30)

ATTRIBUTE1 VARCHAR2 (150)

ATTRIBUTE2 VARCHAR2 (150)

ATTRIBUTE3 VARCHAR2 (150)

ATTRIBUTE4 VARCHAR2 (150)

ATTRIBUTE5 VARCHAR2 (150)

ATTRIBUTE6 VARCHAR2 (150)

ATTRIBUTE7 VARCHAR2 (150)

ATTRIBUTE8 VARCHAR2 (150)

ATTRIBUTE9 VARCHAR2 (150)

ATTRIBUTE10 VARCHAR2 (150)

ATTRIBUTE11 VARCHAR2 (150)

ATTRIBUTE12 VARCHAR2 (150)

ATTRIBUTE13 VARCHAR2 (150)

ATTRIBUTE14 VARCHAR2 (150)

ATTRIBUTE15 VARCHAR2 (150)

[top of page]

APPS.RG_ENCUMBRANCES_V references the following:

APPS
SYNONYM - GL_ENCUMBRANCE_TYPES
SYNONYM - RG_REPORT_PARAMETERS

APPS.RG_ENCUMBRANCES_V is not referenced by any database object

[top of page]

View: RG_FACTOR_V

Comments
View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns
Name Datatype Length Mandatory Comments
DISPLAY_UNITS VARCHAR2 (30) Y
FACTOR VARCHAR2 (80) Y

[top of page]

APPS.RG_FACTOR_V references the following:

- RG_LOOKUPS

APPS.RG_FACTOR_V is not referenced by any database object

[top of page]

View: RG_LEVEL_OF_DETAIL_V

Comments
View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns
Name Datatype Length Mandatory Comments
DISPLAY_LEVEL VARCHAR2 (30) Y
LEVEL_OF_DETAIL VARCHAR2 (80) Y

[top of page]

APPS.RG_LEVEL_OF_DETAIL_V references the following:

- RG_LOOKUPS

APPS.RG_LEVEL_OF_DETAIL_V is not referenced by any database object

[top of page]

View: RG_LOOKUPS

Comments
View Type

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

Columns
Name Datatype Length Mandatory Comments
LOOKUP_TYPE VARCHAR2 (30) Y
LOOKUP_CODE VARCHAR2 (30) Y
MEANING VARCHAR2 (80) Y
DESCRIPTION VARCHAR2 (240)
ENABLED_FLAG VARCHAR2 (1) Y
START_DATE_ACTIVE DATE

END_DATE_ACTIVE DATE

[top of page]

APPS.RG_LOOKUPS references the following:

APPS
SYNONYM - FND_LOOKUP_VALUES
APPS.RG_LOOKUPS is referenced by following:

APPS
VIEW - RG_REPORT_AXES_V

[top of page]

View: RG_PERIOD_YEARS_V

Comments
View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns
Name Datatype Length Mandatory Comments
PERIOD_YEAR NUMBER (15) Y Accounting period year
APPLICATION_ID NUMBER (15) Y Application defining column
LEDGER_ID NUMBER (15) Y

[top of page]

APPS.RG_PERIOD_YEARS_V references the following:

APPS
SYNONYM - GL_PERIOD_STATUSES

APPS.RG_PERIOD_YEARS_V is not referenced by any database object

[top of page]

View: RG_REPORTS_V

Comments
View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
APPLICATION_ID NUMBER (15) Y
REPORT_ID NUMBER (15) Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
LAST_UPDATE_LOGIN NUMBER (15) Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER (15) Y
NAME VARCHAR2 (30) Y
REPORT_TITLE VARCHAR2 (240) Y
SECURITY_FLAG VARCHAR2 (1) Y
ROW_SET_ID NUMBER (15) Y
COLUMN_SET_ID NUMBER (15) Y
REPORT_DISPLAY_SET_ID NUMBER (15)
CONTENT_SET_ID NUMBER (15)
ROW_ORDER_ID NUMBER (15)
MINIMUM_DISPLAY_LEVEL NUMBER (15)
COLUMN_SET VARCHAR2 (30) Y
ROW_SET VARCHAR2 (30) Y
REPORT_DISPLAY_SET VARCHAR2 (30)
CONTENT_SET VARCHAR2 (30)
ROW_ORDER VARCHAR2 (30)
ROUNDING_OPTION VARCHAR2 (1) Y
PARAMETER_SET_ID NUMBER (15)
UNIT_OF_MEASURE_ID VARCHAR2 (30)
ID_FLEX_CODE VARCHAR2 (4)
STRUCTURE_ID NUMBER (15)
SEGMENT_OVERRIDE VARCHAR2 (2000)
OVERRIDE_ALC_LEDGER_CURRENCY VARCHAR2 (30)
DESCRIPTION VARCHAR2 (240)
CONTEXT VARCHAR2 (30)
ATTRIBUTE1 VARCHAR2 (150)
ATTRIBUTE2 VARCHAR2 (150)
ATTRIBUTE3 VARCHAR2 (150)
ATTRIBUTE4 VARCHAR2 (150)
ATTRIBUTE5 VARCHAR2 (150)
ATTRIBUTE6 VARCHAR2 (150)
ATTRIBUTE7 VARCHAR2 (150)
ATTRIBUTE8 VARCHAR2 (150)
ATTRIBUTE9 VARCHAR2 (150)
ATTRIBUTE10 VARCHAR2 (150)
ATTRIBUTE11 VARCHAR2 (150)
ATTRIBUTE12 VARCHAR2 (150)
ATTRIBUTE13 VARCHAR2 (150)
ATTRIBUTE14 VARCHAR2 (150)
ATTRIBUTE15 VARCHAR2 (150)
OUTPUT_OPTION VARCHAR2 (1) Y
VIEW_PRIVILEGE VARCHAR2 (1)
USE_PRIVILEGE VARCHAR2 (1)
MODIFY_PRIVILEGE VARCHAR2 (1)

[top of page]

APPS.RG_REPORTS_V references the following:

APPS
PACKAGE - FND_DATA_SECURITY
PACKAGE - FND_GLOBAL
SYNONYM - RG_REPORTS
SYNONYM - RG_REPORT_AXIS_SETS
SYNONYM - RG_REPORT_CONTENT_SETS
SYNONYM - RG_REPORT_DISPLAY_SETS
SYNONYM - RG_ROW_ORDERS
- RG_LOOKUPS

APPS.RG_REPORTS_V is not referenced by any database object

[top of page]

View: RG_REPORT_AXES_V

Comments
View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
APPLICATION_ID NUMBER (15) Y
AXIS_SET_ID NUMBER (15) Y
SEQUENCE NUMBER
Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
LAST_UPDATE_LOGIN NUMBER (15) Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER (15) Y
AXIS_TYPE VARCHAR2 (1) Y
NAME VARCHAR2 (30)
AMOUNT_ID NUMBER (15)
AMOUNT_TYPE VARCHAR2 (30)
STANDARD_AXIS_ID NUMBER (15)
WIDTH NUMBER (15)
POSITION NUMBER (15)
STRUCTURE_ID NUMBER (15)
UNIT_OF_MEASURE_ID VARCHAR2 (30)
PARAMETER_NUM NUMBER (15)
PERIOD_OFFSET NUMBER (15)
DESCRIPTION VARCHAR2 (240)
DISPLAY_FLAG VARCHAR2 (1)
BEFORE_AXIS_STRING VARCHAR2 (10)
AFTER_AXIS_STRING VARCHAR2 (10)
NUMBER_CHARACTERS_INDENTED NUMBER (15)
PAGE_BREAK_AFTER_FLAG VARCHAR2 (1)
PAGE_BREAK_BEFORE_FLAG VARCHAR2 (1)
NUMBER_LINES_SKIPPED_BEFORE NUMBER (15)
NUMBER_LINES_SKIPPED_AFTER NUMBER (15)
LEVEL_OF_DETAIL VARCHAR2 (80)
DISPLAY_LEVEL NUMBER (15)
DISPLAY_ZERO_AMOUNT_FLAG VARCHAR2 (1)
CHANGE_SIGN_FLAG VARCHAR2 (1)
CHANGE_VARIANCE_SIGN_FLAG VARCHAR2 (1)
FACTOR VARCHAR2 (80)
DISPLAY_UNITS NUMBER (15)
DISPLAY_FORMAT VARCHAR2 (30)
CALCULATION_PRECEDENCE_FLAG VARCHAR2 (1)
PERCENTAGE_DIVISOR_SEQ NUMBER

TRANSACTION_FLAG VARCHAR2 (1)
FORMAT_BEFORE_TEXT VARCHAR2 (30)
FORMAT_AFTER_TEXT VARCHAR2 (30)
FORMAT_MASK_WIDTH NUMBER (15)
DISPLAY_PRECISION NUMBER (15)
SEGMENT_OVERRIDE_VALUE VARCHAR2 (60)
OVERRIDE_ALC_LEDGER_CURRENCY VARCHAR2 (30)
CONTEXT VARCHAR2 (30)
ATTRIBUTE1 VARCHAR2 (150)
ATTRIBUTE2 VARCHAR2 (150)
ATTRIBUTE3 VARCHAR2 (150)
ATTRIBUTE4 VARCHAR2 (150)
ATTRIBUTE5 VARCHAR2 (150)
ATTRIBUTE6 VARCHAR2 (150)
ATTRIBUTE7 VARCHAR2 (150)
ATTRIBUTE8 VARCHAR2 (150)
ATTRIBUTE9 VARCHAR2 (150)
ATTRIBUTE10 VARCHAR2 (150)
ATTRIBUTE11 VARCHAR2 (150)
ATTRIBUTE12 VARCHAR2 (150)
ATTRIBUTE13 VARCHAR2 (150)
ATTRIBUTE14 VARCHAR2 (150)
ATTRIBUTE15 VARCHAR2 (150)
ELEMENT_ID NUMBER (15)
ELEMENT_NAME VARCHAR2 (240)
ELEMENT_LABEL VARCHAR2 (240)

[top of page]

APPS.RG_REPORT_AXES_V references the following:

APPS
VIEW - RG_LOOKUPS
SYNONYM - RG_REPORT_AXES
SYNONYM - RG_REPORT_STANDARD_AXES_TL
SYNONYM - RG_XBRL_ELEMENTS

APPS.RG_REPORT_AXES_V is not referenced by any database object

[top of page]

View: RG_REPORT_AXIS_SETS_LOV_V

Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
NAME VARCHAR2 (30) Y
DESCRIPTION VARCHAR2 (240)
APPLICATION_ID NUMBER (15) Y
AXIS_SET_TYPE VARCHAR2 (1) Y
AXIS_SET_ID NUMBER (15) Y
SECURITY_FLAG VARCHAR2 (1) Y
STRUCTURE_ID NUMBER (15)
ID_FLEX_CODE VARCHAR2 (4)
VIEW_PRIVILEGE VARCHAR2 (1)
USE_PRIVILEGE VARCHAR2 (1)
MODIFY_PRIVILEGE VARCHAR2 (1)

[top of page]

APPS.RG_REPORT_AXIS_SETS_LOV_V references the following:

APPS
PACKAGE - FND_DATA_SECURITY
PACKAGE - FND_GLOBAL
SYNONYM - RG_REPORT_AXIS_SETS

APPS.RG_REPORT_AXIS_SETS_LOV_V is not referenced by any database object

[top of page]

View: RG_REPORT_AXIS_SETS_V

Comments
View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
APPLICATION_ID NUMBER (15) Y
AXIS_SET_ID NUMBER (15) Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
LAST_UPDATE_LOGIN NUMBER (15) Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER (15) Y
NAME VARCHAR2 (30) Y
AXIS_SET_TYPE VARCHAR2 (1) Y
SECURITY_FLAG VARCHAR2 (1) Y
DISPLAY_IN_LIST_FLAG VARCHAR2 (1)
PERIOD_SET_NAME VARCHAR2 (15)
DESCRIPTION VARCHAR2 (240)
COLUMN_SET_HEADER CLOB (4000)
SEGMENT_NAME VARCHAR2 (30)
SEGMENT_DISPLAY_NAME VARCHAR2 (30)
SEGMENT_NUM NUMBER (3)
ID_FLEX_CODE VARCHAR2 (4)
STRUCTURE_ID NUMBER (15)
CONTEXT VARCHAR2 (30)
ATTRIBUTE1 VARCHAR2 (150)
ATTRIBUTE2 VARCHAR2 (150)
ATTRIBUTE3 VARCHAR2 (150)
ATTRIBUTE4 VARCHAR2 (150)
ATTRIBUTE5 VARCHAR2 (150)
ATTRIBUTE6 VARCHAR2 (150)
ATTRIBUTE7 VARCHAR2 (150)
ATTRIBUTE8 VARCHAR2 (150)
ATTRIBUTE9 VARCHAR2 (150)
ATTRIBUTE10 VARCHAR2 (150)
ATTRIBUTE11 VARCHAR2 (150)
ATTRIBUTE12 VARCHAR2 (150)
ATTRIBUTE13 VARCHAR2 (150)
ATTRIBUTE14 VARCHAR2 (150)
ATTRIBUTE15 VARCHAR2 (150)
TAXONOMY_ID NUMBER (15)
TAXONOMY_NAME VARCHAR2 (240)
TAXONOMY_DESCR VARCHAR2 (240)
TAXONOMY_IMPORT_FLAG VARCHAR2 (1)
VIEW_PRIVILEGE VARCHAR2 (1)
USE_PRIVILEGE VARCHAR2 (1)
MODIFY_PRIVILEGE VARCHAR2 (1)

[top of page]

APPS.RG_REPORT_AXIS_SETS_V references the following:

APPS
PACKAGE - FND_DATA_SECURITY
PACKAGE - FND_GLOBAL
SYNONYM - FND_ID_FLEX_SEGMENTS
SYNONYM - RG_REPORT_AXIS_SETS
SYNONYM - RG_XBRL_TAXONOMIES

APPS.RG_REPORT_AXIS_SETS_V is not referenced by any database object

[top of page]

View: RG_REPORT_DISPLAYS_V

Comments
View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)

REPORT_DISPLAY_ID NUMBER (15) Y
REPORT_DISPLAY_SET_ID NUMBER (15) Y
SEQUENCE NUMBER
Y
ROW_GROUP_ID NUMBER (15)

ROW_GROUP VARCHAR2 (30)

ROW_SET VARCHAR2 (30)

ROW_FROM_SEQUENCE NUMBER


ROW_TO_SEQUENCE NUMBER


COLUMN_GROUP_ID NUMBER (15)

COLUMN_GROUP VARCHAR2 (30)

COLUMN_SET VARCHAR2 (30)

COLUMN_FROM_SEQUENCE NUMBER


COLUMN_TO_SEQUENCE NUMBER


DESCRIPTION VARCHAR2 (240)

DISPLAY_FLAG VARCHAR2 (1) Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER (15) Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
LAST_UPDATE_LOGIN NUMBER (15) Y
CONTEXT VARCHAR2 (30)

ATTRIBUTE1 VARCHAR2 (150)

ATTRIBUTE2 VARCHAR2 (150)

ATTRIBUTE3 VARCHAR2 (150)

ATTRIBUTE4 VARCHAR2 (150)

ATTRIBUTE5 VARCHAR2 (150)

ATTRIBUTE6 VARCHAR2 (150)

ATTRIBUTE7 VARCHAR2 (150)

ATTRIBUTE8 VARCHAR2 (150)

ATTRIBUTE9 VARCHAR2 (150)

ATTRIBUTE10 VARCHAR2 (150)

ATTRIBUTE11 VARCHAR2 (150)

ATTRIBUTE12 VARCHAR2 (150)

ATTRIBUTE13 VARCHAR2 (150)

ATTRIBUTE14 VARCHAR2 (150)

ATTRIBUTE15 VARCHAR2 (150)

[top of page]

APPS.RG_REPORT_DISPLAYS_V references the following:

APPS
SYNONYM - RG_REPORT_AXIS_SETS
SYNONYM - RG_REPORT_DISPLAYS
SYNONYM - RG_REPORT_DISPLAY_GROUPS

APPS.RG_REPORT_DISPLAYS_V is not referenced by any database object

[top of page]

View: RG_REPORT_DISPLAY_GROUPS_V

Comments
View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
REPORT_DISPLAY_GROUP_ID NUMBER (15) Y
NAME VARCHAR2 (30) Y
DESCRIPTION VARCHAR2 (240)
ROW_SET_ID NUMBER (15)
ROW_SET VARCHAR2 (30)
COLUMN_SET_ID NUMBER (15)
COLUMN_SET VARCHAR2 (30)
FROM_SEQUENCE NUMBER
Y
TO_SEQUENCE NUMBER
Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER (15) Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
LAST_UPDATE_LOGIN NUMBER (15) Y
CONTEXT VARCHAR2 (30)
ATTRIBUTE1 VARCHAR2 (150)
ATTRIBUTE2 VARCHAR2 (150)
ATTRIBUTE3 VARCHAR2 (150)
ATTRIBUTE4 VARCHAR2 (150)
ATTRIBUTE5 VARCHAR2 (150)
ATTRIBUTE6 VARCHAR2 (150)
ATTRIBUTE7 VARCHAR2 (150)
ATTRIBUTE8 VARCHAR2 (150)
ATTRIBUTE9 VARCHAR2 (150)
ATTRIBUTE10 VARCHAR2 (150)
ATTRIBUTE11 VARCHAR2 (150)
ATTRIBUTE12 VARCHAR2 (150)
ATTRIBUTE13 VARCHAR2 (150)
ATTRIBUTE14 VARCHAR2 (150)
ATTRIBUTE15 VARCHAR2 (150)
ROW_SET_USE_PRIVILEGE VARCHAR2 (1)
COL_SET_USE_PRIVILEGE VARCHAR2 (1)

[top of page]

APPS.RG_REPORT_DISPLAY_GROUPS_V references the following:

APPS
PACKAGE - FND_DATA_SECURITY
PACKAGE - FND_GLOBAL
SYNONYM - RG_REPORT_AXIS_SETS
SYNONYM - RG_REPORT_DISPLAY_GROUPS

APPS.RG_REPORT_DISPLAY_GROUPS_V is not referenced by any database object

[top of page]

View: RG_REPORT_DISPLAY_SETS_V

Comments
View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
REPORT_DISPLAY_SET_ID NUMBER (15) Y
NAME VARCHAR2 (30) Y
DESCRIPTION VARCHAR2 (240)
ROW_SET_ID NUMBER (15)
ROW_SET VARCHAR2 (30)
COLUMN_SET_ID NUMBER (15)
COLUMN_SET VARCHAR2 (30)
CREATION_DATE DATE
Y
CREATED_BY NUMBER (15) Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
LAST_UPDATE_LOGIN NUMBER (15) Y
CONTEXT VARCHAR2 (30)
ATTRIBUTE1 VARCHAR2 (150)
ATTRIBUTE2 VARCHAR2 (150)
ATTRIBUTE3 VARCHAR2 (150)
ATTRIBUTE4 VARCHAR2 (150)
ATTRIBUTE5 VARCHAR2 (150)
ATTRIBUTE6 VARCHAR2 (150)
ATTRIBUTE7 VARCHAR2 (150)
ATTRIBUTE8 VARCHAR2 (150)
ATTRIBUTE9 VARCHAR2 (150)
ATTRIBUTE10 VARCHAR2 (150)
ATTRIBUTE11 VARCHAR2 (150)
ATTRIBUTE12 VARCHAR2 (150)
ATTRIBUTE13 VARCHAR2 (150)
ATTRIBUTE14 VARCHAR2 (150)
ATTRIBUTE15 VARCHAR2 (150)
ROW_SET_USE_PRIVILEGE VARCHAR2 (1)
COL_SET_USE_PRIVILEGE VARCHAR2 (1)

[top of page]

APPS.RG_REPORT_DISPLAY_SETS_V references the following:

APPS
PACKAGE - FND_DATA_SECURITY
PACKAGE - FND_GLOBAL
SYNONYM - RG_REPORT_AXIS_SETS
SYNONYM - RG_REPORT_DISPLAY_SETS

APPS.RG_REPORT_DISPLAY_SETS_V is not referenced by any database object

[top of page]

View: RG_REPORT_NAME_V

Comments
View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns
Name Datatype Length Mandatory Comments
APPLICATION_ID NUMBER (15) Y Application defining column
REPORT_ID NUMBER (15) Y Report defining column
NAME VARCHAR2 (30) Y Name for this report
REPORT_TITLE VARCHAR2 (240) Y Report title
SECURITY_FLAG VARCHAR2 (1) Y Reserved for future use
DESCRIPTION VARCHAR2 (240)
Description of the report
UNIT_OF_MEASURE_ID VARCHAR2 (30)
Specific unit of measure or currency
PARAMETER_SET_ID NUMBER (15)
Parameter set for running this report
REPORT_DISPLAY_SET_ID NUMBER (15)
Defining column for the optional report display set for this report
REPORT_DISPLAY_SET VARCHAR2 (30)
Report display set name
CONTENT_SET_ID NUMBER (15)
Defining column for the optional content set for this report
CONTENT_SET VARCHAR2 (30)
Content set name
ROW_ORDER_ID NUMBER (15)
Defining column for the optional row order for this report
ROW_ORDER VARCHAR2 (30)
Name of this row order
COLUMN_SET_ID NUMBER (15) Y Defining column for the column set for this report
COLUMN_SET VARCHAR2 (30) Y Row set or column set name
ROW_SET_ID NUMBER (15) Y Defining column for the row set for this report
ROW_SET VARCHAR2 (30) Y Row set or column set name
ROUNDING_OPTION VARCHAR2 (1) Y Report rounding method
ID_FLEX_CODE VARCHAR2 (4)
GL# or GLAT
STRUCTURE_ID NUMBER (15)
Key Flexfield structure defining column
SEGMENT_OVERRIDE VARCHAR2 (2000)
Values of the segments to override at runtime
OVERRIDE_ALC_LEDGER_CURRENCY VARCHAR2 (30)
MINIMUM_DISPLAY_LEVEL NUMBER (15)
EXCEPTIONS_FLAG CHAR (1)
OUTPUT_OPTION VARCHAR2 (1) Y
USE_PRIVILEGE VARCHAR2 (1)

[top of page]

APPS.RG_REPORT_NAME_V references the following:

APPS
PACKAGE - FND_DATA_SECURITY
PACKAGE - FND_GLOBAL
SYNONYM - RG_REPORTS
SYNONYM - RG_REPORT_AXIS_SETS
SYNONYM - RG_REPORT_CONTENT_SETS
SYNONYM - RG_REPORT_DISPLAY_SETS
SYNONYM - RG_ROW_ORDERS
- RG_LOOKUPS

APPS.RG_REPORT_NAME_V is not referenced by any database object

[top of page]

View: RG_REPORT_REQUESTS_V

Comments
View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
APPLICATION_ID NUMBER (15) Y
REPORT_REQUEST_ID NUMBER (15) Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
LAST_UPDATE_LOGIN NUMBER (15) Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER (15) Y
SEQUENCE NUMBER

FORM_SUBMISSION_FLAG VARCHAR2 (1)
CONCURRENT_REQUEST_ID NUMBER (15)
REPORT_SET_ID NUMBER (15)
REPORT_ID NUMBER (15) Y
REPORT_NAME VARCHAR2 (30) Y
REPORT_TITLE VARCHAR2 (240) Y
PARAMETER_SET_ID NUMBER (15)
ROW_SET_ID NUMBER (15) Y
ROW_SET VARCHAR2 (30) Y
COLUMN_SET_ID NUMBER (15) Y
COLUMN_SET VARCHAR2 (30) Y
R_CONTENT_SET_ID NUMBER (15)
R_CONTENT_SET VARCHAR2 (30)
R_ROW_ORDER_ID NUMBER (15)
R_ROW_ORDER VARCHAR2 (30)
R_REPORT_DISPLAY_SET_ID NUMBER (15)
R_REPORT_DISPLAY_SET VARCHAR2 (30)
R_ROUNDING_OPTION VARCHAR2 (1) Y
R_SEGMENT_OVERRIDE VARCHAR2 (2000)
R_OVERRIDE_ALC_LEDGER_CURRENCY VARCHAR2 (30)
R_UNIT_OF_MEASURE_ID VARCHAR2 (30)
R_OUTPUT_OPTION VARCHAR2 (1) Y
MINIMUM_DISPLAY_LEVEL NUMBER (15)
CONTENT_SET_ID NUMBER (15)
CONTENT_SET VARCHAR2 (30)
ROW_ORDER_ID NUMBER (15)
ROW_ORDER VARCHAR2 (30)
REPORT_DISPLAY_SET_ID NUMBER (15)
REPORT_DISPLAY_SET VARCHAR2 (30)
ROUNDING_OPTION VARCHAR2 (1)
SEGMENT_OVERRIDE VARCHAR2 (2000)
OVERRIDE_ALC_LEDGER_CURRENCY VARCHAR2 (30)
UNIT_OF_MEASURE_ID VARCHAR2 (30)
OUTPUT_OPTION VARCHAR2 (1)
ID_FLEX_CODE VARCHAR2 (4)
STRUCTURE_ID NUMBER (15)
LEDGER_ID NUMBER (15)
ALC_LEDGER_CURRENCY VARCHAR2 (30)
PERIOD_NAME VARCHAR2 (15)
ACCOUNTING_DATE DATE

EXCEPTIONS_FLAG VARCHAR2 (1)
CONTEXT VARCHAR2 (30)
ATTRIBUTE1 VARCHAR2 (150)
ATTRIBUTE2 VARCHAR2 (150)
ATTRIBUTE3 VARCHAR2 (150)
ATTRIBUTE4 VARCHAR2 (150)
ATTRIBUTE5 VARCHAR2 (150)
ATTRIBUTE6 VARCHAR2 (150)
ATTRIBUTE7 VARCHAR2 (150)
ATTRIBUTE8 VARCHAR2 (150)
ATTRIBUTE9 VARCHAR2 (150)
ATTRIBUTE10 VARCHAR2 (150)
ATTRIBUTE11 VARCHAR2 (150)
ATTRIBUTE12 VARCHAR2 (150)
ATTRIBUTE13 VARCHAR2 (150)
ATTRIBUTE14 VARCHAR2 (150)
ATTRIBUTE15 VARCHAR2 (150)
USE_PRIVILEGE VARCHAR2 (1)

[top of page]

APPS.RG_REPORT_REQUESTS_V references the following:

APPS
PACKAGE - FND_DATA_SECURITY
PACKAGE - FND_GLOBAL
SYNONYM - RG_REPORTS
SYNONYM - RG_REPORT_AXIS_SETS
SYNONYM - RG_REPORT_CONTENT_SETS
SYNONYM - RG_REPORT_DISPLAY_SETS
SYNONYM - RG_REPORT_REQUESTS
SYNONYM - RG_ROW_ORDERS

APPS.RG_REPORT_REQUESTS_V is not referenced by any database object

[top of page]

View: RG_REPORT_SET_NAME_V

Comments
View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns
Name Datatype Length Mandatory Comments
REPORT_SET_ID NUMBER (15) Y Report set defining column
NAME VARCHAR2 (30) Y Name of report set
DESCRIPTION VARCHAR2 (240)
Description of the report set
APPLICATION_ID NUMBER (15) Y Application defining column
ID_FLEX_CODE VARCHAR2 (4)
GL# or GLAT
STRUCTURE_ID NUMBER (15)
Key Flexfield structure defining column
USE_PRIVILEGE VARCHAR2 (1)

[top of page]

APPS.RG_REPORT_SET_NAME_V references the following:

APPS
PACKAGE - FND_DATA_SECURITY
PACKAGE - FND_GLOBAL
SYNONYM - RG_REPORT_SETS

APPS.RG_REPORT_SET_NAME_V is not referenced by any database object

[top of page]

View: RG_REPORT_STANDARD_AXES_VL

Comments
View Type

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

Columns
Name Datatype Length Mandatory Comments
APPLICATION_ID NUMBER (15) Y Application defining column
STANDARD_AXIS_ID NUMBER (15) Y Standard axis defining column
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15) Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER (15) Y Standard Who column
STANDARD_AXIS_NAME VARCHAR2 (30) Y Name of standard axis
CLASS VARCHAR2 (1) Y Class of standard axis, calculated or primitive
DISPLAY_IN_STANDARD_LIST_FLAG VARCHAR2 (1) Y Indicated whether to display in quickpick
PRECEDENCE_LEVEL NUMBER (2) Y 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

[top of page]

APPS.RG_REPORT_STANDARD_AXES_VL references the following:

APPS
SYNONYM - RG_REPORT_STANDARD_AXES_B
SYNONYM - RG_REPORT_STANDARD_AXES_TL

APPS.RG_REPORT_STANDARD_AXES_VL is not referenced by any database object

[top of page]

View: RG_ROW_SEGMENT_SEQUENCES_V

Comments
View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
APPLICATION_ID NUMBER (15) Y
ROW_ORDER_ID NUMBER (15) Y
ROW_SEGMENT_SEQUENCE_ID NUMBER (15) Y
SEGMENT_SEQUENCE NUMBER (15) Y
SEG_ORDER_TYPE VARCHAR2 (1) Y
SEG_DISPLAY_TYPE VARCHAR2 (1) Y
STRUCTURE_ID NUMBER (15) Y
SEGMENT_NAME VARCHAR2 (30)
SEG_NAME VARCHAR2 (30)
APPLICATION_COLUMN_NAME VARCHAR2 (30)
SEGMENT_WIDTH NUMBER (15)
CREATION_DATE DATE
Y
CREATED_BY NUMBER (15) Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
LAST_UPDATE_LOGIN NUMBER (15) Y
CONTEXT VARCHAR2 (30)
ATTRIBUTE1 VARCHAR2 (150)
ATTRIBUTE2 VARCHAR2 (150)
ATTRIBUTE3 VARCHAR2 (150)
ATTRIBUTE4 VARCHAR2 (150)
ATTRIBUTE5 VARCHAR2 (150)
ATTRIBUTE6 VARCHAR2 (150)
ATTRIBUTE7 VARCHAR2 (150)
ATTRIBUTE8 VARCHAR2 (150)
ATTRIBUTE9 VARCHAR2 (150)
ATTRIBUTE10 VARCHAR2 (150)
ATTRIBUTE11 VARCHAR2 (150)
ATTRIBUTE12 VARCHAR2 (150)
ATTRIBUTE13 VARCHAR2 (150)
ATTRIBUTE14 VARCHAR2 (150)
ATTRIBUTE15 VARCHAR2 (150)

[top of page]

APPS.RG_ROW_SEGMENT_SEQUENCES_V references the following:

APPS
SYNONYM - FND_ID_FLEX_SEGMENTS
SYNONYM - RG_ROW_ORDERS
SYNONYM - RG_ROW_SEGMENT_SEQUENCES

APPS.RG_ROW_SEGMENT_SEQUENCES_V is not referenced by any database object

[top of page]

View: RG_SRS_DSS_BUD_ENC_V

Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

Columns
Name Datatype Length Mandatory Comments
BUDGET_ENCUMBRANCE_NAME VARCHAR2 (80)
BUDGET_ENCUMBRANCE_ID NUMBER

LEDGER_ID NUMBER

SYSTEM_ID NUMBER

ACTUAL_FLAG CHAR (1)

[top of page]

APPS.RG_SRS_DSS_BUD_ENC_V references the following:

APPS
SYNONYM - GL_BUDGET_VERSIONS
SYNONYM - GL_ENCUMBRANCE_TYPES
SYNONYM - RG_DSS_SYSTEM_VARIABLES
SYNONYM - RG_DSS_VARIABLES
- GL_LOOKUPS

APPS.RG_SRS_DSS_BUD_ENC_V is not referenced by any database object

[top of page]

View: RG_SRS_DSS_DOP_V

Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

Columns
Name Datatype Length Mandatory Comments
DAY_NUM NUMBER

DAY_CHAR VARCHAR2 (80)

[top of page]

APPS.RG_SRS_DSS_DOP_V references the following:

APPS
SYNONYM - GL_ROW_MULTIPLIERS
- GL_LOOKUPS

APPS.RG_SRS_DSS_DOP_V is not referenced by any database object

[top of page]

View: RG_SRS_DSS_HIERARCHIES_V

Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

Columns
Name Datatype Length Mandatory Comments
NAME VARCHAR2 (80)
HIERARCHY_ID NUMBER

ID_FLEX_CODE VARCHAR2 (4)
ID_FLEX_NUM NUMBER

[top of page]

APPS.RG_SRS_DSS_HIERARCHIES_V references the following:

APPS
SYNONYM - RG_DSS_HIERARCHIES
- GL_LOOKUPS

APPS.RG_SRS_DSS_HIERARCHIES_V is not referenced by any database object

[top of page]

View: RG_SRS_DSS_TEMPLATE_V

Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

Columns
Name Datatype Length Mandatory Comments
TEMPLATE_NAME VARCHAR2 (80)
TEMPLATE_ID NUMBER

LEDGER_ID NUMBER

[top of page]

APPS.RG_SRS_DSS_TEMPLATE_V references the following:

APPS
SYNONYM - GL_SUMMARY_TEMPLATES
- GL_LOOKUPS

APPS.RG_SRS_DSS_TEMPLATE_V is not referenced by any database object

[top of page]

View: RG_XBRL_MAP_V

Comments
View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns
Name Datatype Length Mandatory Comments
SOURCE_TAX_ALIAS VARCHAR2 (240) Y Taxonomy alias including version
SOURCE_TAX_URL VARCHAR2 (240) Y Taxonomy Universal Resource Locator
SOURCE_TAXONOMY_ID NUMBER (15) Y Taxonomy defining column - Primary Key
ELEMENT_LABEL VARCHAR2 (240)
Taxonomy element label
ELEMENT_NAME VARCHAR2 (240) Y Taxonomy element name
ELEMENT_ID NUMBER (15) Y Element defining column
MAP_TAXONOMY_ID NUMBER (15) Y Taxonomy defining column

[top of page]

APPS.RG_XBRL_MAP_V references the following:

APPS
SYNONYM - RG_XBRL_ELEMENTS
SYNONYM - RG_XBRL_MAP_ELEMENTS
SYNONYM - RG_XBRL_TAXONOMIES

APPS.RG_XBRL_MAP_V is not referenced by any database object

[top of page]



Copyright (c) 2001 - 2005, Oracle - Use Restricted by Contract