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

MATERIALIZED VIEW: APPS.OKI_BI_GRP_CNT_MV

Object Details
Object Name: OKI_BI_GRP_CNT_MV
Object Type: MATERIALIZED VIEW
Owner: APPS
Subobject Name:
Status: VALID
M-View Details
Container: OKI_BI_GRP_CNT_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:

JTF_RS_GROUPS_DENORM
JTF_RS_GROUP_USAGES

[View Source Query]

Columns
Name Datatype Length Mandatory Comments
GCOUNT NUMBER

Row Count
SALES_GROUP_ID NUMBER
Yes JTF RESOURCE GROUP Identifier
Query Text

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


SELECT GCOUNT
,      SALES_GROUP_ID
FROM APPS.OKI_BI_GRP_CNT_MV;

Dependencies

[top of page]

APPS.OKI_BI_GRP_CNT_MV references the following:

SchemaAPPS
TableOKI_BI_GRP_CNT_MV
SchemaJTF
TableJTF_RS_GROUPS_DENORM
TableJTF_RS_GROUP_USAGES
APPS.OKI_BI_GRP_CNT_MV is referenced by following:

SchemaAPPS
Materialized ViewOKI_RS_GROUP_MV