[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:
-
APPS
-
OKI_TIME_ENT_YEAR_MV
-
FII
-
FII_TIME_DAY
APPS.OKI_TIME_ENT_YEAR_MV is referenced by following:
-
APPS
-
ISC_DBI_CFM_010_MV
-
ISC_DBI_CPM_001_MV
-
ISC_SAM_003_MV
-
OKI_SRM_018_MV
-
OKI_SRM_019_MV
-
OKI_SRM_020_MV
-
OKI_SRM_028_MV
-
OKI_SRM_029_MV
-
OKI_SRM_030_MV
-
OKI_SRM_038_MV
-
OKI_SRM_039_MV
-
OKI_SRM_040_MV