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

TABLE: FEM.FEM_ALLOC_BR_FCTR_SUM_GT

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

Stores Factor Table descriptive information displayed by the Factor Table Details pluggable region

Temporary Table Details

FEM.FEM_ALLOC_BR_FCTR_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
FACTOR_OBJ_DEF_ID NUMBER (9) Yes Identifies the object definition for the Factor Table Rule
MATCHING_DIMENSION_NAME VARCHAR2 (150) Yes Translatable name for the matching dimension
HIERARCHY_NAME VARCHAR2 (150)
Translatable name for the hierarchy
DIMENSION_GROUP_NAME VARCHAR2 (150)
Translable name from the hierarchy level
HIER_RELATION_DESC VARCHAR2 (150)
Translatable text that describes how the factor table uses the hierarchy level
Query Text

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


SELECT FACTOR_OBJ_DEF_ID
,      MATCHING_DIMENSION_NAME
,      HIERARCHY_NAME
,      DIMENSION_GROUP_NAME
,      HIER_RELATION_DESC
FROM FEM.FEM_ALLOC_BR_FCTR_SUM_GT;

Dependencies

[top of page]

FEM.FEM_ALLOC_BR_FCTR_SUM_GT does not reference any database object

FEM.FEM_ALLOC_BR_FCTR_SUM_GT is referenced by following:

SchemaAPPS
SynonymFEM_ALLOC_BR_FCTR_SUM_GT