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.

[Home] [Help]

View: JTF_TERR_QUALIFIERS_V

Product:	JTF - CRM Foundation
Description:	This shows the qualifiers used to define a territory.
Implementation/DBA Data:	APPS.JTF_TERR_QUALIFIERS_V

View Text

SELECT JTQ.ROWID ROW_ID
, JTQ.TERR_QUAL_ID TERR_QUAL_ID
, JTQ.LAST_UPDATE_DATE LAST_UPDATE_DATE
, JTQ.LAST_UPDATED_BY LAST_UPDATED_BY
, JTQ.CREATION_DATE CREATION_DATE
, JTQ.CREATED_BY CREATED_BY
, JTQ.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, JTQ.TERR_ID TERR_ID
, JTQ.QUAL_USG_ID QUAL_USG_ID
, JTQ.QUALIFIER_MODE QUALIFIER_MODE
, JTQ.OVERLAP_ALLOWED_FLAG OVERLAP_ALLOWED_FLAG
, JTQ.USE_TO_NAME_FLAG USE_TO_NAME_FLAG
, JTQ.GENERATE_FLAG GENERATE_FLAG
, JTQ.ORG_ID ORG_ID
, JQU.DISPLAY_TYPE DISPLAY_TYPE
, JQU.LOV_SQL LOV_SQL
, JQU.CONVERT_TO_ID_FLAG CONVERT_TO_ID_FLAG
, JQU.COLUMN_COUNT
, JQU.FORMATTING_FUNCTION_FLAG
, JQU.FORMATTING_FUNCTION_NAME
, JQU.SPECIAL_FUNCTION_FLAG
, JQU.SPECIAL_FUNCTION_NAME
, JQU.ENABLE_LOV_VALIDATION
, JQU.DISPLAY_SQL1
, JQU.LOV_SQL2
, JQU.DISPLAY_SQL2
, JQU.LOV_SQL3
, JQU.DISPLAY_SQL3
, JQTU.QUAL_TYPE_ID QUAL_TYPE_ID
, JQT.NAME QUALIFIER_TYPE_NAME
, JQT.DESCRIPTION QUALIFIER_TYPE_DESCRIPTION
, JSQ.NAME QUALIFIER_NAME
, NULL QUALIFIER_MODE_DESC
FROM JTF_TERR_QUAL JTQ
, JTF_QUAL_USGS JQU
, JTF_SEEDED_QUAL JSQ
, JTF_QUAL_TYPE_USGS JQTU
, JTF_QUAL_TYPES JQT
WHERE JTQ.QUAL_USG_ID = JQU.QUAL_USG_ID
AND JQU.SEEDED_QUAL_ID = JSQ.SEEDED_QUAL_ID
AND JQU.QUAL_TYPE_USG_ID = JQTU.QUAL_TYPE_USG_ID
AND JQTU.QUAL_TYPE_ID = JQT.QUAL_TYPE_ID
AND JTQ.QUALIFIER_MODE IS NULL UNION ALL SELECT JTQ.ROWID ROW_ID
, JTQ.TERR_QUAL_ID TERR_QUAL_ID
, JTQ.LAST_UPDATE_DATE LAST_UPDATE_DATE
, JTQ.LAST_UPDATED_BY LAST_UPDATED_BY
, JTQ.CREATION_DATE CREATION_DATE
, JTQ.CREATED_BY CREATED_BY
, JTQ.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, JTQ.TERR_ID TERR_ID
, JTQ.QUAL_USG_ID QUAL_USG_ID
, JTQ.QUALIFIER_MODE QUALIFIER_MODE
, JTQ.OVERLAP_ALLOWED_FLAG OVERLAP_ALLOWED_FLAG
, JTQ.USE_TO_NAME_FLAG USE_TO_NAME_FLAG
, JTQ.GENERATE_FLAG GENERATE_FLAG
, JTQ.ORG_ID ORG_ID
, JQU.DISPLAY_TYPE DISPLAY_TYPE
, JQU.LOV_SQL LOV_SQL
, JQU.CONVERT_TO_ID_FLAG CONVERT_TO_ID_FLAG
, JQU.COLUMN_COUNT
, JQU.FORMATTING_FUNCTION_FLAG
, JQU.FORMATTING_FUNCTION_NAME
, JQU.SPECIAL_FUNCTION_FLAG
, JQU.SPECIAL_FUNCTION_NAME
, JQU.ENABLE_LOV_VALIDATION
, JQU.DISPLAY_SQL1
, JQU.LOV_SQL2
, JQU.DISPLAY_SQL2
, JQU.LOV_SQL3
, JQU.DISPLAY_SQL3
, JQTU.QUAL_TYPE_ID QUAL_TYPE_ID
, JQT.NAME QUALIFIER_TYPE_NAME
, JQT.DESCRIPTION QUALIFIER_TYPE_DESCRIPTION
, JSQ.NAME QUALIFIER_NAME
, F.MEANING QUALIFIER_MODE_DESC
FROM JTF_TERR_QUAL JTQ
, JTF_QUAL_USGS JQU
, JTF_SEEDED_QUAL JSQ
, JTF_QUAL_TYPE_USGS JQTU
, JTF_QUAL_TYPES JQT
, FND_LOOKUPS F
WHERE JTQ.QUAL_USG_ID = JQU.QUAL_USG_ID
AND JQU.SEEDED_QUAL_ID = JSQ.SEEDED_QUAL_ID
AND JQU.QUAL_TYPE_USG_ID = JQTU.QUAL_TYPE_USG_ID
AND JQTU.QUAL_TYPE_ID = JQT.QUAL_TYPE_ID
AND JTQ.QUALIFIER_MODE IS NOT NULL
AND JTQ.QUALIFIER_MODE = F.LOOKUP_CODE
AND F.LOOKUP_TYPE = 'JTF_TERR_QUALIFIER_MODE'
AND JTQ.ORG_ID = JQU.ORG_ID

Columns

Name
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