eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: JTF.JTF_TERR_ALL

Object Details

Object Name:	JTF_TERR_ALL
Object Type:	TABLE
Owner:	JTF
FND Design Data:	JTF.JTF_TERR_ALL
Subobject Name:
Status:	VALID

Stores the definition of the territories. There are 3 types of territories, Standard, Escalation and Template. Information stored in this table also includes comment about this territory, effective dates, and what type of territory it is.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
JTF_TERR_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	TERR_ID ORG_ID ZD_EDITION_NAME
JTF_TERR_ALL_N9	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	GEO_TERRITORY_ID
JTF_TERR_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PARENT_TERRITORY_ID START_DATE_ACTIVE RANK END_DATE_ACTIVE
JTF_TERR_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PARENT_TERRITORY_ID ORG_ID
JTF_TERR_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TERRITORY_TYPE_ID ORG_ID
JTF_TERR_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TEMPLATE_TERRITORY_ID ORG_ID
JTF_TERR_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ESCALATION_TERRITORY_ID ORG_ID
JTF_TERR_N6	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TERR_GROUP_ACCOUNT_ID TERR_ID
JTF_TERR_N7	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TERR_GROUP_ID TERR_ID
JTF_TERR_N8	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	END_DATE_ACTIVE START_DATE_ACTIVE TERR_ID NAME

Columns

Name	Datatype	Length	Mandatory	Comments
TERR_ID	NUMBER		Yes	Territory Unique Identifier
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).
APPLICATION_SHORT_NAME	VARCHAR2	(50)	Yes	Application short name of last concurrent program to update record.
NAME	VARCHAR2	(2000)	Yes	The name of the territory.
ENABLED_FLAG	VARCHAR2	(1)	Yes	Flag to indicate whether the territory is enabled.
START_DATE_ACTIVE	DATE			Date this territory becomes active, if limited.
END_DATE_ACTIVE	DATE			Date this territory becomes inactive, if limited.
PLANNED_FLAG	VARCHAR2	(1)		Not used.
PARENT_TERRITORY_ID	NUMBER		Yes	Foreign key to JTF_TERR_ALL table. Identifier of the parent territory.
TERRITORY_TYPE_ID	NUMBER			Foreign key to JTF_TERR_TYPES_ALL table.
TEMPLATE_TERRITORY_ID	NUMBER			Foreign key to JTF_TERR_ALL table. Identifier of the template territory.
TEMPLATE_FLAG	VARCHAR2	(1)		Flag to indicate if this territory is being used as a territory template.
ESCALATION_TERRITORY_ID	NUMBER			Foreign key to JTF_TERR_ALL table. Identifier of the escalation territory.
ESCALATION_TERRITORY_FLAG	VARCHAR2	(1)		Flag to indicate if this territory is being used as an escalation territory.
OVERLAP_ALLOWED_FLAG	VARCHAR2	(1)		Indicates whether this territory allows its qualifier values to overlap with that of another territory.
RANK	NUMBER			The ranking for this territory.
DESCRIPTION	VARCHAR2	(240)		Description of this territory.
UPDATE_FLAG	VARCHAR2	(1)		Not Used.
AUTO_ASSIGN_RESOURCES_FLAG	VARCHAR2	(1)		Not Used.
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
SECURITY_GROUP_ID	NUMBER			Used as part of Hosting Coding Standards.
ORIG_SYSTEM_REFERENCE	VARCHAR2	(60)		Identifier of the foreign system or table.
ORIG_SYSTEM_REFERENCE_ID	NUMBER			Unique identifier for this row in foreign system or table.
UPGRADE_STATUS_FLAG	VARCHAR2	(1)		Set when this table is upgraded to support quicker upgrade re-run.
NUM_WINNERS	NUMBER			Number of winners among the sub-territories of this territory.
NUM_QUAL	NUMBER			Number of qualifiers used to define territory.
TAP_PROGRAM_ID	NUMBER			Not Used
OBJECT_VERSION_NUMBER	NUMBER			standard column
CATCH_ALL_FLAG	VARCHAR2	(1)		Flag to indiacte if this is a catch-all territory .
NAMED_ACCOUNT_FLAG	VARCHAR2	(1)		Flag to indicate if the territory is created corresponding to a self-service named account territory group account.
TERR_GROUP_FLAG	VARCHAR2	(1)		Flag to indicate if the territory is created corresponding to a self-service territory group.
TERR_GROUP_ID	NUMBER			Foreign Key to jtf_tty_terr_groups.
TERR_GROUP_ACCOUNT_ID	NUMBER			Foreign Key to jtf_tty_terr_grp_accts
GEO_TERR_FLAG	VARCHAR2	(240)		Flag to indicate if the territory is created corresponding to a self-service geography territory group account.
GEO_TERRITORY_ID	NUMBER			Foreign Key to JTF_TTY_GEO_TERR
RELATIVE_RANK	NUMBER			Relative rank
ABSOLUTE_RANK	NUMBER			Absolute rank
ENABLE_SELF_SERVICE	VARCHAR2	(1)		Flag to indicate if the territory is a self-service territory.
TERR_UPDATE_DATE	DATE			Territory update date
ZD_EDITION_NAME	VARCHAR2	(30)	Yes

Query Text

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


SELECT TERR_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      APPLICATION_SHORT_NAME
,      NAME
,      ENABLED_FLAG
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      PLANNED_FLAG
,      PARENT_TERRITORY_ID
,      TERRITORY_TYPE_ID
,      TEMPLATE_TERRITORY_ID
,      TEMPLATE_FLAG
,      ESCALATION_TERRITORY_ID
,      ESCALATION_TERRITORY_FLAG
,      OVERLAP_ALLOWED_FLAG
,      RANK
,      DESCRIPTION
,      UPDATE_FLAG
,      AUTO_ASSIGN_RESOURCES_FLAG
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ORG_ID
,      SECURITY_GROUP_ID
,      ORIG_SYSTEM_REFERENCE
,      ORIG_SYSTEM_REFERENCE_ID
,      UPGRADE_STATUS_FLAG
,      NUM_WINNERS
,      NUM_QUAL
,      TAP_PROGRAM_ID
,      OBJECT_VERSION_NUMBER
,      CATCH_ALL_FLAG
,      NAMED_ACCOUNT_FLAG
,      TERR_GROUP_FLAG
,      TERR_GROUP_ID
,      TERR_GROUP_ACCOUNT_ID
,      GEO_TERR_FLAG
,      GEO_TERRITORY_ID
,      RELATIVE_RANK
,      ABSOLUTE_RANK
,      ENABLE_SELF_SERVICE
,      TERR_UPDATE_DATE
,      ZD_EDITION_NAME
FROM JTF.JTF_TERR_ALL;

Dependencies

[top of page]

JTF.JTF_TERR_ALL does not reference any database object

JTF.JTF_TERR_ALL is referenced by following:

JTF: JTF_TERR_ALL#