View: JTF_TERR_WINNERS_V

Product:	JTF - CRM Foundation
Description:
Implementation/DBA Data:	APPS.JTF_TERR_WINNERS_V

View Text

SELECT JTDR.ABSOLUTE_RANK ABSOLUTE_RANK
, JTDR.TERR_ID TERR_ID
, JTDR.NUM_QUAL NUM_QUAL
, JTDR.TOP_LEVEL_TERR_ID TOP_LEVEL_TERR_ID
, JTDR.QUAL_TYPE_ID QUAL_TYPE_ID
, JTDR.SOURCE_ID SOURCE_ID
FROM JTF_TERR_DENORM_RULES JTDR
WHERE JTDR.RELATED_TERR_ID = JTDR.TERR_ID ORDER BY JTDR.ABSOLUTE_RANK DESC

Columns