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_CHANGED_TERR_ALL

Object Details

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

Stores records of changes to JTF_TERR_ALL, JTF_TERR_VALUES, and JTF_TERR_RSC

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
JTF_CHANGED_TERR_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TERR_ID TERR_VALUE_ID TERR_RSC_ID TERR_RSC_ACCESS_ID TERR_QTYPE_USG_ID

Columns

Name	Datatype	Length	Mandatory	Comments
TERR_ID	NUMBER		Yes	territory id of changed territory
TRIGGER_MODE	VARCHAR2	(30)	Yes	trigger that prompted creation of changed_terr record
ACTION	VARCHAR2	(30)	Yes	last action on this record: 'NEW_RECORD' or 'UPDATED_RECORD'
PARENT_TERRITORY_ID	NUMBER			terr id of this territory's parent territory
OLD_START_DATE_ACTIVE	DATE			old value of start_date_active
OLD_END_DATE_ACTIVE	DATE			old value of end_date_active
OLD_RANK	NUMBER			old value of rank
OLD_UPDATE_FLAG	VARCHAR2	(1)		old value of update_flag
NEW_START_DATE_ACTIVE	DATE			new value for start_date_active
NEW_END_DATE_ACTIVE	DATE			new value for end_date_active
NEW_RANK	NUMBER			new value for rank
NEW_UPDATE_FLAG	VARCHAR2	(1)		new value for new_update_flag
OLD_LAST_UPDATED_BY	NUMBER			old value last_updated_by
OLD_LAST_UPDATE_DATE	DATE			old value last_update_date
OLD_CREATED_BY	NUMBER			old value of created_by
OLD_CREATION_DATE	DATE			old value of creation_date
OLD_LAST_UPDATE_LOGIN	NUMBER			old value of last_update_login
OLD_TERR_QUAL_ID	NUMBER			old value for terr_qual_id in jtf_terr_values
OLD_INCLUDE_FLAG	VARCHAR2	(15)		Not used.
OLD_COMPARISON_OPERATOR	VARCHAR2	(30)		old value for comparison_operator in jtf_terr_values
OLD_ID_USED_FLAG	VARCHAR2	(1)		old value for id_used_flag in jtf_terr_values
OLD_LOW_VALUE_CHAR_ID	NUMBER			old value for low_value_char_id in jtf_terr_values
OLD_LOW_VALUE_CHAR	VARCHAR2	(60)		old value for low_value_char in jtf_terr_values
OLD_HIGH_VALUE_CHAR	VARCHAR2	(60)		old value for high_value_char in jtf_terr_values
OLD_LOW_VALUE_NUMBER	NUMBER			old value for low_value_number in jtf_terr_values
OLD_HIGH_VALUE_NUMBER	NUMBER			old value for high_value_number in jtf_terr_values
OLD_VALUE_SET	NUMBER			old value for value_set in jtf_terr_values
OLD_INTEREST_TYPE_ID	NUMBER			old value for interest_type_id in jtf_terr_values
OLD_PRIMARY_INTEREST_CODE_ID	NUMBER			old value for primary_interest_code_id in jtf_terr_values
OLD_SECONDARY_INTEREST_CODE_ID	NUMBER			old value for secondary_interest_code_id in jtf_terr_values
OLD_CURRENCY_CODE	VARCHAR2	(15)		old value for currency_code in jtf_terr_values
NEW_LAST_UPDATED_BY	NUMBER			new value for last_updated_by
NEW_LAST_UPDATE_DATE	DATE			new value for last_update_date
NEW_CREATED_BY	NUMBER			new value for created_by
NEW_CREATION_DATE	DATE			new value for creation_date
NEW_LAST_UPDATE_LOGIN	NUMBER			new value for last_update_login
NEW_TERR_QUAL_ID	NUMBER			new value for terr_qual_id in jtf_terr_values
NEW_INCLUDE_FLAG	VARCHAR2	(15)		new value for include_flag in jtf_terr_values
NEW_COMPARISON_OPERATOR	VARCHAR2	(30)		new value for comparison_operator in jtf_terr_values
NEW_ID_USED_FLAG	VARCHAR2	(1)		new value in id_used_flag in jtf_terr_values
NEW_LOW_VALUE_CHAR_ID	NUMBER			new value for low_value_char_id in jtf_terr_values
NEW_LOW_VALUE_CHAR	VARCHAR2	(60)		new value for low_value_char in jtf_terr_values
NEW_HIGH_VALUE_CHAR	VARCHAR2	(60)		new value for high_value_char in jtf_terr_values
NEW_LOW_VALUE_NUMBER	NUMBER			new value for low_value_number in jtf_terr_values
NEW_HIGH_VALUE_NUMBER	NUMBER			new value for high_value_number in jtf_terr_values
NEW_VALUE_SET	NUMBER			new value for value_set in jtf_terr_values
NEW_INTEREST_TYPE_ID	NUMBER			new value for interest_type_id in jtf_terr_values
NEW_PRIMARY_INTEREST_CODE_ID	NUMBER			new value for primary_interest_code_id in jtf_terr_values
NEW_SECONDARY_INTEREST_CODE_ID	NUMBER			new value for secondary_interest_code in jtf_terr_values
NEW_CURRENCY_CODE	VARCHAR2	(15)		new value for currency_code in jtf_terr_values
TERR_VALUE_ID	NUMBER			terr_value_id of territory qualifier value changed with relation of modified territory
OLD_RESOURCE_ID	NUMBER			old value for resource_id in jtf_terr_rsc
OLD_GROUP_ID	NUMBER			Old Group_id value from resource table
OLD_RESOURCE_TYPE	VARCHAR2	(60)		old value for resource_type in jtf_terr_rsc
OLD_ROLE	VARCHAR2	(60)		old value for role in jtf_terr_rsc
OLD_PRIMARY_CONTACT_FLAG	VARCHAR2	(1)		old value for primary_contact_flag in jtf_terr_rsc
OLD_FULL_ACCESS_FLAG	VARCHAR2	(1)		old value for full_access_flag in jtf_terr_rsc
NEW_RESOURCE_ID	NUMBER			new value for resource_id in jtf_terr_rsc
NEW_GROUP_ID	NUMBER			New Group_id value from resource table
NEW_RESOURCE_TYPE	VARCHAR2	(60)		new value for resource_type in jtf_terr_rsc
NEW_ROLE	VARCHAR2	(60)		new value for role in jtf_terr_rsc
NEW_PRIMARY_CONTACT_FLAG	VARCHAR2	(1)		new value for primary_contact_flag in jtf_terr_rsc
NEW_FULL_ACCESS_FLAG	VARCHAR2	(1)		new value for full_access_flag in jtf_terr_rsc
TRANSFER_ONLY_FLAG	VARCHAR2	(1)		not used
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).
TERR_RSC_ID	NUMBER			resource id of resource changed with relation to modified territory
ORG_ID	NUMBER			Organization identifier
SECURITY_GROUP_ID	NUMBER			Used as part of Hosting Coding Standards.
TERR_QTYPE_USG_ID	NUMBER			column used when changed terr record is of Terr_qtype_usgs
OLD_QUAL_TYPE_USG_ID	NUMBER			Old value for qual_type_usg_id in terr qtype changed record
NEW_QUAL_TYPE_USG_ID	NUMBER			New value for qual_type_usg_id in terr qtype changed record
TERR_RSC_ACCESS_ID	NUMBER			column used when changed terr record is of Terr_rsc_access
OLD_ACCESS_TYPE	VARCHAR2	(30)		old access type for terr_rsc_access changed record
NEW_ACCESS_TYPE	VARCHAR2	(30)		new access type for terr_rsc_access changed record
OLD_NUM_WINNERS	NUMBER			OLD NUMBER OF winners for this territory
NEW_NUM_WINNERS	NUMBER			NEW NUMBER OF winners for this territory
OLD_PARENT_TERRITORY_ID	NUMBER			Old parent territory id before transaction
NEW_PARENT_TERRITORY_ID	NUMBER			New parent territory id after transaction
OBJECT_VERSION_NUMBER	NUMBER			standard column

