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

MATERIALIZED VIEW: APPS.OKI_TIME_ENT_YEAR_MV

Object Details
Object Name: OKI_TIME_ENT_YEAR_MV
Object Type: MATERIALIZED VIEW
Owner: APPS
Subobject Name:
Status: VALID
M-View Details
Container: OKI_TIME_ENT_YEAR_MV
Updatable: N
Rewrite Enabled: N
Rewrite Capability: GENERAL
Refresh Mode: DEMAND
Refresh Method: FAST
Build Mode: DEFERRED
Fast Refreshable: DIRLOAD_DML
MV Log Dependencies:

FII_TIME_DAY

[View Source Query]

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 references the following:

SchemaAPPS
TableOKI_TIME_ENT_YEAR_MV
SchemaFII
TableFII_TIME_DAY
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