[Home] [Help] [Dependency Information]

TABLE: FEM.FEM_LD_INTERFACE_DATA_GT

Object Details

Object Name:	FEM_LD_INTERFACE_DATA_GT
Object Type:	TABLE
Owner:	FEM
FND Design Data:	FEM.FEM_LD_INTERFACE_DATA_GT
Subobject Name:
Status:	VALID

Temporary Table Details

FEM.FEM_LD_INTERFACE_DATA_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$SESSION. Data is removed at the end of this period.

Storage Details

Tablespace:
PCT Free:	10
PCT Used:	40

Indexes

Index	Type	Uniqueness	Tablespace	Column
FEM_LD_INTERFACE_DATA_GT_N1	NORMAL	NONUNIQUE		TABLE_NAME TABLE_ROW
FEM_LD_INTERFACE_DATA_GT_N2	NORMAL	NONUNIQUE		STATUS
FEM_LD_INTERFACE_DATA_GT_N3	NORMAL	NONUNIQUE		DS_PRODUCTION_VALID_FLAG
FEM_LD_INTERFACE_DATA_GT_N4	NORMAL	NONUNIQUE		LEDGER_ID
FEM_LD_INTERFACE_DATA_GT_N5	NORMAL	NONUNIQUE		DATASET_CODE
FEM_LD_INTERFACE_DATA_GT_N6	NORMAL	NONUNIQUE		LEDGER_DISPLAY_CODE DATASET_DISPLAY_CODE SOURCE_SYSTEM_DISPLAY_CODE
FEM_LD_INTERFACE_DATA_GT_N7	NORMAL	NONUNIQUE		CAL_PERIOD_LEVEL
FEM_LD_INTERFACE_DATA_GT_N8	NORMAL	NONUNIQUE		DIMENSION_GROUP_ID LEDGER_ID CAL_PERIOD

Columns

Query Text

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

SELECT LEDGER_DISPLAY_CODE
,      DATASET_DISPLAY_CODE
,      SOURCE_SYSTEM_DISPLAY_CODE
,      LEDGER_ID
,      DATASET_CODE
,      SOURCE_SYSTEM_CODE
,      CAL_PERIOD_NUMBER
,      CAL_PERIOD_LEVEL
,      CAL_PERIOD_END_DATE
,      TABLE_NAME
,      TABLE_ROW
,      CALENDAR_ID
,      CAL_PERIOD
,      DIMENSION_GROUP_ID
,      TIME_DIMENSION_GROUP_KEY
,      BUDGET_ID
,      BUDGET_DISPLAY_CODE
,      BALANCE_TYPE_CODE
,      ENCUMBRANCE_TYPE_ID
,      ENCUMBRANCE_TYPE_CODE
,      DS_PRODUCTION_VALID_FLAG
,      STATUS
FROM FEM.FEM_LD_INTERFACE_DATA_GT;

Dependencies

[top of page]

FEM.FEM_LD_INTERFACE_DATA_GT does not reference any database object

FEM.FEM_LD_INTERFACE_DATA_GT is referenced by following:

APPS

FEM_LD_INTERFACE_DATA_GT