[Home] [Help] [Dependency Information]
Object Name: | JTF_TERR_VALUES_DESC_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | JTF.JTF_TERR_VALUES_DESC_V |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
A supplementary view used to simplify forms coding.
Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TERR_VALUE_ID | NUMBER | |||
LAST_UPDATED_BY | NUMBER | |||
LAST_UPDATE_DATE | DATE | |||
CREATED_BY | NUMBER | |||
CREATION_DATE | DATE | |||
LAST_UPDATE_LOGIN | NUMBER | |||
TERR_QUAL_ID | NUMBER | |||
INCLUDE_FLAG | VARCHAR2 | (15) | ||
COMPARISON_OPERATOR | VARCHAR2 | (30) | ||
LOW_VALUE_CHAR | VARCHAR2 | (360) | ||
LOW_VALUE_CHAR_DESC | VARCHAR2 | (4000) | ||
HIGH_VALUE_CHAR | VARCHAR2 | (360) | ||
HIGH_VALUE_CHAR_DESC | VARCHAR2 | (4000) | ||
LOW_VALUE_NUMBER | NUMBER | |||
HIGH_VALUE_NUMBER | NUMBER | |||
VALUE_SET | NUMBER | |||
INTEREST_TYPE_ID | NUMBER | |||
INTEREST_TYPE | VARCHAR2 | (4000) | ||
PRIMARY_INTEREST_CODE_ID | NUMBER | |||
PRIMARY_INTEREST_CODE | VARCHAR2 | (4000) | ||
SECONDARY_INTEREST_CODE_ID | NUMBER | |||
SECONDARY_INTEREST_CODE | VARCHAR2 | (4000) | ||
CURRENCY_CODE | VARCHAR2 | (15) | ||
CURRENCY_DESC | VARCHAR2 | (4000) | ||
ORG_ID | NUMBER | |||
ID_USED_FLAG | VARCHAR2 | (1) | ||
LOW_VALUE_CHAR_ID | NUMBER | |||
TERR_ID | NUMBER | |||
DISPLAY_TYPE | VARCHAR2 | (40) | ||
LOV_SQL | VARCHAR2 | (1000) | ||
CONVERT_TO_ID_FLAG | VARCHAR2 | (1) | ||
COLUMN_COUNT | NUMBER | |||
FORMATTING_FUNCTION_FLAG | VARCHAR2 | (1) | ||
FORMATTING_FUNCTION_NAME | VARCHAR2 | (120) | ||
SPECIAL_FUNCTION_FLAG | VARCHAR2 | (1) | ||
SPECIAL_FUNCTION_NAME | VARCHAR2 | (120) | ||
ENABLE_LOV_VALIDATION | VARCHAR2 | (1) | ||
DISPLAY_SQL1 | VARCHAR2 | (1000) | ||
LOV_SQL2 | VARCHAR2 | (1000) | ||
DISPLAY_SQL2 | VARCHAR2 | (1000) | ||
LOV_SQL3 | VARCHAR2 | (1000) | ||
DISPLAY_SQL3 | VARCHAR2 | (1000) | ||
COMPETENCE_NAME | VARCHAR2 | (4000) | ||
RATING_SCALE_ID | NUMBER | |||
PROFICIENCY_LEVEL | VARCHAR2 | (4000) | ||
LOW_VALUE_DATE | DATE | |||
HIGH_VALUE_DATE | DATE | |||
CNR_GROUP_ID | NUMBER | |||
CNR_GROUP_NAME | VARCHAR2 | (255) | ||
VALUE1_ID | NUMBER | |||
VALUE1_DESC | VARCHAR2 | (4000) | ||
VALUE2_ID | NUMBER | |||
VALUE2_DESC | VARCHAR2 | (4000) | ||
VALUE3_ID | NUMBER | |||
VALUE3_DESC | VARCHAR2 | (4000) | ||
VALUE4_ID | NUMBER |
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
, LOW_VALUE_CHAR
, LOW_VALUE_CHAR_DESC
, HIGH_VALUE_CHAR
, HIGH_VALUE_CHAR_DESC
, LOW_VALUE_NUMBER
, HIGH_VALUE_NUMBER
, VALUE_SET
, INTEREST_TYPE_ID
, INTEREST_TYPE
, PRIMARY_INTEREST_CODE_ID
, PRIMARY_INTEREST_CODE
, SECONDARY_INTEREST_CODE_ID
, SECONDARY_INTEREST_CODE
, CURRENCY_CODE
, CURRENCY_DESC
, ORG_ID
, ID_USED_FLAG
, LOW_VALUE_CHAR_ID
, TERR_ID
, DISPLAY_TYPE
, LOV_SQL
, CONVERT_TO_ID_FLAG
, COLUMN_COUNT
, FORMATTING_FUNCTION_FLAG
, FORMATTING_FUNCTION_NAME
, SPECIAL_FUNCTION_FLAG
, SPECIAL_FUNCTION_NAME
, ENABLE_LOV_VALIDATION
, DISPLAY_SQL1
, LOV_SQL2
, DISPLAY_SQL2
, LOV_SQL3
, DISPLAY_SQL3
, COMPETENCE_NAME
, RATING_SCALE_ID
, PROFICIENCY_LEVEL
, LOW_VALUE_DATE
, HIGH_VALUE_DATE
, CNR_GROUP_ID
, CNR_GROUP_NAME
, VALUE1_ID
, VALUE1_DESC
, VALUE2_ID
, VALUE2_DESC
, VALUE3_ID
, VALUE3_DESC
, VALUE4_ID
FROM APPS.JTF_TERR_VALUES_DESC_V;
|
|
|