View: JTF_TR_SOURCE_DENORM_V

Product:	JTF - CRM Foundation
Description:	Territories Denormalized Source View
Implementation/DBA Data:	APPS.JTF_TR_SOURCE_DENORM_V

View Text

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

Columns