VIEW: APPS.JTF_TERR_QUAL_RULES_MV#

Source

View Text - Preformatted

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.terr_qual_id terr_qual_id
, q.qual_usg_id qual_usg_id
, v.terr_value_id  terr_value_id
, v.comparison_operator comparison_operator
, v.low_value_char_id low_value_char_id
, UPPER(v.low_value_char) low_value_char
, UPPER(v.high_value_char) high_value_char
, v.low_value_number low_value_number
, v.high_value_number high_value_number
, v.interest_type_id interest_type_id
, v.primary_interest_code_id primary_interest_code_id
, v.secondary_interest_code_id secondary_interest_code_id
, v.currency_code currency_code
, v.value1_id value1_id
, v.value2_id value2_id
, v.value3_id value3_id
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 <> -1102
  AND NOT ( q.qual_usg_id = -1012 AND
            ( v.comparison_operator = 'LIKE' OR v.comparison_operator = 'BETWEEN' )
          )

View Text - HTML Formatted

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.TERR_QUAL_ID TERR_QUAL_ID
, Q.QUAL_USG_ID QUAL_USG_ID
, V.TERR_VALUE_ID TERR_VALUE_ID
, V.COMPARISON_OPERATOR COMPARISON_OPERATOR
, V.LOW_VALUE_CHAR_ID LOW_VALUE_CHAR_ID
, UPPER(V.LOW_VALUE_CHAR) LOW_VALUE_CHAR
, UPPER(V.HIGH_VALUE_CHAR) HIGH_VALUE_CHAR
, V.LOW_VALUE_NUMBER LOW_VALUE_NUMBER
, V.HIGH_VALUE_NUMBER HIGH_VALUE_NUMBER
, V.INTEREST_TYPE_ID INTEREST_TYPE_ID
, V.PRIMARY_INTEREST_CODE_ID PRIMARY_INTEREST_CODE_ID
, V.SECONDARY_INTEREST_CODE_ID SECONDARY_INTEREST_CODE_ID
, V.CURRENCY_CODE CURRENCY_CODE
, V.VALUE1_ID VALUE1_ID
, V.VALUE2_ID VALUE2_ID
, V.VALUE3_ID VALUE3_ID 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 <> -1102
AND NOT ( Q.QUAL_USG_ID = -1012 AND ( V.COMPARISON_OPERATOR = 'LIKE' OR V.COMPARISON_OPERATOR = 'BETWEEN' ) )