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

MATERIALIZED VIEW: APPS.ASO_BI_DISC_BUK_MV

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

BIS_BUCKET
BIS_BUCKET_CUSTOMIZATIONS

[View Source Query]

Columns
Name Datatype Length Mandatory Comments
R ROWID (10)
Rowid for fast refreshability purpose
C ROWID (10)
Rowid for fast refreshability purpose
MARK VARCHAR2 (2)
To identify mark
LOW NUMBER

Low range of bucket
HIGH NUMBER

High range of bucket
SHORT_NAME VARCHAR2 (30)
Short name of the range
BUCKET_ID NUMBER

Bucket id
Query Text

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


SELECT R
,      C
,      MARK
,      LOW
,      HIGH
,      SHORT_NAME
,      BUCKET_ID
FROM APPS.ASO_BI_DISC_BUK_MV;

Dependencies

[top of page]

APPS.ASO_BI_DISC_BUK_MV references the following:

SchemaAPPS
TableASO_BI_DISC_BUK_MV
SchemaBIS
TableBIS_BUCKET
TableBIS_BUCKET_CUSTOMIZATIONS
APPS.ASO_BI_DISC_BUK_MV is referenced by following:

SchemaAPPS
Materialized ViewASO_BI_QOT_DISCB_MV