MATERIALIZED VIEW: APPS.JTF_TERR_CNR_QUAL_LIKE_MV

Source

SELECT /*+ ORDERED */
  r.rowid rule_rowid
, q.rowid qual_rowid
, v.rowid val_rowid
, r.terr_id terr_id
, r.absolute_rank absolute_rank
, r.related_terr_id related_terr_id
, r.top_level_terr_id top_level_terr_id
, r.num_winners num_winners
, r.source_id source_id
, q.qual_usg_id qual_usg_id
, q.terr_qual_id terr_qual_id
, v.terr_value_id  terr_value_id
, UPPER(v.low_value_char) low_value_char
, CAST( SUBSTR(UPPER(v.low_value_char), 1, 1) AS VARCHAR2(3) ) first_char
FROM jtf_terr_denorm_rules_all r
   , jtf_terr_qual_all q
   , jtf_terr_values_all v
WHERE r.source_id = -1001
  AND q.terr_id = r.related_terr_id
  AND v.terr_qual_id = q.terr_qual_id
  AND q.qual_usg_id = -1012
  AND v.comparison_operator = 'LIKE'