APPS.POA_EDW_CSTM_MSR_F_SIZE SQL Statements

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

Line: 12

    select count(*) into p_num_rows
      from
	   poa_cm_evaluation		pme,
	   poa_cm_eval_scores		pms
     WHERE pme.evaluation_id = pms.evaluation_id
       and greatest(pme.last_update_date, pms.last_update_date)
             between p_from_date and p_to_date;

Line: 59

        SELECT  avg(nvl(vsize(custom_measure_code), 0)),
        avg(nvl(vsize(supplier_site_id), 0)),
        avg(nvl(vsize(oper_unit_id), 0)),
        avg(nvl(vsize(item_id), 0)),
        avg(nvl(vsize(category_id), 0)),
        avg(nvl(vsize(comments), 0)),
        avg(nvl(vsize(evaluation_id), 0))
        from poa_cm_evaluation
        where last_update_date between
                  p_from_date  and  p_to_date;

Line: 71

        SELECT  avg(nvl(vsize(evaluation_score_id), 0)),
        avg(nvl(vsize(criteria_code), 0)),
        avg(nvl(vsize(score), 0)),
        avg(nvl(vsize(weight), 0)),
        avg(nvl(vsize(min_score), 0)),
        avg(nvl(vsize(max_score), 0)),
        avg(nvl(vsize(comments), 0))
        from poa_cm_eval_scores
        where last_update_date between
                  p_from_date  and  p_to_date;

Line: 83

        SELECT  avg(nvl(vsize(user_name), 0))
        from fnd_user
        where last_update_date between
                   p_from_date  and  p_to_date;