VIEW: APPS.JTF_TERR_WINNERS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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