APPS.ENI_DBI_RVD_PKG SQL Statements

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

Line: 100

 SELECT ENI_ATTRIBUTE3
      , ENI_ATTRIBUTE4
      , cust.value  ENI_ATTRIBUTE5
      , ENI_ATTRIBUTE6
      , ENI_MEASURE1
      , ENI_MEASURE2
      , ENI_MEASURE3
   FROM
(SELECT (rank() over (&ORDER_BY_CLAUSE, ENI_ATTRIBUTE3, ENI_ATTRIBUTE4, inv_org_id)) - 1    rnk,
        customer_id
      , inv_org_id
      , ENI_ATTRIBUTE3
      , ENI_ATTRIBUTE4
      , ENI_ATTRIBUTE6
      , ENI_MEASURE1
      , ENI_MEASURE2
      , ENI_MEASURE3
   FROM
(SELECT mv.customer_id                                      CUSTOMER_ID
      , mv.inv_org_id                                       INV_ORG_ID
      , mv.order_number                                     ENI_ATTRIBUTE3
      , mv.header_id                                        ENI_MEASURE3
      , mv.line_number                                      ENI_ATTRIBUTE4
      , mv.time_fulfilled_date_id                           ENI_ATTRIBUTE6
      , mv.returned_amt_'||l_curr_suffix||'                 ENI_MEASURE1
      , sum(mv.returned_amt_'||l_curr_suffix||') over()     ENI_MEASURE2
   FROM ISC_DBI_CFM_003_MV  mv'
      ||l_prod_cat_from||'
  WHERE mv.time_fulfilled_date_id BETWEEN &BIS_CURRENT_EFFECTIVE_START_DATE
                                  AND     &BIS_CURRENT_ASOF_DATE'
    ||l_prod_cat_where
    ||l_prod_where
    ||l_cust_where
    ||l_ret_reason_where||'))   a
  , FII_CUSTOMERS_V             cust
  WHERE a.customer_id = cust.id
    AND ((a.rnk between &START_INDEX and &END_INDEX) OR (&END_INDEX = -1))
  &ORDER_BY_CLAUSE NULLS LAST';