Query Text

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


SELECT TERR_ID
,      TRIGGER_MODE
,      ACTION
,      PARENT_TERRITORY_ID
,      OLD_START_DATE_ACTIVE
,      OLD_END_DATE_ACTIVE
,      OLD_RANK
,      OLD_UPDATE_FLAG
,      NEW_START_DATE_ACTIVE
,      NEW_END_DATE_ACTIVE
,      NEW_RANK
,      NEW_UPDATE_FLAG
,      OLD_LAST_UPDATED_BY
,      OLD_LAST_UPDATE_DATE
,      OLD_CREATED_BY
,      OLD_CREATION_DATE
,      OLD_LAST_UPDATE_LOGIN
,      OLD_TERR_QUAL_ID
,      OLD_INCLUDE_FLAG
,      OLD_COMPARISON_OPERATOR
,      OLD_ID_USED_FLAG
,      OLD_LOW_VALUE_CHAR_ID
,      OLD_LOW_VALUE_CHAR
,      OLD_HIGH_VALUE_CHAR
,      OLD_LOW_VALUE_NUMBER
,      OLD_HIGH_VALUE_NUMBER
,      OLD_VALUE_SET
,      OLD_INTEREST_TYPE_ID
,      OLD_PRIMARY_INTEREST_CODE_ID
,      OLD_SECONDARY_INTEREST_CODE_ID
,      OLD_CURRENCY_CODE
,      NEW_LAST_UPDATED_BY
,      NEW_LAST_UPDATE_DATE
,      NEW_CREATED_BY
,      NEW_CREATION_DATE
,      NEW_LAST_UPDATE_LOGIN
,      NEW_TERR_QUAL_ID
,      NEW_INCLUDE_FLAG
,      NEW_COMPARISON_OPERATOR
,      NEW_ID_USED_FLAG
,      NEW_LOW_VALUE_CHAR_ID
,      NEW_LOW_VALUE_CHAR
,      NEW_HIGH_VALUE_CHAR
,      NEW_LOW_VALUE_NUMBER
,      NEW_HIGH_VALUE_NUMBER
,      NEW_VALUE_SET
,      NEW_INTEREST_TYPE_ID
,      NEW_PRIMARY_INTEREST_CODE_ID
,      NEW_SECONDARY_INTEREST_CODE_ID
,      NEW_CURRENCY_CODE
,      TERR_VALUE_ID
,      OLD_RESOURCE_ID
,      OLD_GROUP_ID
,      OLD_RESOURCE_TYPE
,      OLD_ROLE
,      OLD_PRIMARY_CONTACT_FLAG
,      OLD_FULL_ACCESS_FLAG
,      NEW_RESOURCE_ID
,      NEW_GROUP_ID
,      NEW_RESOURCE_TYPE
,      NEW_ROLE
,      NEW_PRIMARY_CONTACT_FLAG
,      NEW_FULL_ACCESS_FLAG
,      TRANSFER_ONLY_FLAG
,      REQUEST_ID
,      TERR_RSC_ID
,      ORG_ID
,      SECURITY_GROUP_ID
,      TERR_QTYPE_USG_ID
,      OLD_QUAL_TYPE_USG_ID
,      NEW_QUAL_TYPE_USG_ID
,      TERR_RSC_ACCESS_ID
,      OLD_ACCESS_TYPE
,      NEW_ACCESS_TYPE
,      OLD_NUM_WINNERS
,      NEW_NUM_WINNERS
,      OLD_PARENT_TERRITORY_ID
,      NEW_PARENT_TERRITORY_ID
,      OBJECT_VERSION_NUMBER
FROM JTF.JTF_CHANGED_TERR_ALL;

Dependencies

[top of page]

JTF.JTF_CHANGED_TERR_ALL does not reference any database object

JTF.JTF_CHANGED_TERR_ALL is referenced by following:

JTF: JTF_CHANGED_TERR_ALL#