title: How can I create view in SQL without duplicate entries?
body: <p><strong>First I have Table SUM_REPANDMAINT,
  Table`s Column name:</strong></p>
  
  <p>ACTUAL_COST,
  PROJECTED_COST,
  TOTAL_PREV,
  TOTAL_PRESENT,
  VARIANCE,
  VARIANCE_PER,
  LIMIT,
  COST_CENTER,
  ID,
  PLANT,
  BUDGET_YEAR,
  VERSION,</p>
  
  <p><strong>Second I have View V_SUM_REPANDMAINT,
  View`s Column name:</strong></p>
  
  <p>USERNAME,
  CHARGE_CC,
  BUDGET_YEAR,
  VERSION,
  PLANT,
  CHARGE_CC,
  PART_DESC,
  YEAR_DATE_USD,</p>
  
  <p>This images may help understand the issue:</p>
  
  <p><a href="https://i.stack.imgur.com/B23ty.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/B23ty.png" alt="enter image description here"></a></p>
  
  <p><a href="https://i.stack.imgur.com/cCP0R.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/cCP0R.png" alt="enter image description here"></a></p>
  
  <p>I need to get non repeating values.</p>
  
  <p>Note: The sum of YEAR_DATE_USD is based on PLANT AND CHARGE_CC </p>
  
  <p>My Query:</p>
  
  <pre><code>SELECT 
     A.ACTUAL_COST,
     A.PROJECTED_COST,
     A.TOTAL_PREV,
     A.TOTAL_PRESENT,
     A.VARIANCE,
     A.VARIANCE_PER,
     A."LIMIT",
     A.COST_CENTER,
     A.PLANT,
     A.BUDGET_YEAR,
     A."VERSION",
     B.BUDGET_YEAR,
     B."VERSION",
     B.PLANT,
     B.CHARGE_CC,
     B.PART_DESC,
     B.YEAR_DATE_USD
  FROM
     CMS.SUM_REPANDMAINT A,
     CMS.V_SUM_REPANDMAINT B
  
  WHERE 
     (A.BUDGET_YEAR = B.BUDGET_YEAR(+)) AND 
     (A."VERSION" = B."VERSION"(+)) AND 
     (A.PLANT = B.PLANT(+)) AND 
     (A.COST_CENTER = B.CHARGE_CC(+)) AND
     (B.USERNAME = '[usr_name]')
  </code></pre>