APPS.OE_LINEINFO_GRP SQL Statements

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

Line: 35

  SELECT SUM(tax_value)
  INTO  l_order_tax_total
  FROM oe_order_lines_all
  WHERE header_id=p_header_id
  AND charge_periodicity_code is NULL
  AND NVL(cancelled_flag,'N') ='N'
  AND line_category_code<>'RETURN';

Line: 44

  SELECT SUM(tax_value)
  INTO  l_return_tax_total
  FROM oe_order_lines_all
  WHERE header_id=p_header_id
  AND charge_periodicity_code is NULL
  AND NVL(cancelled_flag,'N') ='N'
  AND line_category_code='RETURN';

Line: 70

   SELECT tax_code,tax_rate,tax_value,tax_date,tax_exempt_flag,tax_exempt_number,tax_exempt_reason_code
   into    x_tax_rec.tax_code,
           x_tax_rec.tax_rate,
           x_tax_rec.tax_amount,
           x_tax_rec.tax_date,
           x_tax_rec.tax_exempt_flag,
           x_tax_rec.tax_exempt_number,
           x_tax_rec.tax_exempt_reason_code
   FROM oe_order_lines_all
   Where header_id = p_header_id
   and   line_id   = p_line_id;