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: APPS.JTF_TERR_QUALIFIERS_V

Object Details

Object Name:	JTF_TERR_QUALIFIERS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	JTF.JTF_TERR_QUALIFIERS_V
Subobject Name:
Status:	VALID

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

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.

[View Source]

Columns

Name	Datatype	Length	Comments
ROW_ID	ROWID	(10)
TERR_QUAL_ID	NUMBER
LAST_UPDATE_DATE	DATE		Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY	NUMBER		Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATION_DATE	DATE		Standard who column - date when this row was created.
CREATED_BY	NUMBER		Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN	NUMBER		Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
TERR_ID	NUMBER
QUAL_USG_ID	NUMBER
QUALIFIER_MODE	VARCHAR2	(30)
OVERLAP_ALLOWED_FLAG	VARCHAR2	(1)
USE_TO_NAME_FLAG	VARCHAR2	(1)
GENERATE_FLAG	VARCHAR2	(1)
ORG_ID	NUMBER		Organization identifier
DISPLAY_TYPE	VARCHAR2	(40)
LOV_SQL	VARCHAR2	(1000)
CONVERT_TO_ID_FLAG	VARCHAR2	(1)
COLUMN_COUNT	NUMBER		The number of columns used to store a qualifier's value(s).
FORMATTING_FUNCTION_FLAG	VARCHAR2	(1)	This flag indicates whether special formatting is enabled for a qualifier. This is useful for special cases like currency and postal code qualifiers.
FORMATTING_FUNCTION_NAME	VARCHAR2	(120)	Name of the formatting function, package.function format.
SPECIAL_FUNCTION_FLAG	VARCHAR2	(1)	This flag indicates whether a special function call is enabled or disabled for qualifiers. This is to take care of 1-to-Many relations like Interest Type for Sales and Keywords.
SPECIAL_FUNCTION_NAME	VARCHAR2	(120)	Name of the special function that is being called, package.function format.
ENABLE_LOV_VALIDATION	VARCHAR2	(1)	This is used for turning LOV Validation on/off for a qualifier.
DISPLAY_SQL1	VARCHAR2	(1000)	Stores the SQL to retrieve the descriptive value for the territory value. For example, it will return the party name, interest type, meaning for the party id, interest type id, and lookup code values respectively.
LOV_SQL2	VARCHAR2	(1000)	This is the SQL statement that will be used to populate the LOV, from which the user can select values for the qualifier.
DISPLAY_SQL2	VARCHAR2	(1000)	Stores the SQL to retrieve the descriptive value for the territory value. For example, it will return the party name, interest type, meaning for the party id, interest type id, and lookup code values respectively.
LOV_SQL3	VARCHAR2	(1000)	This is the SQL statement that will be used to populate the LOV, from which the user can select values for the qualifier.
DISPLAY_SQL3	VARCHAR2	(1000)	Stores the SQL to retrieve the descriptive value for the territory value. For example, it will return the party name, interest type, meaning for the party id, interest type id, and lookup code values respectively.
QUAL_TYPE_ID	NUMBER
QUALIFIER_TYPE_NAME	VARCHAR2	(40)
QUALIFIER_TYPE_DESCRIPTION	VARCHAR2	(80)
QUALIFIER_NAME	VARCHAR2	(60)
QUALIFIER_MODE_DESC	VARCHAR2	(80)

Query Text

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


SELECT ROW_ID
,      TERR_QUAL_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      TERR_ID
,      QUAL_USG_ID
,      QUALIFIER_MODE
,      OVERLAP_ALLOWED_FLAG
,      USE_TO_NAME_FLAG
,      GENERATE_FLAG
,      ORG_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
,      QUAL_TYPE_ID
,      QUALIFIER_TYPE_NAME
,      QUALIFIER_TYPE_DESCRIPTION
,      QUALIFIER_NAME
,      QUALIFIER_MODE_DESC
FROM APPS.JTF_TERR_QUALIFIERS_V;

Dependencies

[top of page]

APPS.JTF_TERR_QUALIFIERS_V references the following:

APPS: FND_GLOBAL - show dependent code; FND_LOOKUPS; JTF_QUAL_TYPES; JTF_QUAL_TYPE_USGS; JTF_QUAL_USGS; JTF_SEEDED_QUAL; JTF_TERR_QUAL

APPS.JTF_TERR_QUALIFIERS_V is referenced by following:

APPS: JTF_TERRITORY_GET_PUB - show dependent code; JTF_TERR_CHANGES_REPORT_PVT - show dependent code; JTF_TERR_DEFINITION_REPORT_PVT - show dependent code; JTF_TERR_JSP_REPORTS - show dependent code; JTF_TERR_SRCH_ADV_ESCL_V; JTF_TERR_SRCH_ADV_MAIN_V; JTF_TERR_SRCH_ADV_TEMP_V; JTF_TERR_SRCH_TEMP_V