APPS.CS_COUNTERS_EXT_PVT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 183

    SELECT bind_var_name, mapped_counter_id AS counter_id,
           mapped_inv_item_id
    FROM cs_ctr_formula_bvars
    WHERE counter_id  = p_counter_id;

Line: 234

        SELECT formula_text INTO l_formula
        FROM cs_counters
        WHERE counter_id= p_counter_id;

Line: 247

        l_formula := 'SELECT '||l_formula||' FROM DUAL';

Line: 342

    SELECT distinct ctr.counter_id, ctr.derive_function,
      ctr.derive_counter_id, ctr.derive_property_id
    FROM cs_counters ctr
    WHERE ctr.counter_id = p_counter_id;

Line: 347

    SELECT filt.counter_property_id, filt.seq_no,filt.left_paren,
           filt.right_paren, filt.relational_operator,
           filt.logical_operator, filt.right_value,
           nvl(pro.default_value, 'NULL') as default_value,
           pro.property_data_type
    FROM cs_counter_der_filters filt, cs_counter_properties pro
    WHERE filt.counter_id = b_counter_id
      AND pro.counter_property_id(+) = filt.counter_property_id;

Line: 433

          l_sqlstr := 'select '||ctrs.derive_function||'( counter_reading )';

Line: 436

          l_sqlstr := l_sqlstr || ' select distinct cv.counter_value_id from ';