[Home] [Help] [Dependency Information]
Object Name: | JTF_CHANGED_TERR_ALL# |
---|---|
Object Type: | VIEW |
Owner: | JTF |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
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 |
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#;
|
|
|