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_VALUES_ALL

Object Details

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

Stores the values that have been assigned to the territory qualifiers.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
JTF_TERR_VALUES_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	TERR_VALUE_ID ORG_ID
JTF_TERR_VALUES_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TERR_QUAL_ID COMPARISON_OPERATOR LOW_VALUE_CHAR_ID
JTF_TERR_VALUES_N10	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	COMPARISON_OPERATOR TERR_QUAL_ID LOW_VALUE_CHAR HIGH_VALUE_CHAR
JTF_TERR_VALUES_N11	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	VALUE1_ID VALUE2_ID VALUE3_ID VALUE4_ID COMPARISON_OPERATOR TERR_QUAL_ID
JTF_TERR_VALUES_N12	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SELF_SERVICE_TERR_VALUE_ID
JTF_TERR_VALUES_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TERR_QUAL_ID LOW_VALUE_CHAR COMPARISON_OPERATOR HIGH_VALUE_CHAR
JTF_TERR_VALUES_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TERR_QUAL_ID INTEREST_TYPE_ID PRIMARY_INTEREST_CODE_ID SECONDARY_INTEREST_CODE_ID
JTF_TERR_VALUES_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TERR_QUAL_ID COMPARISON_OPERATOR LOW_VALUE_NUMBER CURRENCY_CODE HIGH_VALUE_NUMBER
JTF_TERR_VALUES_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CNR_GROUP_ID
JTF_TERR_VALUES_N6	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	VALUE1_ID VALUE2_ID VALUE3_ID COMPARISON_OPERATOR TERR_QUAL_ID
JTF_TERR_VALUES_N7	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	COMPARISON_OPERATOR TERR_QUAL_ID FIRST_CHAR LOW_VALUE_CHAR
JTF_TERR_VALUES_N8	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	LOW_VALUE_CHAR COMPARISON_OPERATOR TERR_QUAL_ID
JTF_TERR_VALUES_N9	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	LOW_VALUE_CHAR_ID COMPARISON_OPERATOR TERR_QUAL_ID

Columns

Name	Datatype	Length	Mandatory	Comments
TERR_VALUE_ID	NUMBER		Yes	Territory Value Unique Identifier
LAST_UPDATED_BY	NUMBER		Yes	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE	DATE		Yes	Standard Who column - date when a user last updated this row.
CREATED_BY	NUMBER		Yes	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE	DATE		Yes	Standard who column - date when this row was created.
LAST_UPDATE_LOGIN	NUMBER			Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
TERR_QUAL_ID	NUMBER		Yes	Foreign key to JTF_TERR_QUAL_ALL.
INCLUDE_FLAG	VARCHAR2	(15)		Not used.
COMPARISON_OPERATOR	VARCHAR2	(30)	Yes	The comparison operator for this territory qualifier value.
ID_USED_FLAG	VARCHAR2	(1)		Flag to indicate if the value of this qualifier should be converted to an id.
LOW_VALUE_CHAR_ID	NUMBER			The ID of the low value char for this qualifier.
LOW_VALUE_CHAR	VARCHAR2	(360)		The low value character for this qualifier.
HIGH_VALUE_CHAR	VARCHAR2	(360)		The high value character for this qualifier.
LOW_VALUE_NUMBER	NUMBER			The low value number for this qualifier.
HIGH_VALUE_NUMBER	NUMBER			The high value number for this qualifier.
VALUE_SET	NUMBER			Used to group a set of values for auto-generation of territories.
INTEREST_TYPE_ID	NUMBER			Interest Type Identifier.
PRIMARY_INTEREST_CODE_ID	NUMBER			Primary Interest Code Identifier.
SECONDARY_INTEREST_CODE_ID	NUMBER			Secondary Interest Code Identifier.
CURRENCY_CODE	VARCHAR2	(15)		Currency code used to specify the value for qualifier of type Currency.
ORG_ID	NUMBER			Organization identifier
SECURITY_GROUP_ID	NUMBER			Requirement for Hosting Development Standards
CNR_GROUP_ID	NUMBER			Requirement to support Customer Name Range (Keyword) Groups.
VALUE1_ID	NUMBER			Stores an ID based qualifier value.
VALUE2_ID	NUMBER			Stores a value dependent on VALUE1_ID.
VALUE3_ID	NUMBER			Stores a value dependent on VALUE2_ID.
FIRST_CHAR	VARCHAR2	(3)		The low value character for this qualifier.
OBJECT_VERSION_NUMBER	NUMBER			standard column
VALUE4_ID	NUMBER			Stores a value dependent on VALUE3_ID.
SELF_SERVICE_TERR_VALUE_ID	NUMBER			Indicate terr value id for self service territory

Query Text

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


SELECT TERR_VALUE_ID
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_LOGIN
,      TERR_QUAL_ID
,      INCLUDE_FLAG
,      COMPARISON_OPERATOR
,      ID_USED_FLAG
,      LOW_VALUE_CHAR_ID
,      LOW_VALUE_CHAR
,      HIGH_VALUE_CHAR
,      LOW_VALUE_NUMBER
,      HIGH_VALUE_NUMBER
,      VALUE_SET
,      INTEREST_TYPE_ID
,      PRIMARY_INTEREST_CODE_ID
,      SECONDARY_INTEREST_CODE_ID
,      CURRENCY_CODE
,      ORG_ID
,      SECURITY_GROUP_ID
,      CNR_GROUP_ID
,      VALUE1_ID
,      VALUE2_ID
,      VALUE3_ID
,      FIRST_CHAR
,      OBJECT_VERSION_NUMBER
,      VALUE4_ID
,      SELF_SERVICE_TERR_VALUE_ID
FROM JTF.JTF_TERR_VALUES_ALL;

Dependencies

[top of page]

JTF.JTF_TERR_VALUES_ALL does not reference any database object

JTF.JTF_TERR_VALUES_ALL is referenced by following:

APPS: JTF_TERR_CNRG_BTWN_MV; JTF_TERR_CNRG_EQUAL_MV; JTF_TERR_CNRG_LIKE_MV; JTF_TERR_CNR_QUAL_BTWN_MV; JTF_TERR_CNR_QUAL_LIKE_MV; JTF_TERR_QUAL_RULES_MV
JTF: JTF_TERR_VALUES_ALL#