eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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:	RG.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:	APPS_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:

RG: RG_SIMPLE_WHERE_CLAUSES#