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

MATERIALIZED VIEW: APPS.OKI_SRM_019_MV

Object Details
Object Name: OKI_SRM_019_MV
Object Type: MATERIALIZED VIEW
Owner: APPS
Subobject Name:
Status: VALID
M-View Details
Container: OKI_SRM_019_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_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 CHAR (8)
AUTHORING_ORG_ID NUMBER

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

B_R_AMT_F NUMBER

B_R_AMT_G NUMBER

B_R_AMT_SG NUMBER

B_R_AMT_A NUMBER

C_B_R_AMT_F NUMBER

C_B_R_AMT_G NUMBER

C_B_R_AMT_SG NUMBER

C_B_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
,      B_R_AMT_F
,      B_R_AMT_G
,      B_R_AMT_SG
,      B_R_AMT_A
,      C_B_R_AMT_F
,      C_B_R_AMT_G
,      C_B_R_AMT_SG
,      C_B_R_AMT_A
,      C_TOTAL
FROM APPS.OKI_SRM_019_MV;

Dependencies

[top of page]

APPS.OKI_SRM_019_MV references the following:

SchemaAPPS
TableOKI_SRM_001_MV
Materialized ViewOKI_SRM_001_MV
TableOKI_SRM_019_MV
Materialized ViewOKI_TIME_ENT_YEAR_MV
TableOKI_TIME_ENT_YEAR_MV

APPS.OKI_SRM_019_MV is not referenced by any database object