1. Temporary Tables
   1. ##artistTotalList
   2. #DetailedSalesOutput
   3. #planData
   4. #al_filter
   5. #UPCs
   6. ##pa_filter
   7. ##upc_actuals
   8. #actuals_preprocess
   9. #NRThresholds
   10. #actuals
   11. #finalOutput
2. Sub SPs
   1. Plan_SQL2XLS_DetailedSales_NR
      1. Temporary Tables
         1. #DetailedSalesNR
         2. #subTotal
         3. #Artists
         4. #tmpCursorsSuck
         5. #Metrics
         6. ##artistTotalList
         7. #Results
         8. ##DetailedSalesUB
         9. ##ubSubTotal
      2. Sub SPs
         1. Plan_SQL2XLS_DetailedSales_UB
            1. TemporaryTables
            2. ##DetailedSalesUB
            3. ##ubSubtotal
            4. #Metrics
            5. ##artistTotalList
            6. #ubResults
   2. Plan_SQL2XLS_DetailedSales_CO
      1. Temporary Tables
         1. #DetailedSalesCO
         2. #subTotal
         3. ##artistTotalList
         4. #Artists
         5. #Metrics
         6. #Results
   3. Plan_SQL2XLS_DetailedSales_Catalog
      1. Temporary Tables
         1. #DetailedSalesCatalog
         2. #catGrandTotal
         3. #catSubTotal
         4. #Metrics
         5. ##artistTotalList
         6. #catResults
   4. Plan_SQL2XLS_DetailedSales_NonArtist
      1. TemporaryTables
         1. #DetailedSalesNonArtist
         2. #subTotal
         3. #Metrics
         4. #Results
         5. ##artistTotalList
   5. Plan_GetActualsForUPCGroups_Digital
      1. Temporary Tables
         1. #al_filter
         2. #RPIDs
         3. #upc_list
         4. ##upc_actuals
      2. Sub SPs
         1. Plan_upc_actuals_PhysicalAlbums
            1. Temporary Tables
            2. al_filter
            3. #list
         2. Plan_upc_actuals_PhysicalSingles
            1. Temporary Tables
            2. #singles
         3. Plan_upc_actuals_PhysicalMusicVideo
            1. Temporary Tables
            2. #videos
         4. Plan_upc_actuals_PhysicalNonMusicVideo
            1. Temporary Tables
            2. #mvno
         5. Plan_upc_actuals_DigitalAlbums
            1. Temporary Tables
            2. #albums
         6. Plan_upc_actuals_DigitalTracks
            1. Temporary Tables
            2. #tracks
         7. Plan_upc_actuals_DigitalRingtones
            1. Temporary Tables
            2. #mobile
         8. Plan_upc_actuals_DigitalOther
            1. Temporary Tables
            2. #other
   6. Plan_GetActualsForUPCGroups_OpenMonth
      1. Temporary Tables
         1. #al_filter
         2. #RPIDs
         3. #upc_list
      2. Sub Views
         1. HfmScgID_28_Open
         2. HfmScgID_40_Open
         3. HfmScgID_41_Open
         4. HfmScgID_42_Open
         5. HfmScgID_43_Open
   7. Get the actual values with RPIDs and UPCs
   8. Get the forecasted data