title: List months between dates and display accross columns
body: <p>I have a really simple script that shows 3 component catalog numbers and their new release dates ...</p>
  
  <pre><code>        SELECT nrb.p_catnr,
                 (
                     select min(selection_relse_date) 
                       from BDS_SELECTION_ORG@sid_to_cdsuk st 
                      where substr(selection_no, 2, 99) = pd.catnr
                 ) NR_DATE
            FROM part_description pd 
      INNER JOIN inventory_purchase ip 
              ON ip.part_no = pd.part_no 
      INNER JOIN scm_prodtyp pt 
              ON pt.prodtyp = pd.prodtyp 
      INNER JOIN oes_fod_match acp 
              ON acp.part_no = pd.part_no 
      INNER JOIN NCF_COMPPART ncf 
              ON ncf.item_part_no = pd.part_no 
      INNER JOIN oes_nrbom nrb 
              ON ncf.catnr = nrb.c_catnr 
             AND ncf.prodtyp = nrb.c_prodtyp 
             AND ncf.packtyp = nrb.c_packtyp 
             AND ncf.vernr = nrb.c_vernr 
           WHERE pd.cunr in ('649830', 'W30000') 
             AND pd.catnr = '2EDVD0017' 
             AND pd.fod_idc = 'Y' 
             AND pt.prodgrp = 'AW'
  </code></pre>
  
  <p>Result as follows...</p>
  
  <p><img src="https://i.stack.imgur.com/7sgTG.png" alt="enter image description here"></p>
  
  <p>What I would like to add is a list of every month &amp; year (MON-YYYY) from the NR_DATE to current date but, I would like to add this horizontally, i.e.</p>
  
  <p><img src="https://i.stack.imgur.com/Jm3qu.png" alt="enter image description here"></p>
  
  <p>Then I would like to add the following script...</p>
  
  <pre><code>(select nvl(sum(dp.del_qty),0) 
     from bds_dhead@sid_to_cdsuk dh, 
          bds_dline@sid_to_cdsuk dp 
    where dp.dhead_no = dh.dhead_no 
      and dh.d_status = '9' 
      and dp.article_no = '9'||nrb.p_catnr 
      and to_char(dh.actshpdate,'MON-YYYY') = --'list of months' 
  </code></pre>
  
  <p>and plot the sums in the correct column/row.</p>
  
  <p>Is this possible?</p>
  
  <p>Thanks</p>