VIEW: APPS.JTF_QUAL_TYPE_DENORM_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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