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


TABLE: RG.RG_SIMPLE_WHERE_CLAUSES

Object Details
Object Name: RG_SIMPLE_WHERE_CLAUSES
Object Type: TABLE
Owner: RG
FND Design Data: TableRG.RG_SIMPLE_WHERE_CLAUSES
Subobject Name:
Status: VALID


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.


Storage Details
Tablespace: TablespaceAPPS_TS_SEED
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
SIMPLE_WHERE_NAME VARCHAR2 (30) Yes Name of where clause used to load seeded amount types
WHERE_COLUMN VARCHAR2 (30) Yes Name of column this where clause is defined on
WHERE_VALUE VARCHAR2 (240) Yes Value of the where column that the where clause is created with
Query Text

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


SELECT SIMPLE_WHERE_NAME
,      WHERE_COLUMN
,      WHERE_VALUE
FROM RG.RG_SIMPLE_WHERE_CLAUSES;

Dependencies

[top of page]

RG.RG_SIMPLE_WHERE_CLAUSES does not reference any database object

RG.RG_SIMPLE_WHERE_CLAUSES is referenced by following:

SchemaRG
ViewRG_SIMPLE_WHERE_CLAUSES#