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

MATERIALIZED VIEW: APPS.JTF_TERR_CNR_QUAL_LIKE_MV

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

JTF_TERR_DENORM_RULES_ALL
JTF_TERR_DENORM_RULES_ALL
JTF_TERR_QUAL_ALL
JTF_TERR_QUAL_ALL
JTF_TERR_VALUES_ALL
JTF_TERR_VALUES_ALL

[View Source Query]

Columns
Name Datatype Length Mandatory Comments
RULE_ROWID ROWID (10)
QUAL_ROWID ROWID (10)
VAL_ROWID ROWID (10)
TERR_ID NUMBER
Yes
ABSOLUTE_RANK NUMBER

RELATED_TERR_ID NUMBER
Yes
TOP_LEVEL_TERR_ID NUMBER

NUM_WINNERS NUMBER

SOURCE_ID NUMBER
Yes
QUAL_USG_ID NUMBER
Yes
TERR_QUAL_ID NUMBER
Yes
TERR_VALUE_ID NUMBER
Yes
LOW_VALUE_CHAR VARCHAR2 (360)
FIRST_CHAR VARCHAR2 (3)
Query Text

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


SELECT RULE_ROWID
,      QUAL_ROWID
,      VAL_ROWID
,      TERR_ID
,      ABSOLUTE_RANK
,      RELATED_TERR_ID
,      TOP_LEVEL_TERR_ID
,      NUM_WINNERS
,      SOURCE_ID
,      QUAL_USG_ID
,      TERR_QUAL_ID
,      TERR_VALUE_ID
,      LOW_VALUE_CHAR
,      FIRST_CHAR
FROM APPS.JTF_TERR_CNR_QUAL_LIKE_MV;

Dependencies

[top of page]

APPS.JTF_TERR_CNR_QUAL_LIKE_MV references the following:

SchemaAPPS
TableJTF_TERR_CNR_QUAL_LIKE_MV
SynonymJTF_TERR_DENORM_RULES_ALL
SynonymJTF_TERR_QUAL_ALL
SynonymJTF_TERR_VALUES_ALL
SchemaJTF
TableJTF_TERR_DENORM_RULES_ALL
TableJTF_TERR_QUAL_ALL
TableJTF_TERR_VALUES_ALL

APPS.JTF_TERR_CNR_QUAL_LIKE_MV is not referenced by any database object