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

TABLE: FEM.FEM_ALLOC_BR_COND_SUM_GT

Object Details
Object Name: FEM_ALLOC_BR_COND_SUM_GT
Object Type: TABLE
Owner: FEM
FND Design Data: TableFEM.FEM_ALLOC_BR_COND_SUM_GT
Subobject Name:
Status: VALID

Stores condition descriptive information displayed by the Condition Summary pluggable region

Temporary Table Details

FEM.FEM_ALLOC_BR_COND_SUM_GT is a global temporary table. The current session is able see data that it placed in the table but other sessions cannot. Data in the table is temporary. It has a data duration of SYS$TRANSACTION. Data is removed at the end of this period.

Storage Details
Tablespace: Tablespace
PCT Free: 10
PCT Used: 40
Columns
Name Datatype Length Mandatory Comments
CONDITION_OBJ_DEF_ID NUMBER (9) Yes Identifies the object definition for the condition
TABLE_DISPLAY_NAME VARCHAR2 (150) Yes Translatable table for the condition component
COLUMN_DISPLAY_NAME VARCHAR2 (150) Yes Translatable column name for the condition component
CONDITION_TYPE VARCHAR2 (80) Yes Designates the type of condition component
HIER_ATTR_DISPLAY_NAME VARCHAR2 (150)
If the condition component is a hierarchy, this column stores the translatable column name; If it is an attribute component, it stores the translatable attribute name
CONDITION_VALUE VARCHAR2 (1000) Yes Stores the actual condition value for each component of the condition
COND_VALUE_ATTR_DATA_TYPE VARCHAR2 (30)
Query Text

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


SELECT CONDITION_OBJ_DEF_ID
,      TABLE_DISPLAY_NAME
,      COLUMN_DISPLAY_NAME
,      CONDITION_TYPE
,      HIER_ATTR_DISPLAY_NAME
,      CONDITION_VALUE
,      COND_VALUE_ATTR_DATA_TYPE
FROM FEM.FEM_ALLOC_BR_COND_SUM_GT;

Dependencies

[top of page]

FEM.FEM_ALLOC_BR_COND_SUM_GT does not reference any database object

FEM.FEM_ALLOC_BR_COND_SUM_GT is referenced by following:

SchemaAPPS
SynonymFEM_ALLOC_BR_COND_SUM_GT