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]

VIEW: JTF.JTF_CHANGED_TERR_ALL#

Object Details

Object Name:	JTF_CHANGED_TERR_ALL#
Object Type:	VIEW
Owner:	JTF
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory
TERR_ID	NUMBER		Yes
TRIGGER_MODE	VARCHAR2	(30)	Yes
ACTION	VARCHAR2	(30)	Yes
PARENT_TERRITORY_ID	NUMBER
OLD_START_DATE_ACTIVE	DATE
OLD_END_DATE_ACTIVE	DATE
OLD_RANK	NUMBER
OLD_UPDATE_FLAG	VARCHAR2	(1)
NEW_START_DATE_ACTIVE	DATE
NEW_END_DATE_ACTIVE	DATE
NEW_RANK	NUMBER
NEW_UPDATE_FLAG	VARCHAR2	(1)
OLD_LAST_UPDATED_BY	NUMBER
OLD_LAST_UPDATE_DATE	DATE
OLD_CREATED_BY	NUMBER
OLD_CREATION_DATE	DATE
OLD_LAST_UPDATE_LOGIN	NUMBER
OLD_TERR_QUAL_ID	NUMBER
OLD_INCLUDE_FLAG	VARCHAR2	(15)
OLD_COMPARISON_OPERATOR	VARCHAR2	(30)
OLD_ID_USED_FLAG	VARCHAR2	(1)
OLD_LOW_VALUE_CHAR_ID	NUMBER
OLD_LOW_VALUE_CHAR	VARCHAR2	(60)
OLD_HIGH_VALUE_CHAR	VARCHAR2	(60)
OLD_LOW_VALUE_NUMBER	NUMBER
OLD_HIGH_VALUE_NUMBER	NUMBER
OLD_VALUE_SET	NUMBER
OLD_INTEREST_TYPE_ID	NUMBER
OLD_PRIMARY_INTEREST_CODE_ID	NUMBER
OLD_SECONDARY_INTEREST_CODE_ID	NUMBER
OLD_CURRENCY_CODE	VARCHAR2	(15)
NEW_LAST_UPDATED_BY	NUMBER
NEW_LAST_UPDATE_DATE	DATE
NEW_CREATED_BY	NUMBER
NEW_CREATION_DATE	DATE
NEW_LAST_UPDATE_LOGIN	NUMBER
NEW_TERR_QUAL_ID	NUMBER
NEW_INCLUDE_FLAG	VARCHAR2	(15)
NEW_COMPARISON_OPERATOR	VARCHAR2	(30)
NEW_ID_USED_FLAG	VARCHAR2	(1)
NEW_LOW_VALUE_CHAR_ID	NUMBER
NEW_LOW_VALUE_CHAR	VARCHAR2	(60)
NEW_HIGH_VALUE_CHAR	VARCHAR2	(60)
NEW_LOW_VALUE_NUMBER	NUMBER
NEW_HIGH_VALUE_NUMBER	NUMBER
NEW_VALUE_SET	NUMBER
NEW_INTEREST_TYPE_ID	NUMBER
NEW_PRIMARY_INTEREST_CODE_ID	NUMBER
NEW_SECONDARY_INTEREST_CODE_ID	NUMBER
NEW_CURRENCY_CODE	VARCHAR2	(15)
TERR_VALUE_ID	NUMBER
OLD_RESOURCE_ID	NUMBER
OLD_GROUP_ID	NUMBER
OLD_RESOURCE_TYPE	VARCHAR2	(60)
OLD_ROLE	VARCHAR2	(60)
OLD_PRIMARY_CONTACT_FLAG	VARCHAR2	(1)
OLD_FULL_ACCESS_FLAG	VARCHAR2	(1)
NEW_RESOURCE_ID	NUMBER
NEW_GROUP_ID	NUMBER
NEW_RESOURCE_TYPE	VARCHAR2	(60)
NEW_ROLE	VARCHAR2	(60)
NEW_PRIMARY_CONTACT_FLAG	VARCHAR2	(1)
NEW_FULL_ACCESS_FLAG	VARCHAR2	(1)
TRANSFER_ONLY_FLAG	VARCHAR2	(1)
REQUEST_ID	NUMBER
TERR_RSC_ID	NUMBER
ORG_ID	NUMBER
SECURITY_GROUP_ID	NUMBER
TERR_QTYPE_USG_ID	NUMBER
OLD_QUAL_TYPE_USG_ID	NUMBER
NEW_QUAL_TYPE_USG_ID	NUMBER
TERR_RSC_ACCESS_ID	NUMBER
OLD_ACCESS_TYPE	VARCHAR2	(30)
NEW_ACCESS_TYPE	VARCHAR2	(30)
OLD_NUM_WINNERS	NUMBER
NEW_NUM_WINNERS	NUMBER
OLD_PARENT_TERRITORY_ID	NUMBER
NEW_PARENT_TERRITORY_ID	NUMBER
OBJECT_VERSION_NUMBER	NUMBER

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# references the following:

JTF: JTF_CHANGED_TERR_ALL

JTF.JTF_CHANGED_TERR_ALL# is referenced by following:

APPS: JTF_CHANGED_TERR; JTF_CHANGED_TERR_ALL