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

MATERIALIZED VIEW: APPS.OKI_SRM_030_MV

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

OKI_SRM_002_MV
     OKI_RS_GROUP_MV
          JTF_RS_GROUPS_DENORM
          JTF_RS_GROUP_USAGES
          OKI_BI_GRP_CNT_MV
               JTF_RS_GROUPS_DENORM
               JTF_RS_GROUP_USAGES
     OKI_SRM_001_MV
          ENI_OLTP_ITEM_STAR
          FII_PARTY_MKT_CLASS
          OKI_DBI_CLE_B
OKI_TIME_ENT_YEAR_MV
     FII_TIME_DAY

[View Source Query]

Columns
Name Datatype Length Mandatory Comments
UMARKER VARCHAR2 (9)
AUTHORING_ORG_ID NUMBER
Yes
RG_ID NUMBER

PRG_ID NUMBER

RESOURCE_ID NUMBER

SERVICE_ITEM_ORG_ID VARCHAR2 (81)
SERVICE_ITEM_CATEGORY_ID NUMBER

GRP_ID NUMBER

ENT_YEAR_ID NUMBER

O_R_AMT_F NUMBER

O_R_AMT_G NUMBER

O_R_AMT_SG NUMBER

O_R_AMT_A NUMBER

C_O_R_AMT_F NUMBER

C_O_R_AMT_G NUMBER

C_O_R_AMT_SG NUMBER

C_O_R_AMT_A NUMBER

C_TOTAL NUMBER

Query Text

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


SELECT UMARKER
,      AUTHORING_ORG_ID
,      RG_ID
,      PRG_ID
,      RESOURCE_ID
,      SERVICE_ITEM_ORG_ID
,      SERVICE_ITEM_CATEGORY_ID
,      GRP_ID
,      ENT_YEAR_ID
,      O_R_AMT_F
,      O_R_AMT_G
,      O_R_AMT_SG
,      O_R_AMT_A
,      C_O_R_AMT_F
,      C_O_R_AMT_G
,      C_O_R_AMT_SG
,      C_O_R_AMT_A
,      C_TOTAL
FROM APPS.OKI_SRM_030_MV;

Dependencies

[top of page]

APPS.OKI_SRM_030_MV references the following:

SchemaAPPS
Materialized ViewOKI_SRM_002_MV
TableOKI_SRM_002_MV
TableOKI_SRM_030_MV
TableOKI_TIME_ENT_YEAR_MV
Materialized ViewOKI_TIME_ENT_YEAR_MV

APPS.OKI_SRM_030_MV is not referenced by any database object