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.
Description: | Database link definitions |
---|
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.
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 |
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 |
RG.RG_DATABASE_LINKS does not reference any database object
RG.RG_DATABASE_LINKS is referenced by following:
Description: | Financial Analyzer dimensions |
---|
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 |
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Index | Type | Tablespace | Column |
---|---|---|---|
RG_DSS_DIMENSIONS_U1 | UNIQUE | APPS_TS_TX_IDX | DIMENSION_ID |
RG_DSS_DIMENSIONS_U2 | UNIQUE | APPS_TS_TX_IDX | NAME |
RG_DSS_DIMENSIONS_U3 | UNIQUE | APPS_TS_TX_IDX | OBJECT_NAME |
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 |
RG.RG_DSS_DIMENSIONS does not reference any database object
RG.RG_DSS_DIMENSIONS is referenced by following:
Description: | Financial Analyzer dimension segment mappings |
---|
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 |
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
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 |
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 |
RG.RG_DSS_DIM_SEGMENTS does not reference any database object
RG.RG_DSS_DIM_SEGMENTS is referenced by following:
Description: | Financial Analyzer hierarchies |
---|
Foreign Key Column | Foreign Table |
---|---|
RG_DSS_HIERARCHIES.DIMENSION_ID | RG_DSS_DIMENSIONS |
Foreign Key Column | Foreign Table |
---|---|
RG_DSS_HIERARCHY_DETAILS.HIERARCHY_ID | RG_DSS_HIERARCHIES |
RG_DSS_REQUESTS.HIERARCHY_ID | RG_DSS_HIERARCHIES |
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
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 |
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 |
RG.RG_DSS_HIERARCHIES does not reference any database object
RG.RG_DSS_HIERARCHIES is referenced by following:
Description: | Financial Analyzer hierarchy segment mappings |
---|
Foreign Key Column | Foreign Table |
---|---|
RG_DSS_HIERARCHY_DETAILS.HIERARCHY_ID | RG_DSS_HIERARCHIES |
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
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 |
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 |
RG.RG_DSS_HIERARCHY_DETAILS does not reference any database object
RG.RG_DSS_HIERARCHY_DETAILS is referenced by following:
Description: | Financial Analyzer extract/load request tracking |
---|
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 |
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.
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 |
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 |
RG.RG_DSS_REQUESTS does not reference any database object
RG.RG_DSS_REQUESTS is referenced by following:
Description: | Segment ranges for filters |
---|
Foreign Key Column | Foreign Table |
---|---|
RG_DSS_SEG_RANGES.RANGE_SET_ID | RG_DSS_SEG_RANGE_SETS |
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
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 |
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 |
RG.RG_DSS_SEG_RANGES does not reference any database object
RG.RG_DSS_SEG_RANGES is referenced by following:
Description: | Filters |
---|
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 |
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
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 |
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 |
RG.RG_DSS_SEG_RANGE_SETS does not reference any database object
RG.RG_DSS_SEG_RANGE_SETS is referenced by following:
Description: | Financial Analyzer financial data sets |
---|
Foreign Key Column | Foreign Table |
---|---|
RG_DSS_SYSTEMS.PERIOD_SET_NAME | GL_PERIOD_SETS |
Foreign Key Column | Foreign Table |
---|---|
RG_DSS_SYSTEM_SEG_ORDER.SYSTEM_ID | RG_DSS_SYSTEMS |
RG_DSS_SYSTEM_VARIABLES.SYSTEM_ID | RG_DSS_SYSTEMS |
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
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 |
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 |
RG.RG_DSS_SYSTEMS does not reference any database object
RG.RG_DSS_SYSTEMS is referenced by following:
Description: | Financial Analyzer financial data set segment sort order |
---|
Foreign Key Column | Foreign Table |
---|---|
RG_DSS_SYSTEM_SEG_ORDER.SYSTEM_ID | RG_DSS_SYSTEMS |
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
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 |
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 |
RG.RG_DSS_SYSTEM_SEG_ORDER does not reference any database object
RG.RG_DSS_SYSTEM_SEG_ORDER is referenced by following:
Description: | Assignments of financial data items to financial data sets |
---|
Foreign Key Column | Foreign Table |
---|---|
RG_DSS_SYSTEM_VARIABLES.SYSTEM_ID | RG_DSS_SYSTEMS |
RG_DSS_SYSTEM_VARIABLES.VARIABLE_ID | RG_DSS_VARIABLES |
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
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 |
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 |
RG.RG_DSS_SYSTEM_VARIABLES does not reference any database object
RG.RG_DSS_SYSTEM_VARIABLES is referenced by following:
Description: | Financial Analyzer financial data items |
---|
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 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 |
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
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 |
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 |
RG.RG_DSS_VARIABLES does not reference any database object
RG.RG_DSS_VARIABLES is referenced by following:
Description: | Financial Analyzer financial data item dimensions |
---|
Foreign Key Column | Foreign Table |
---|---|
RG_DSS_VAR_DIMENSIONS.VARIABLE_ID | RG_DSS_VARIABLES |
RG_DSS_VAR_DIMENSIONS.DIMENSION_ID | RG_DSS_DIMENSIONS |
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
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 |
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 |
RG.RG_DSS_VAR_DIMENSIONS does not reference any database object
RG.RG_DSS_VAR_DIMENSIONS is referenced by following:
Description: | Financial Analyzer financial data item selections |
---|
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 |
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
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 |
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 |
RG.RG_DSS_VAR_SELECTIONS does not reference any database object
RG.RG_DSS_VAR_SELECTIONS is referenced by following:
Description: | Financial Analyzer financial data item summary templates |
---|
Foreign Key Column | Foreign Table |
---|---|
RG_DSS_VAR_TEMPLATES.VARIABLE_ID | RG_DSS_VARIABLES |
RG_DSS_VAR_TEMPLATES.TEMPLATE_ID | GL_SUMMARY_TEMPLATES |
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Index | Type | Tablespace | Column |
---|---|---|---|
RG_DSS_VAR_TEMPLATES_N1 | NONUNIQUE | APPS_TS_TX_IDX | VARIABLE_ID |
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 |
RG.RG_DSS_VAR_TEMPLATES does not reference any database object
RG.RG_DSS_VAR_TEMPLATES is referenced by following:
Description: | Report definitions |
---|
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 Key Column | Foreign Table |
---|---|
RG_REPORT_REQUESTS.REPORT_ID | RG_REPORTS |
RG_REPORT_SET_REQ_DETAILS.REPORT_ID | RG_REPORTS |
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.
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 |
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 |
RG.RG_REPORTS does not reference any database object
RG.RG_REPORTS is referenced by following:
Description: | Row and column definitions |
---|
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 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 |
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.
Index | Type | Tablespace | Column |
---|---|---|---|
RG_REPORT_AXES_U1 | UNIQUE | APPS_TS_TX_IDX |
AXIS_SET_ID
AXIS_SEQ |
RG_REPORT_AXES_N1 | NONUNIQUE | APPS_TS_TX_IDX |
AXIS_NAME
AXIS_SET_ID |
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 |
RG.RG_REPORT_AXES does not reference any database object
RG.RG_REPORT_AXES is referenced by following:
Description: | Assignments of account ranges to rows and columns |
---|
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 |
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.
Index | Type | Tablespace | Column |
---|---|---|---|
RG_REPORT_AXIS_CONTENTS_N1 | NONUNIQUE | APPS_TS_TX_IDX |
AXIS_SET_ID
AXIS_SEQ |
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 |
RG.RG_REPORT_AXIS_CONTENTS does not reference any database object
RG.RG_REPORT_AXIS_CONTENTS is referenced by following:
Description: | Row and column set definitions |
---|
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 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 |
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.
Index | Type | Tablespace | Column |
---|---|---|---|
RG_REPORT_AXIS_SETS_U1 | UNIQUE | APPS_TS_TX_IDX | AXIS_SET_ID |
RG_REPORT_AXIS_SETS_U2 | UNIQUE | APPS_TS_TX_IDX |
NAME
AXIS_SET_TYPE APPLICATION_ID |
RG_REPORT_AXIS_SETS_N1 | NONUNIQUE | APPS_TS_TX_IDX | SEEDED_NAME |
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 | LONG | (0) | 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 |
RG.RG_REPORT_AXIS_SETS does not reference any database object
RG.RG_REPORT_AXIS_SETS is referenced by following:
Description: | Calculations defined for rows and columns |
---|
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 |
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.
Index | Type | Tablespace | Column |
---|---|---|---|
RG_REPORT_CALCULATIONS_N1 | NONUNIQUE | APPS_TS_TX_IDX |
AXIS_SET_ID
AXIS_SEQ |
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 |
RG.RG_REPORT_CALCULATIONS does not reference any database object
RG.RG_REPORT_CALCULATIONS is referenced by following:
Description: | Assignments of account ranges to content sets |
---|
Foreign Key Column | Foreign Table |
---|---|
RG_REPORT_CONTENT_OVERRIDES.CONTENT_SET_ID | RG_REPORT_CONTENT_SETS |
RG_REPORT_CONTENT_OVERRIDES.LEDGER_ID | GL_LEDGERS |
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.
Index | Type | Tablespace | Column |
---|---|---|---|
RG_REPORT_CONTENT_OVERRIDES_U1 | UNIQUE | APPS_TS_TX_IDX |
CONTENT_SET_ID
OVERRIDE_SEQ |
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 |
RG.RG_REPORT_CONTENT_OVERRIDES does not reference any database object
RG.RG_REPORT_CONTENT_OVERRIDES is referenced by following:
Description: | Content set definitions |
---|
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 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 |
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.
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 |
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 |
RG.RG_REPORT_CONTENT_SETS does not reference any database object
RG.RG_REPORT_CONTENT_SETS is referenced by following:
Description: | Assignments of report display groups to report display sets |
---|
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 |
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.
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 |
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 |
RG.RG_REPORT_DISPLAYS does not reference any database object
RG.RG_REPORT_DISPLAYS is referenced by following:
Description: | Report display group definitions |
---|
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 Key Column | Foreign Table |
---|---|
RG_REPORT_DISPLAYS.ROW_GROUP_ID | RG_REPORT_DISPLAY_GROUPS |
RG_REPORT_DISPLAYS.COLUMN_GROUP_ID | RG_REPORT_DISPLAY_GROUPS |
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.
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 |
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 |
RG.RG_REPORT_DISPLAY_GROUPS does not reference any database object
RG.RG_REPORT_DISPLAY_GROUPS is referenced by following:
Description: | Report display set definitions |
---|
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 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 |
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.
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 |
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 |
RG.RG_REPORT_DISPLAY_SETS does not reference any database object
RG.RG_REPORT_DISPLAY_SETS is referenced by following:
Description: | Exception conditions for columns |
---|
Foreign Key Column | Foreign Table |
---|---|
RG_REPORT_EXCEPTIONS.AXIS_SET_ID
RG_REPORT_EXCEPTIONS.AXIS_SEQ |
RG_REPORT_AXES |
Foreign Key Column | Foreign Table |
---|---|
RG_REPORT_EXCEPTION_FLAGS.EXCEPTION_ID | RG_REPORT_EXCEPTIONS |
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. .
Index | Type | Tablespace | Column |
---|---|---|---|
RG_REPORT_EXCEPTIONS_N1 | NONUNIQUE | APPS_TS_TX_IDX |
EXCEPTION_ID
AXIS_SET_ID AXIS_SEQ |
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 |
RG.RG_REPORT_EXCEPTIONS does not reference any database object
RG.RG_REPORT_EXCEPTIONS is referenced by following:
Description: | Symbols used to indicate exceptions |
---|
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 |
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.
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 |
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 |
RG.RG_REPORT_EXCEPTION_FLAGS does not reference any database object
RG.RG_REPORT_EXCEPTION_FLAGS is referenced by following:
Description: | Assignments of budgets, encumbrances, and currencies to reports |
---|
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 |
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.
Index | Type | Tablespace | Column |
---|---|---|---|
RG_REPORT_PARAMETERS_U1 | UNIQUE | APPS_TS_TX_IDX |
PARAMETER_SET_ID
DATA_TYPE PARAMETER_NUM |
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 |
RG.RG_REPORT_PARAMETERS does not reference any database object
RG.RG_REPORT_PARAMETERS is referenced by following:
Description: | Report request tracking and assignments of reports to report sets |
---|
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 |
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.
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 |
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 |
RG.RG_REPORT_REQUESTS does not reference any database object
RG.RG_REPORT_REQUESTS is referenced by following:
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 |
---|
Foreign Key Column | Foreign Table |
---|---|
RG_REPORT_REQUEST_LOBS.REQUEST_ID | FND_CONCURRENT_REQUESTS |
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
Index | Type | Tablespace | Column |
---|---|---|---|
RG_REPORT_REQUEST_LOBS_U1 | UNIQUE | APPS_TS_TX_IDX | REQUEST_ID |
SYS_IL0000457992C00002$$ | UNIQUE | APPS_TS_TX_DATA |
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 |
RG.RG_REPORT_REQUEST_LOBS does not reference any database object
RG.RG_REPORT_REQUEST_LOBS is referenced by following:
Description: | Report set definitions |
---|
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 Key Column | Foreign Table |
---|---|
RG_REPORT_REQUESTS.REPORT_SET_ID | RG_REPORT_SETS |
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.
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 |
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 |
RG.RG_REPORT_SETS does not reference any database object
RG.RG_REPORT_SETS is referenced by following:
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 |
---|
Foreign Key Column | Foreign Table |
---|---|
RG_REPORT_SET_REQUESTS.UNIT_OF_MEASURE_ID | FND_CURRENCIES |
Foreign Key Column | Foreign Table |
---|---|
RG_REPORT_SET_REQ_DETAILS.REPORT_SET_REQUEST_ID | RG_REPORT_SET_REQUESTS |
Report set submission tracking
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 |
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 |
RG.RG_REPORT_SET_REQUESTS does not reference any database object
RG.RG_REPORT_SET_REQUESTS is referenced by following:
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. |
---|
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 |
Report set details submission tracking
Index | Type | Tablespace | Column |
---|---|---|---|
RG_REPORT_SET_REQ_DETAILS_U1 | UNIQUE | APPS_TS_TX_IDX |
REPORT_SET_REQUEST_ID
SEQUENCE |
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 |
RG.RG_REPORT_SET_REQ_DETAILS does not reference any database object
RG.RG_REPORT_SET_REQ_DETAILS is referenced by following:
Description: | Amount types used in rows and columns |
---|
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 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 |
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.
Index | Type | Tablespace | Column |
---|---|---|---|
RG_REPORT_STANDARD_AXES_B_U1 | UNIQUE | APPS_TS_SEED | STANDARD_AXIS_ID |
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 | LONG | (0) | 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 |
RG.RG_REPORT_STANDARD_AXES_B does not reference any database object
RG.RG_REPORT_STANDARD_AXES_B is referenced by following:
Description: | Translations for RG_REPORT_STANDARD_AXES |
---|
Foreign Key Column | Foreign Table |
---|---|
RG_REPORT_STANDARD_AXES_TL.STANDARD_AXIS_ID | RG_REPORT_STANDARD_AXES_B |
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.
Index | Type | Tablespace | Column |
---|---|---|---|
RG_REPORT_STANDARD_AXES_TL_U1 | UNIQUE | APPS_TS_SEED |
STANDARD_AXIS_ID
LANGUAGE |
RG_REPORT_STANDARD_AXES_TL_U2 | UNIQUE | APPS_TS_SEED |
STANDARD_AXIS_NAME
LANGUAGE |
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 |
RG.RG_REPORT_STANDARD_AXES_TL does not reference any database object
RG.RG_REPORT_STANDARD_AXES_TL is referenced by following:
Description: | Sub request information for parallel content sets |
---|
Foreign Key Column | Foreign Table |
---|---|
RG_REPORT_SUB_REQUEST_RUNS.REQUEST_ID | FND_CONCURRENT_REQUESTS |
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.
Index | Type | Tablespace | Column |
---|---|---|---|
RG_REPORT_SUB_REQUEST_RUNS_N1 | NONUNIQUE | APPS_TS_TX_IDX | SUB_REQUEST_RUN_ID |
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 |
RG.RG_REPORT_SUB_REQUEST_RUNS does not reference any database object
RG.RG_REPORT_SUB_REQUEST_RUNS is referenced by following:
Description: | Row order definitions |
---|
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 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 |
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.
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 |
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 |
RG.RG_ROW_ORDERS does not reference any database object
RG.RG_ROW_ORDERS is referenced by following:
Description: | Assignments of segments to row orders |
---|
Foreign Key Column | Foreign Table |
---|---|
RG_ROW_SEGMENT_SEQUENCES.ROW_ORDER_ID | RG_ROW_ORDERS |
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.
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 |
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 |
RG.RG_ROW_SEGMENT_SEQUENCES does not reference any database object
RG.RG_ROW_SEGMENT_SEQUENCES is referenced by following:
Description: | Query information for specific amount types |
---|
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.
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 |
RG.RG_SIMPLE_WHERE_CLAUSES does not reference any database object
RG.RG_SIMPLE_WHERE_CLAUSES is referenced by following:
Description: | Sizes of selected Oracle General Ledger tables |
---|
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.
Index | Type | Tablespace | Column |
---|---|---|---|
RG_TABLE_SIZES_U1 | UNIQUE | APPS_TS_TX_IDX | TABLE_ID |
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 |
RG.RG_TABLE_SIZES does not reference any database object
RG.RG_TABLE_SIZES is referenced by following:
Description: |
---|
Foreign Key Column | Foreign Table |
---|---|
RG_XBRL_ELEMENTS.TAXONOMY_ID | RG_XBRL_TAXONOMIES |
Foreign Key Column | Foreign Table |
---|---|
RG_REPORT_AXES.ELEMENT_ID | RG_XBRL_ELEMENTS |
RG_XBRL_MAP_ELEMENTS.ELEMENT_ID | RG_XBRL_ELEMENTS |
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
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 |
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 |
RG.RG_XBRL_ELEMENTS does not reference any database object
RG.RG_XBRL_ELEMENTS is referenced by following:
Description: | Elements mapped to taxonomy |
---|
Foreign Key Column | Foreign Table |
---|---|
RG_XBRL_MAP_ELEMENTS.TAXONOMY_ID | RG_XBRL_TAXONOMIES |
RG_XBRL_MAP_ELEMENTS.ELEMENT_ID | RG_XBRL_ELEMENTS |
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Index | Type | Tablespace | Column |
---|---|---|---|
RG_XBRL_MAP_ELEMENTS_U1 | UNIQUE | APPS_TS_TX_IDX |
TAXONOMY_ID
ELEMENT_ID |
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 |
RG.RG_XBRL_MAP_ELEMENTS does not reference any database object
RG.RG_XBRL_MAP_ELEMENTS is referenced by following:
Description: |
---|
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 |
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
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 |
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. |
RG.RG_XBRL_TAXONOMIES does not reference any database object
RG.RG_XBRL_TAXONOMIES is referenced by following:
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.
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) |
APPS.RG_BUDGETS_V is not referenced by any database object
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Internal
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) |
APPS.RG_CONSTANT_PERIODS_V is not referenced by any database object
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.
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) |
APPS.RG_CURRENCIES_V is not referenced by any database object
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.
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) |
APPS.RG_DSS_DIM_SEGMENTS_V is not referenced by any database object
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.
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) |
APPS.RG_DSS_HIERARCHIES_V is not referenced by any database object
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.
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) |
APPS.RG_DSS_HIERARCHY_DETAILS_V is not referenced by any database object
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.
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 |
APPS.RG_DSS_REQUESTS_V is not referenced by any database object
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.
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) |
APPS.RG_DSS_SEG_RANGE_SETS_V is not referenced by any database object
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.
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) |
APPS.RG_DSS_SYSTEM_SEG_ORDER_V is not referenced by any database object
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.
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) |
APPS.RG_DSS_SYSTEM_VARIABLES_V is not referenced by any database object
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.
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) |
APPS.RG_DSS_VARIABLES_V is not referenced by any database object
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.
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) |
APPS.RG_DSS_VAR_DIMENSIONS_V is not referenced by any database object
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.
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) |
APPS.RG_DSS_VAR_SELECTIONS_V is not referenced by any database object
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.
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) |
APPS.RG_DSS_VAR_TEMPLATES_V is not referenced by any database object
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.
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) |
APPS.RG_ENCUMBRANCES_V is not referenced by any database object
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.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
DISPLAY_UNITS | VARCHAR2 | (30) | Y | |
FACTOR | VARCHAR2 | (80) | Y |
APPS.RG_FACTOR_V is not referenced by any database object
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.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
DISPLAY_LEVEL | VARCHAR2 | (30) | Y | |
LEVEL_OF_DETAIL | VARCHAR2 | (80) | Y |
APPS.RG_LEVEL_OF_DETAIL_V is not referenced by any database object
MultiLingual view (a language resolved view of the data.)
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 |
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.
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 |
APPS.RG_PERIOD_YEARS_V is not referenced by any database object
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.
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) |
APPS.RG_REPORTS_V is not referenced by any database object
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.
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) |
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Internal
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) |
APPS.RG_REPORT_AXIS_SETS_LOV_V is not referenced by any database object
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.
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 | LONG | (0) | ||
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) |
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.
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) |
APPS.RG_REPORT_DISPLAYS_V is not referenced by any database object
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.
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) |
APPS.RG_REPORT_DISPLAY_GROUPS_V is not referenced by any database object
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.
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) |
APPS.RG_REPORT_DISPLAY_SETS_V is not referenced by any database object
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.
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) |
APPS.RG_REPORT_NAME_V is not referenced by any database object
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.
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) |
APPS.RG_REPORT_REQUESTS_V is not referenced by any database object
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.
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) |
APPS.RG_REPORT_SET_NAME_V is not referenced by any database object
MultiLingual view (a language resolved view of the data.)
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 | LONG | (0) | 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 |
APPS.RG_REPORT_STANDARD_AXES_VL is not referenced by any database object
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.
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) |
APPS.RG_ROW_SEGMENT_SEQUENCES_V is not referenced by any database object
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
BUDGET_ENCUMBRANCE_NAME | VARCHAR2 | (80) | ||
BUDGET_ENCUMBRANCE_ID | NUMBER | |||
LEDGER_ID | NUMBER | |||
SYSTEM_ID | NUMBER | |||
ACTUAL_FLAG | CHAR | (1) |
APPS.RG_SRS_DSS_BUD_ENC_V is not referenced by any database object
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
DAY_NUM | NUMBER | |||
DAY_CHAR | VARCHAR2 | (80) |
APPS.RG_SRS_DSS_DOP_V is not referenced by any database object
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
NAME | VARCHAR2 | (80) | ||
HIERARCHY_ID | NUMBER | |||
ID_FLEX_CODE | VARCHAR2 | (4) | ||
ID_FLEX_NUM | NUMBER |
APPS.RG_SRS_DSS_HIERARCHIES_V is not referenced by any database object
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TEMPLATE_NAME | VARCHAR2 | (80) | ||
TEMPLATE_ID | NUMBER | |||
LEDGER_ID | NUMBER |
APPS.RG_SRS_DSS_TEMPLATE_V is not referenced by any database object
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.
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 |
|
|
Copyright (c) 2001 - 2005, Oracle | - Use Restricted by Contract |