VIEW: APPS.JTF_TERR_QUALIFIERS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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