[Home] [Help] [Dependency Information]
Object Name: | JTF_TERR_DENORM_ALL |
---|---|
Object Type: | TABLE |
Owner: | JTF |
FND Design Data: | JTF.JTF_TERR_DENORM_ALL |
Subobject Name: | |
Status: | VALID |
Denormalized Territory tables for reporting purposes
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IND_34425485 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
TERR_ID
RELATED_TERR_ID TOP_LEVEL_TERR_ID SOURCE_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SOURCE_ID | NUMBER | Yes | Source Identifier (Oracle Sequence). | |
TERR_ID | NUMBER | Yes | Foreign key to JTF_TERR | |
ABSOLUTE_RANK | NUMBER | Foreign key to JTF_TERR | ||
RELATED_TERR_ID | NUMBER | Yes | Parent territory identifier. Foreign key to JTF_TERR table | |
TOP_LEVEL_TERR_ID | NUMBER | Territory Unique Identifier | ||
NUM_WINNERS | NUMBER | Number of winners among the sub-territories of this territory. | ||
SECURITY_GROUP_ID | NUMBER | Used as part of Hosting Coding Standards. | ||
OBJECT_VERSION_NUMBER | NUMBER | standard column |
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;
JTF.JTF_TERR_DENORM_ALL does not reference any database object
JTF.JTF_TERR_DENORM_ALL is referenced by following:
|
|
|