All pastes #709080 Raw Edit

Unnamed

public text v1 · immutable
#709080 ·published 2007-09-24 11:01 UTC
rendered paste body
   String sql = "SELECT k.cust_id, market, k.no_order_follow_up, k.no_potential_contacts\n" +
            "  FROM kg_manual_frequency_options k\n";
    if (includedMMUsers != null) {
      sql = sql + "  JOIN user_mst u ON u.user_id = c.slspers_id\n";
    }
    sql = sql + " WHERE (no_order_follow_up = 1 OR no_potential_contacts = 1)";

    if (includedMMUsers != null) {
      StringBuffer sqlBuffer = new StringBuffer(sql);
      String kg_manual_frequency_options = "kg_manual_frequency_options k";
      sqlBuffer.insert(sqlBuffer.indexOf(kg_manual_frequency_options) + kg_manual_frequency_options.length(), ", cust_per_category c");

      sqlBuffer = sqlBuffer.append("\n").
              append("   AND c.cust_id = k.cust_id\n").
              append("   AND DECODE (c.CATEGORY, 'J', 0, 'O', 1) = k.market\n").
              append("   AND u.mm_user_id IN (").append(getCommaSeparated()).append(')');

      sql = sqlBuffer.toString();
    }