View: JTF_QUAL_TYPE_DENORM_V

Product:	JTF - CRM Foundation
Description:	De-normalized view of JTF_QUAL_TYPES table.
Implementation/DBA Data:	APPS.JTF_QUAL_TYPE_DENORM_V

View Text

SELECT QUAL_TYPE_ID
, RELATED_ID1
FROM JTF_QUAL_TYPES_ALL
WHERE RELATED_ID1 IS NOT NULL UNION SELECT QUAL_TYPE_ID
, RELATED_ID2
FROM JTF_QUAL_TYPES_ALL
WHERE RELATED_ID2 IS NOT NULL UNION SELECT QUAL_TYPE_ID
, RELATED_ID3
FROM JTF_QUAL_TYPES_ALL
WHERE RELATED_ID3 IS NOT NULL UNION SELECT QUAL_TYPE_ID
, RELATED_ID4
FROM JTF_QUAL_TYPES_ALL
WHERE RELATED_ID4 IS NOT NULL UNION SELECT QUAL_TYPE_ID
, RELATED_ID5
FROM JTF_QUAL_TYPES_ALL
WHERE RELATED_ID5 IS NOT NULL

Columns