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

MATERIALIZED VIEW: APPS.ASO_BI_RSG_PRNT_MV

Object Details
Object Name: ASO_BI_RSG_PRNT_MV
Object Type: MATERIALIZED VIEW
Owner: APPS
Subobject Name:
Status: VALID
M-View Details
Container: ASO_BI_RSG_PRNT_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_TOP_RSG_MV
     JTF_RS_GROUPS_DENORM
     JTF_RS_GROUP_USAGES
JTF_RS_GROUPS_DENORM
JTF_RS_GROUP_USAGES

[View Source Query]

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

Parent group id of the sales group mentioned in the group_id column
GROUP_ID NUMBER

Sales group id
XCNT NUMBER

For fast refreshability purpose
Query Text

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


SELECT UMARKER
,      PARENT_GROUP_ID
,      GROUP_ID
,      XCNT
FROM APPS.ASO_BI_RSG_PRNT_MV;

Dependencies

[top of page]

APPS.ASO_BI_RSG_PRNT_MV references the following:

SchemaAPPS
TableASO_BI_RSG_PRNT_MV
TableASO_BI_TOP_RSG_MV
Materialized ViewASO_BI_TOP_RSG_MV
SchemaJTF
TableJTF_RS_GROUPS_DENORM
TableJTF_RS_GROUP_USAGES
APPS.ASO_BI_RSG_PRNT_MV is referenced by following:

SchemaAPPS
Materialized ViewASO_BI_QOT_APR_MV
Materialized ViewASO_BI_QOT_RUL_MV
Materialized ViewASO_BI_QOT_SG_MV