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

TABLE: FEM.FEM_INTG_CALENDAR_MAP

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

Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
FEM_INTG_CALENDAR_MAP_U1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPERIOD_SET_NAME
ColumnPERIOD_TYPE
Columns
Name Datatype Length Mandatory Comments
PERIOD_SET_NAME VARCHAR2 (15) Yes Accounting calendar name
PERIOD_TYPE VARCHAR2 (15) Yes Accounting period type name
CAL_PER_HIER_OBJ_DEF_ID NUMBER (9) Yes Calendar Period hierarchy identifier
DIMENSION_GROUP_ID NUMBER (9) Yes Dimension group identifier
CALENDAR_ID NUMBER (5) Yes Calendar identifier
EFFECTIVE_PERIOD_NUM_MIN NUMBER (15)
Denormalized minimum processed period number (period_year*10000 + period_num)
EFFECTIVE_PERIOD_NUM_MAX NUMBER (15)
Denormalized maximum processed period number (period_year*10000 + period_num)
CREATION_DATE DATE
Yes Standard who column
CREATED_BY NUMBER (15) Yes Standard who column
LAST_UPDATE_DATE DATE
Yes Standard who column
LAST_UPDATED_BY NUMBER (15) Yes Standard who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column
Query Text

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


SELECT PERIOD_SET_NAME
,      PERIOD_TYPE
,      CAL_PER_HIER_OBJ_DEF_ID
,      DIMENSION_GROUP_ID
,      CALENDAR_ID
,      EFFECTIVE_PERIOD_NUM_MIN
,      EFFECTIVE_PERIOD_NUM_MAX
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
FROM FEM.FEM_INTG_CALENDAR_MAP;

Dependencies

[top of page]

FEM.FEM_INTG_CALENDAR_MAP does not reference any database object

FEM.FEM_INTG_CALENDAR_MAP is referenced by following:

SchemaAPPS
SynonymFEM_INTG_CALENDAR_MAP