Product: | JTF - CRM Foundation |
---|---|
Description: | All Enabled Attributes View |
Implementation/DBA Data: | APPS.JTY_ALL_ENABLED_ATTRIBUTES_V |
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
, -1206
, -1207
, -1208
, -1209)
AND JQU.ENABLED_FLAG = 'Y'