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

MATERIALIZED VIEW: APPS.ASO_BI_QOT_RULB_MV

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

ASO_BI_APR_RUL_F
FII_TIME_DAY

[View Source Query]

Columns
Name Datatype Length Mandatory Comments
UMARKER CHAR (6)
Marker for fast refreshability purpose
RESOURCE_GRP_ID NUMBER

Resource group id
RESOURCE_ID NUMBER

Resource id
OAM_RULE_ID NUMBER

Approval rule id
OPEN NUMBER

Open approval count
NEW NUMBER

New approvals count
DAY_ID NUMBER

Day id
WEEK_ID NUMBER

Week id
ENT_PERIOD_ID NUMBER

Period id
ENT_QTR_ID NUMBER

Quarter id
ENT_YEAR_ID NUMBER

Year id
Query Text

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


SELECT UMARKER
,      RESOURCE_GRP_ID
,      RESOURCE_ID
,      OAM_RULE_ID
,      OPEN
,      NEW
,      DAY_ID
,      WEEK_ID
,      ENT_PERIOD_ID
,      ENT_QTR_ID
,      ENT_YEAR_ID
FROM APPS.ASO_BI_QOT_RULB_MV;

Dependencies

[top of page]

APPS.ASO_BI_QOT_RULB_MV references the following:

SchemaAPPS
TableASO_BI_QOT_RULB_MV
SchemaASO
TableASO_BI_APR_RUL_F
SchemaFII
TableFII_TIME_DAY
APPS.ASO_BI_QOT_RULB_MV is referenced by following:

SchemaAPPS
Materialized ViewASO_BI_QOT_RUL_MV