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.JTY_CHANGED_TERRS

Object Details

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

This table stores changed territories.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
JTY_CHANGED_TERRS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TERR_ID

Columns

Name	Datatype	Length	Mandatory	Comments
CHANGED_TERRITORY_ID	NUMBER		Yes	Primary key
OBJECT_VERSION_NUMBER	NUMBER		Yes	Object version number
TERR_ID	NUMBER			Foreign key to JTF_TERR_ALL
SOURCE_ID	NUMBER			Source ID
CHANGE_TYPE	VARCHAR2	(80)		Change type
RANK_CALC_FLAG	VARCHAR2	(1)		Rank calculation flag
PROCESS_ATTR_VALUES_FLAG	VARCHAR2	(1)		Process attribute values flag
MATCHING_SQL_FLAG	VARCHAR2	(1)		Matching SQL flag
HIER_PROCESSING_FLAG	VARCHAR2	(1)		Hierarchy processing flag
STAR_REQUEST_ID	NUMBER			STAR request_id
TAP_REQUEST_ID	NUMBER			TAP request_id

Query Text

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


SELECT CHANGED_TERRITORY_ID
,      OBJECT_VERSION_NUMBER
,      TERR_ID
,      SOURCE_ID
,      CHANGE_TYPE
,      RANK_CALC_FLAG
,      PROCESS_ATTR_VALUES_FLAG
,      MATCHING_SQL_FLAG
,      HIER_PROCESSING_FLAG
,      STAR_REQUEST_ID
,      TAP_REQUEST_ID
FROM JTF.JTY_CHANGED_TERRS;

Dependencies

[top of page]

JTF.JTY_CHANGED_TERRS does not reference any database object

JTF.JTY_CHANGED_TERRS is referenced by following:

JTF: JTY_CHANGED_TERRS#