MATERIALIZED VIEW: APPS.JTF_TERR_CNRG_BTWN_MV

Source

SELECT /*+ ORDERED */ "A4".ROWID "RULE_ROWID","A5".ROWID "QUAL_ROWID","A3".ROWID "VAL_ROWID","A2".ROWID "CNRG_ROWID","A1".ROWID "CNRG_VAL_ROWID","A4"."TERR_ID" "TERR_ID","A4"."ABSOLUTE_RANK" "ABSOLUTE_RANK","A4"."RELATED_TERR_ID" "RELATED_TERR_ID","A4"."TOP_LEVEL_TERR_ID" "TOP_LEVEL_TERR_ID","A4"."NUM_WINNERS" "NUM_WINNERS","A4"."SOURCE_ID" "SOURCE_ID","A5"."TERR_QUAL_ID" "TERR_QUAL_ID","A5"."QUAL_USG_ID" "QUAL_USG_ID","A3"."TERR_VALUE_ID" "TERR_VALUE_ID","A2"."CNR_GROUP_ID" "CNR_GROUP_ID","A1"."CNR_GROUP_VALUE_ID" "CNR_GROUP_VALUE_ID","A1"."COMPARISON_OPERATOR" "COMPARISON_OPERATOR",UPPER("A1"."LOW_VALUE_CHAR") "LOW_VALUE_CHAR",UPPER("A1"."HIGH_VALUE_CHAR") "HIGH_VALUE_CHAR" FROM "JTF"."JTF_TERR_QUAL_ALL" "A5","JTF"."JTF_TERR_DENORM_RULES_ALL" "A4","JTF"."JTF_TERR_VALUES_ALL" "A3","JTF"."JTF_TERR_CNR_GROUPS" "A2","JTF"."JTF_TERR_CNR_GROUP_VALUES" "A1" WHERE "A4"."SOURCE_ID"=(-1001) AND "A5"."QUAL_USG_ID"=(-1102) AND "A5"."TERR_ID"="A4"."RELATED_TERR_ID" AND "A3"."TERR_QUAL_ID"="A5"."TERR_QUAL_ID" AND "A2"."CNR_GROUP_ID"="A3"."LOW_VALUE_CHAR_ID" AND "A1"."CNR_GROUP_ID"="A2"."CNR_GROUP_ID" AND ("A1"."COMPARISON_OPERATOR"='BETWEEN' OR "A1"."COMPARISON_OPERATOR"='NOT BETWEEN')