VIEW: APPS.JTF_TR_SOURCE_DENORM_V

Source

View Text - Preformatted

SELECT source_id, related_id1 from jtf_sources_all where related_id1 is not null union select source_id, related_id2 from jtf_sources_all where related_id2 is not null union select source_id, related_id3 from jtf_sources_all where related_id3 is not null union select source_id, related_id4 from jtf_sources_all where related_id4 is not null union select source_id, related_id5 from jtf_sources_all where related_id5 is not null

View Text - HTML Formatted

SELECT SOURCE_ID
, RELATED_ID1
FROM JTF_SOURCES_ALL
WHERE RELATED_ID1 IS NOT NULL UNION SELECT SOURCE_ID
, RELATED_ID2
FROM JTF_SOURCES_ALL
WHERE RELATED_ID2 IS NOT NULL UNION SELECT SOURCE_ID
, RELATED_ID3
FROM JTF_SOURCES_ALL
WHERE RELATED_ID3 IS NOT NULL UNION SELECT SOURCE_ID
, RELATED_ID4
FROM JTF_SOURCES_ALL
WHERE RELATED_ID4 IS NOT NULL UNION SELECT SOURCE_ID
, RELATED_ID5
FROM JTF_SOURCES_ALL
WHERE RELATED_ID5 IS NOT NULL