VIEW: APPS.JTY_ALL_ENABLED_ATTRIBUTES_V

Source

View Text - Preformatted

SELECT DISTINCT JQU.QUAL_USG_ID , JQU.APPLICATION_SHORT_NAME , JQU.SEEDED_QUAL_ID , JQU.QUAL_TYPE_USG_ID , JQU.SEEDED_FLAG SEEDED_FLAG , JQU.DISPLAY_TYPE DISPLAY_TYPE , JQU.CONVERT_TO_ID_FLAG CONVERT_TO_ID_FLAG , JSQ.NAME SEEDED_QUAL_NAME , JSQ.DESCRIPTION DESCRIPTION , JQTU.QUAL_TYPE_ID QUAL_TYPE_ID , JQT.NAME QUALIFIER_TYPE_NAME , JQT.DESCRIPTION QUALIFIER_TYPE_DESCRIPTION , JSE.SOURCE_ID SOURCE_ID , JSE.LOOKUP_CODE LOOKUP_CODE , JSE.MEANING USAGE FROM JTF_QUAL_USGS_ALL JQU , JTF_SEEDED_QUAL_ALL JSQ , JTF_QUAL_TYPE_USGS_ALL JQTU , JTF_QUAL_TYPES_ALL JQT , JTF_SOURCES_ALL JSE WHERE 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 JQTU.SOURCE_ID = JSE.SOURCE_ID and JQU.QUAL_USG_ID NOT IN (-1201, -1202, -1203, -1204, -1205, -1207, -1208, -1209) and JQU.ENABLED_FLAG = 'Y'

View Text - HTML Formatted

SELECT DISTINCT JQU.QUAL_USG_ID
, JQU.APPLICATION_SHORT_NAME
, JQU.SEEDED_QUAL_ID
, JQU.QUAL_TYPE_USG_ID
, JQU.SEEDED_FLAG SEEDED_FLAG
, JQU.DISPLAY_TYPE DISPLAY_TYPE
, JQU.CONVERT_TO_ID_FLAG CONVERT_TO_ID_FLAG
, JSQ.NAME SEEDED_QUAL_NAME
, JSQ.DESCRIPTION DESCRIPTION
, JQTU.QUAL_TYPE_ID QUAL_TYPE_ID
, JQT.NAME QUALIFIER_TYPE_NAME
, JQT.DESCRIPTION QUALIFIER_TYPE_DESCRIPTION
, JSE.SOURCE_ID SOURCE_ID
, JSE.LOOKUP_CODE LOOKUP_CODE
, JSE.MEANING USAGE
FROM JTF_QUAL_USGS_ALL JQU
, JTF_SEEDED_QUAL_ALL JSQ
, JTF_QUAL_TYPE_USGS_ALL JQTU
, JTF_QUAL_TYPES_ALL JQT
, JTF_SOURCES_ALL JSE
WHERE 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 JQTU.SOURCE_ID = JSE.SOURCE_ID
AND JQU.QUAL_USG_ID NOT IN (-1201
, -1202
, -1203
, -1204
, -1205
, -1207
, -1208
, -1209)
AND JQU.ENABLED_FLAG = 'Y'