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


TABLE: APPS.OKI_TIME_ENT_YEAR_MV

Object Details
Object Name: OKI_TIME_ENT_YEAR_MV
Object Type: TABLE
Owner: APPS
FND Design Data: TableFND.OKI_TIME_ENT_YEAR_MV
Subobject Name:
Status: VALID
Storage Details
Tablespace: TablespaceAPPS_TS_SUMMARY
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
I_SNAP$_OKI_TIME_ENT_YEAR_ FUNCTION-BASED NORMAL UNIQUE TablespaceAPPS_TS_SUMMARY ColumnSYS_OP_MAP_NONNULL("ENT_YEAR_ID")
ColumnSYS_OP_MAP_NONNULL("START_DATE")
ColumnSYS_OP_MAP_NONNULL("END_DATE")
OKI_TIME_ENT_YEAR_MV_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_SUMMARY ColumnSTART_DATE
ColumnEND_DATE
OKI_TIME_ENT_YEAR_MV_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_SUMMARY ColumnENT_YEAR_ID
Columns
Name Datatype Length Mandatory Comments
ENT_YEAR_ID NUMBER

Enterprise Year dentifier
START_DATE DATE

Enterprise Year Start Date
END_DATE DATE

Enterprise Year End Date
C_COUNT NUMBER

Row Count
Query Text

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


SELECT ENT_YEAR_ID
,      START_DATE
,      END_DATE
,      C_COUNT
FROM APPS.OKI_TIME_ENT_YEAR_MV;

Dependencies

[top of page]

APPS.OKI_TIME_ENT_YEAR_MV does not reference any database object

APPS.OKI_TIME_ENT_YEAR_MV is referenced by following:

SchemaAPPS
Materialized ViewISC_DBI_CFM_010_MV
Materialized ViewISC_DBI_CPM_001_MV
Materialized ViewISC_SAM_003_MV
Materialized ViewOKI_SRM_018_MV
Materialized ViewOKI_SRM_019_MV
Materialized ViewOKI_SRM_020_MV
Materialized ViewOKI_SRM_028_MV
Materialized ViewOKI_SRM_029_MV
Materialized ViewOKI_SRM_030_MV
Materialized ViewOKI_SRM_038_MV
Materialized ViewOKI_SRM_039_MV
Materialized ViewOKI_SRM_040_MV
Materialized ViewOKI_TIME_ENT_YEAR_MV