eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.CN_SCA_RULE_COND_VALS_MV#

Source

View Text - Preformatted


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_SCA_DENORM_RULES_ALL sdr,
       CN_SCA_CONDITIONS_ALL sc,
       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

View Text - HTML Formatted

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_SCA_DENORM_RULES_ALL SDR
, CN_SCA_CONDITIONS_ALL SC
, 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