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

MATERIALIZED VIEW: APPS.BIL_BI_RS_GRP_MV

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

BIL_BI_GRP_CNT_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 (10)
Required for MVs using Union All for fast refreshability.
PARENT_PARENT_GROUP_ID NUMBER

Immediate parent of Parent_group_id, null for the top group.
PARENT_GROUP_ID NUMBER

Parent Sales group identifier, of the sales group identifier
SALES_GROUP_ID NUMBER

Sales group identifier.
XCNT NUMBER

Dummy count columns required to create fast refresh MV.
Query Text

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


SELECT UMARKER
,      PARENT_PARENT_GROUP_ID
,      PARENT_GROUP_ID
,      SALES_GROUP_ID
,      XCNT
FROM APPS.BIL_BI_RS_GRP_MV;

Dependencies

[top of page]

APPS.BIL_BI_RS_GRP_MV references the following:

SchemaAPPS
TableBIL_BI_GRP_CNT_MV
Materialized ViewBIL_BI_GRP_CNT_MV
TableBIL_BI_RS_GRP_MV
SchemaJTF
TableJTF_RS_GROUPS_DENORM
TableJTF_RS_GROUP_USAGES
APPS.BIL_BI_RS_GRP_MV is referenced by following:

SchemaAPPS
Materialized ViewBIL_BI_FST1_PG_MV
Materialized ViewBIL_BI_OP12_PG_MV
Materialized ViewBIL_BI_OP21_G_MV
Materialized ViewBIL_BI_OPLDC_GC_MV
Materialized ViewBIL_BI_OPLPC_GC_MV
Materialized ViewBIL_BI_PIPEC_WG_MV
Materialized ViewBIL_BI_PIPE_MV