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

TABLE: FEM.FEM_TAB_COLUMNS_GT

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

Temporary Table Details

FEM.FEM_TAB_COLUMNS_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
TABLE_NAME VARCHAR2 (30) Yes
COLUMN_NAME VARCHAR2 (30) Yes
DISPLAY_NAME VARCHAR2 (150)
DESCRIPTION VARCHAR2 (255)
DATA_TYPE VARCHAR2 (30) Yes
DATA_LENGTH NUMBER

DATA_PRECISION NUMBER

CPM_DATATYPE VARCHAR2 (30) Yes
DIMENSION_ID NUMBER

DIMENSION_NAME VARCHAR2 (80)
UOM_COLUMN_NAME VARCHAR2 (30)
UOM_COL_DISPLAY_NAME VARCHAR2 (150)
SELECTED VARCHAR2 (1) Yes
DISABLE_FLAG VARCHAR2 (1) Yes
CPM_SWITCHER VARCHAR2 (30) Yes
DIM_SWITCHER VARCHAR2 (30) Yes
UOM_SWITCHER VARCHAR2 (30) Yes
ENABLED_FLAG VARCHAR2 (1) Yes
RESTRICTED_FLAG VARCHAR2 (1) Yes
UPDATE_FLAG VARCHAR2 (1) Yes
OBJECT_VERSION_NUMBER NUMBER
Yes
Query Text

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


SELECT TABLE_NAME
,      COLUMN_NAME
,      DISPLAY_NAME
,      DESCRIPTION
,      DATA_TYPE
,      DATA_LENGTH
,      DATA_PRECISION
,      CPM_DATATYPE
,      DIMENSION_ID
,      DIMENSION_NAME
,      UOM_COLUMN_NAME
,      UOM_COL_DISPLAY_NAME
,      SELECTED
,      DISABLE_FLAG
,      CPM_SWITCHER
,      DIM_SWITCHER
,      UOM_SWITCHER
,      ENABLED_FLAG
,      RESTRICTED_FLAG
,      UPDATE_FLAG
,      OBJECT_VERSION_NUMBER
FROM FEM.FEM_TAB_COLUMNS_GT;

Dependencies

[top of page]

FEM.FEM_TAB_COLUMNS_GT does not reference any database object

FEM.FEM_TAB_COLUMNS_GT is referenced by following:

SchemaAPPS
SynonymFEM_TAB_COLUMNS_GT