title: How to create a PL/SQL package to discard multiple level of cascading views
body: <p>I am working on a CR where I need to create a PL/SQL package and I am bit confused about the approach.</p>
  
  <p>Background : There is a View named <b>‘D’</b> which is at end of the chain of interdependent views in sequence.<br>
  We can put it as :<br>
  A – Fact table (Populated using Informatica, source MS-Dynamics)<br>
  B – View 1 based on fact table<br>
  C – View 2 based on View1<br>
  D – View 3 based on view2<br>
  Each view has multiple joins with other tables in structure along with the base view.  </p>
  
  <p>Requirement: Client wants to remove all these views and create a PL/SQL Package which can insert data directly from MS-Dynamics to View3 i.e., ‘D’.</p>
  
  <p>Before I come up with something complex. I would like to know, is there any standard approach to address such requirements.</p>
  
  <p>Any advice/suggestions are appreciated.</p>