APPS.BIV_TREND_RPT_PKG SQL Statements

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

Line: 9

    select
      sum(decode(current_ind,1,1,0)) cur_rows
    , min(decode(current_ind,1,offset,null)) cur_min
    , max(decode(current_ind,1,offset,null)) cur_max
    , sum(decode(current_ind,1,offset,null)) cur_sum
    , sum(decode(current_ind,2,1,0)) prior_rows
    , min(decode(current_ind,2,offset,null)) prior_min
    , max(decode(current_ind,2,offset,null)) prior_max
    , sum(decode(current_ind,2,offset,null)) prior_sum
    , sum(decode(current_ind,4,1,0)) opening_rows
    , min(decode(current_ind,4,offset,null)) opening_min
    , max(decode(current_ind,4,offset,null)) opening_max
    , sum(decode(current_ind,4,offset,null)) opening_sum
    from biv_trend_rpt;

Line: 55

    delete from biv_trend_rpt;

Line: 60

          insert into biv_trend_rpt
          ( current_ind
          , offset
          , creation_date
          , created_by
          , last_update_date
          , last_updated_by
          , last_update_login )
          values
          ( c
          , 0-o
          , sysdate
          , fnd_global.user_id
          , sysdate
          , fnd_global.user_id
          , fnd_global.login_id );