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

VIEW: JTF.JTF_TERR_DENORM_ALL#

Object Details
Object Name: JTF_TERR_DENORM_ALL#
Object Type: VIEW
Owner: JTF
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
SOURCE_ID NUMBER
Yes
TERR_ID NUMBER
Yes
ABSOLUTE_RANK NUMBER

RELATED_TERR_ID NUMBER
Yes
TOP_LEVEL_TERR_ID NUMBER

NUM_WINNERS NUMBER

SECURITY_GROUP_ID NUMBER

OBJECT_VERSION_NUMBER NUMBER

Query Text

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


SELECT SOURCE_ID
,      TERR_ID
,      ABSOLUTE_RANK
,      RELATED_TERR_ID
,      TOP_LEVEL_TERR_ID
,      NUM_WINNERS
,      SECURITY_GROUP_ID
,      OBJECT_VERSION_NUMBER
FROM JTF.JTF_TERR_DENORM_ALL#;

Dependencies

[top of page]

JTF.JTF_TERR_DENORM_ALL# references the following:

SchemaJTF
TableJTF_TERR_DENORM_ALL
JTF.JTF_TERR_DENORM_ALL# is referenced by following:

SchemaAPPS
SynonymJTF_TERR_DENORM_ALL