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

MATERIALIZED VIEW: APPS.AS_GROUP_MV

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

JTF_RS_ROLES_B

[View Source Query]

Columns
Name Datatype Length Mandatory Comments
GROUP_ID NUMBER
Yes
GROUP_NAME VARCHAR2 (60) Yes
RESOURCE_ID NUMBER
Yes
PERSON_ID NUMBER

START_DATE_ACTIVE DATE

END_DATE_ACTIVE DATE

CNT NUMBER

Query Text

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


SELECT GROUP_ID
,      GROUP_NAME
,      RESOURCE_ID
,      PERSON_ID
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      CNT
FROM APPS.AS_GROUP_MV;

Dependencies

[top of page]

APPS.AS_GROUP_MV references the following:

SchemaAPPS
TableAS_GROUP_MV
SynonymJTF_RS_GROUPS_TL
SynonymJTF_RS_GROUP_MEMBERS
SynonymJTF_RS_ROLES_B
SynonymJTF_RS_ROLE_RELATIONS
SchemaJTF
TableJTF_RS_GROUPS_TL
TableJTF_RS_GROUP_MEMBERS
TableJTF_RS_ROLES_B
TableJTF_RS_ROLE_RELATIONS

APPS.AS_GROUP_MV is not referenced by any database object