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

VIEW: APPS.JTF_TERR_DENORM_RULES

Object Details
Object Name: JTF_TERR_DENORM_RULES
Object Type: VIEW
Owner: APPS
FND Design Data: ViewJTF.JTF_TERR_DENORM_RULES
Subobject Name:
Status: VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.


Denormalized Territory view for performance purposes


[View Source]

Columns
Name Datatype Length Mandatory Comments
SOURCE_ID NUMBER
Yes Source Identifier (Oracle Sequence).
QUAL_TYPE_ID NUMBER
Yes Qualifier Type Identifier
TERR_ID NUMBER
Yes Territory Identifier
ABSOLUTE_RANK NUMBER

Absolute Rank of the territory
RELATIVE_RANK NUMBER

Relative rank of the territory
NUM_QUAL NUMBER

Number of Qualifiers on Territory for Usage/Transaction Type combination
RANK NUMBER

Rank for this territory
LEVEL_FROM_ROOT NUMBER

Depth of a territory in relation to a parent.
RELATED_TERR_ID NUMBER
Yes Parent territory identifier. Foreign key to JTF_TERR table
LEVEL_FROM_PARENT NUMBER

Depth of a territory in relation to a parent.
TOP_LEVEL_TERR_ID NUMBER

Territory Unique Identifier
NUM_WINNERS NUMBER

Number of winners among the sub-territories of this territory.
IMMEDIATE_PARENT_FLAG VARCHAR2 (1)
Flag that indicates whether the parent territory identifier is for a immediate parent
ROOT_FLAG VARCHAR2 (1)
Flag idicates whether the territory identifier is a root Territory
LEAF_FLAG VARCHAR2 (1)
Flag idicates whether the territory identifier is a leaf Territory
LAST_UPDATE_DATE DATE
Yes Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER
Yes Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Yes Standard who column - date when this row was created.
CREATED_BY NUMBER
Yes Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN NUMBER

Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
REQUEST_ID NUMBER

Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
PROGRAM_APPLICATION_ID NUMBER

Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID).
PROGRAM_ID NUMBER

Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).
PROGRAM_UPDATE_DATE DATE

Concurrent Program who column - date when a program last updated this row).
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield structure definition column.
ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield segment
ORG_ID NUMBER

Organization identifier
Query Text

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


SELECT SOURCE_ID
,      QUAL_TYPE_ID
,      TERR_ID
,      ABSOLUTE_RANK
,      RELATIVE_RANK
,      NUM_QUAL
,      RANK
,      LEVEL_FROM_ROOT
,      RELATED_TERR_ID
,      LEVEL_FROM_PARENT
,      TOP_LEVEL_TERR_ID
,      NUM_WINNERS
,      IMMEDIATE_PARENT_FLAG
,      ROOT_FLAG
,      LEAF_FLAG
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ORG_ID
FROM APPS.JTF_TERR_DENORM_RULES;

Dependencies

[top of page]

APPS.JTF_TERR_DENORM_RULES references the following:

SchemaAPPS
SynonymJTF_TERR_DENORM_RULES_ALL
APPS.JTF_TERR_DENORM_RULES is referenced by following:

SchemaAPPS
ViewJTF_TERR_WINNERS_V