MATERIALIZED VIEW: APPS.CN_SCA_RULE_COND_VALS_MV

Source

SELECT /*+ ORDERED AUTOREFRESH */
       sdr.rowid rule_rowid,
       sc.rowid cond_rowid,
       scd.rowid cond_detail_rowid,
       sdr.sca_credit_rule_id,
       sdr.calculated_rank,
       sdr.ancestor_rule_id,
       sdr.start_date,
       sdr.end_date,
       SDR.TRANSACTION_SOURCE,
       sc.sca_condition_id,
       sc.sca_rule_attribute_id,
       scd.sca_cond_detail_id,
       scd.operator_id,
       scd.value_char_min,
       scd.value_char_max,
       scd.value_num_min,
       scd.value_num_max,
       scd.value_date_min,
       scd.value_date_max
  FROM CN.CN_SCA_DENORM_RULES_ALL sdr,
       CN.CN_SCA_CONDITIONS_ALL sc,
       CN.CN_SCA_COND_DETAILS_ALL scd
 WHERE SC.SCA_CREDIT_RULE_ID = SDR.ANCESTOR_RULE_ID
   AND sc.sca_condition_id = scd.sca_condition_id