/* ************************************************ */
/*                                                  */
/* format the report:                               */
/*   Print the size of the AP (financial) files     */ 
/*                                                  */
/* name:    @c:\oracle\sql\file_sz1.sql             */
/* date:    12-MAY-95                               */
/* creator: Rick Kupcunas (Oracle)                  */
/*                                                  */
/* ************************************************ */

INSERT INTO temp_size_table  SELECT                                             
&temp_var.AP_1096_DATA&temp_var                                                 
, COUNT( DISTINCT( SUBSTR( ROWID,1,8))) blocks  FROM                            
AP.AP_1096_DATA                                                                 
;                                                                               
INSERT INTO temp_size_table  SELECT                                             
&temp_var.AP_1099_TAPE_DATA&temp_var                                            
, COUNT( DISTINCT( SUBSTR( ROWID,1,8))) blocks  FROM                            
AP.AP_1099_TAPE_DATA                                                            
;                                                                               
INSERT INTO temp_size_table  SELECT                                             
&temp_var.AP_AGING_PERIODS&temp_var                                             
, COUNT( DISTINCT( SUBSTR( ROWID,1,8))) blocks  FROM                            
AP.AP_AGING_PERIODS                                                             
;                                                                               
INSERT INTO temp_size_table  SELECT                                             
&temp_var.AP_AGING_PERIOD_LINES&temp_var                                        
, COUNT( DISTINCT( SUBSTR( ROWID,1,8))) blocks  FROM                            
AP.AP_AGING_PERIOD_LINES                                                        
;                                                                               
INSERT INTO temp_size_table  SELECT                                             
&temp_var.AP_BANK_ACCOUNTS&temp_var                                             
, COUNT( DISTINCT( SUBSTR( ROWID,1,8))) blocks  FROM                            
AP.AP_BANK_ACCOUNTS                                                             
;                                                                               
INSERT INTO temp_size_table  SELECT                                             
&temp_var.AP_BANK_ACCOUNT_USES&temp_var                                         
, COUNT( DISTINCT( SUBSTR( ROWID,1,8))) blocks  FROM                            
AP.AP_BANK_ACCOUNT_USES                                                         
;                                                                               
INSERT INTO temp_size_table  SELECT                                             
&temp_var.AP_BANK_BRANCHES&temp_var                                             
, COUNT( DISTINCT( SUBSTR( ROWID,1,8))) blocks  FROM                            
AP.AP_BANK_BRANCHES                                                             
;                                                                               
INSERT INTO temp_size_table  SELECT                                             
&temp_var.AP_BATCHES&temp_var                                                   
, COUNT( DISTINCT( SUBSTR( ROWID,1,8))) blocks  FROM                            
AP.AP_BATCHES                                                                   
;                                                                               
INSERT INTO temp_size_table  SELECT                                             
&temp_var.AP_CHECKRUN_CONC_PROCESSES&temp_var                                   
, COUNT( DISTINCT( SUBSTR( ROWID,1,8))) blocks  FROM                            
AP.AP_CHECKRUN_CONC_PROCESSES                                                   
;                                                                               
INSERT INTO temp_size_table  SELECT                                             
&temp_var.AP_CHECKRUN_CONFIRMATIONS&temp_var                                    
, COUNT( DISTINCT( SUBSTR( ROWID,1,8))) blocks  FROM                            
AP.AP_CHECKRUN_CONFIRMATIONS                                                    
;                                                                               
INSERT INTO temp_size_table  SELECT                                             
&temp_var.AP_CHECKS&temp_var                                                    
, COUNT( DISTINCT( SUBSTR( ROWID,1,8))) blocks  FROM                            
AP.AP_CHECKS                                                                    
;                                                                               
INSERT INTO temp_size_table  SELECT                                             
&temp_var.AP_CHECK_FORMATS&temp_var                                             
, COUNT( DISTINCT( SUBSTR( ROWID,1,8))) blocks  FROM                            
AP.AP_CHECK_FORMATS                                                             
;                                                                               
INSERT INTO temp_size_table  SELECT                                             
&temp_var.AP_CHECK_INTEGERS&temp_var                                            
, COUNT( DISTINCT( SUBSTR( ROWID,1,8))) blocks  FROM                            
AP.AP_CHECK_INTEGERS                                                            
;                                                                               
INSERT INTO temp_size_table  SELECT                                             
&temp_var.AP_CHECK_STOCKS&temp_var                                              
, COUNT( DISTINCT( SUBSTR( ROWID,1,8))) blocks  FROM                            
AP.AP_CHECK_STOCKS                                                              
;                                                                               
INSERT INTO temp_size_table  SELECT                                             
&temp_var.AP_CHECK_TRANSMISSIONS&temp_var                                       
, COUNT( DISTINCT( SUBSTR( ROWID,1,8))) blocks  FROM                            
AP.AP_CHECK_TRANSMISSIONS                                                       
;                                                                               
INSERT INTO temp_size_table  SELECT                                             
&temp_var.AP_DISTRIBUTION_SETS&temp_var                                         
, COUNT( DISTINCT( SUBSTR( ROWID,1,8))) blocks  FROM                            
AP.AP_DISTRIBUTION_SETS                                                         
;                                                                               
INSERT INTO temp_size_table  SELECT                                             
&temp_var.AP_DISTRIBUTION_SET_LINES&temp_var                                    
, COUNT( DISTINCT( SUBSTR( ROWID,1,8))) blocks  FROM                            
AP.AP_DISTRIBUTION_SET_LINES                                                    
;                                                                               
INSERT INTO temp_size_table  SELECT                                             
&temp_var.AP_DOC_SEQUENCE_AUDIT&temp_var                                        
, COUNT( DISTINCT( SUBSTR( ROWID,1,8))) blocks  FROM                            
AP.AP_DOC_SEQUENCE_AUDIT                                                        
;                                                                               
INSERT INTO temp_size_table  SELECT                                             
&temp_var.AP_DUPLICATE_VENDORS&temp_var                                         
, COUNT( DISTINCT( SUBSTR( ROWID,1,8))) blocks  FROM                            
AP.AP_DUPLICATE_VENDORS                                                         
;                                                                               
INSERT INTO temp_size_table  SELECT                                             
&temp_var.AP_EXPENSE_REPORTS&temp_var                                           
, COUNT( DISTINCT( SUBSTR( ROWID,1,8))) blocks  FROM                            
AP.AP_EXPENSE_REPORTS                                                           
;                                                                               
INSERT INTO temp_size_table  SELECT                                             
&temp_var.AP_EXPENSE_REPORT_HEADERS&temp_var                                    
, COUNT( DISTINCT( SUBSTR( ROWID,1,8))) blocks  FROM                            
AP.AP_EXPENSE_REPORT_HEADERS                                                    
;                                                                               
INSERT INTO temp_size_table  SELECT                                             
&temp_var.AP_EXPENSE_REPORT_LINES&temp_var                                      
, COUNT( DISTINCT( SUBSTR( ROWID,1,8))) blocks  FROM                            
AP.AP_EXPENSE_REPORT_LINES                                                      
;                                                                               
INSERT INTO temp_size_table  SELECT                                             
&temp_var.AP_EXPENSE_REPORT_PARAMS&temp_var                                     
, COUNT( DISTINCT( SUBSTR( ROWID,1,8))) blocks  FROM                            
AP.AP_EXPENSE_REPORT_PARAMS                                                     
;                                                                               
INSERT INTO temp_size_table  SELECT                                             
&temp_var.AP_FLEX_SEGMENT_MAPPINGS&temp_var                                     
, COUNT( DISTINCT( SUBSTR( ROWID,1,8))) blocks  FROM                            
AP.AP_FLEX_SEGMENT_MAPPINGS                                                     
;                                                                               
INSERT INTO temp_size_table  SELECT                                             
&temp_var.AP_HISTORY_CHECKS&temp_var                                            
, COUNT( DISTINCT( SUBSTR( ROWID,1,8))) blocks  FROM                            
AP.AP_HISTORY_CHECKS                                                            
;                                                                               
INSERT INTO temp_size_table  SELECT                                             
&temp_var.AP_HISTORY_INVOICES&temp_var                                          
, COUNT( DISTINCT( SUBSTR( ROWID,1,8))) blocks  FROM                            
AP.AP_HISTORY_INVOICES                                                          
;                                                                               
INSERT INTO temp_size_table  SELECT                                             
&temp_var.AP_HISTORY_INVOICE_PAYMENTS&temp_var                                  
, COUNT( DISTINCT( SUBSTR( ROWID,1,8))) blocks  FROM                            
AP.AP_HISTORY_INVOICE_PAYMENTS                                                  
;                                                                               
INSERT INTO temp_size_table  SELECT                                             
&temp_var.AP_HOLDS&temp_var                                                     
, COUNT( DISTINCT( SUBSTR( ROWID,1,8))) blocks  FROM                            
AP.AP_HOLDS                                                                     
;                                                                               
INSERT INTO temp_size_table  SELECT                                             
&temp_var.AP_HOLD_CODES&temp_var                                                
, COUNT( DISTINCT( SUBSTR( ROWID,1,8))) blocks  FROM                            
AP.AP_HOLD_CODES                                                                
;                                                                               
INSERT INTO temp_size_table  SELECT                                             
&temp_var.AP_INCOME_TAX_REGIONS&temp_var                                        
, COUNT( DISTINCT( SUBSTR( ROWID,1,8))) blocks  FROM                            
AP.AP_INCOME_TAX_REGIONS                                                        
;                                                                               
INSERT INTO temp_size_table  SELECT                                             
&temp_var.AP_INCOME_TAX_TYPES&temp_var                                          
, COUNT( DISTINCT( SUBSTR( ROWID,1,8))) blocks  FROM                            
AP.AP_INCOME_TAX_TYPES                                                          
;                                                                               
INSERT INTO temp_size_table  SELECT                                             
&temp_var.AP_INTEREST_PERIODS&temp_var                                          
, COUNT( DISTINCT( SUBSTR( ROWID,1,8))) blocks  FROM                            
AP.AP_INTEREST_PERIODS                                                          
;                                                                               
INSERT INTO temp_size_table  SELECT                                             
&temp_var.AP_INVOICES&temp_var                                                  
, COUNT( DISTINCT( SUBSTR( ROWID,1,8))) blocks  FROM                            
AP.AP_INVOICES                                                                  
;                                                                               
INSERT INTO temp_size_table  SELECT                                             
&temp_var.AP_INVOICE_DISTRIBUTIONS&temp_var                                     
, COUNT( DISTINCT( SUBSTR( ROWID,1,8))) blocks  FROM                            
AP.AP_INVOICE_DISTRIBUTIONS                                                     
;                                                                               
INSERT INTO temp_size_table  SELECT                                             
&temp_var.AP_INVOICE_ENCUMBRANCE&temp_var                                       
, COUNT( DISTINCT( SUBSTR( ROWID,1,8))) blocks  FROM                            
AP.AP_INVOICE_ENCUMBRANCE                                                       
;                                                                               
INSERT INTO temp_size_table  SELECT                                             
&temp_var.AP_INVOICE_KEY_IND&temp_var                                           
, COUNT( DISTINCT( SUBSTR( ROWID,1,8))) blocks  FROM                            
AP.AP_INVOICE_KEY_IND                                                           
;                                                                               
INSERT INTO temp_size_table  SELECT                                             
&temp_var.AP_INVOICE_PAYMENTS&temp_var                                          
, COUNT( DISTINCT( SUBSTR( ROWID,1,8))) blocks  FROM                            
AP.AP_INVOICE_PAYMENTS                                                          
;                                                                               
INSERT INTO temp_size_table  SELECT                                             
&temp_var.AP_INVOICE_PREPAYS&temp_var                                           
, COUNT( DISTINCT( SUBSTR( ROWID,1,8))) blocks  FROM                            
AP.AP_INVOICE_PREPAYS                                                           
;                                                                               
INSERT INTO temp_size_table  SELECT                                             
&temp_var.AP_INVOICE_RELATIONSHIPS&temp_var                                     
, COUNT( DISTINCT( SUBSTR( ROWID,1,8))) blocks  FROM                            
AP.AP_INVOICE_RELATIONSHIPS                                                     
;                                                                               
INSERT INTO temp_size_table  SELECT                                             
&temp_var.AP_INVOICE_SELECTION_CRITERIA&temp_var                                
, COUNT( DISTINCT( SUBSTR( ROWID,1,8))) blocks  FROM                            
AP.AP_INVOICE_SELECTION_CRITERIA                                                
;                                                                               
INSERT INTO temp_size_table  SELECT                                             
&temp_var.AP_INVOICE_TRANSMISSIONS&temp_var                                     
, COUNT( DISTINCT( SUBSTR( ROWID,1,8))) blocks  FROM                            
AP.AP_INVOICE_TRANSMISSIONS                                                     
;                                                                               
INSERT INTO temp_size_table  SELECT                                             
&temp_var.AP_LOOKUP_CODES&temp_var                                              
, COUNT( DISTINCT( SUBSTR( ROWID,1,8))) blocks  FROM                            
AP.AP_LOOKUP_CODES                                                              
;                                                                               
INSERT INTO temp_size_table  SELECT                                             
&temp_var.AP_LOOKUP_TYPES&temp_var                                              
, COUNT( DISTINCT( SUBSTR( ROWID,1,8))) blocks  FROM                            
AP.AP_LOOKUP_TYPES                                                              
;                                                                               
INSERT INTO temp_size_table  SELECT                                             
&temp_var.AP_OTHER_PERIODS&temp_var                                             
, COUNT( DISTINCT( SUBSTR( ROWID,1,8))) blocks  FROM                            
AP.AP_OTHER_PERIODS                                                             
;                                                                               
INSERT INTO temp_size_table  SELECT                                             
&temp_var.AP_OTHER_PERIOD_TYPES&temp_var                                        
, COUNT( DISTINCT( SUBSTR( ROWID,1,8))) blocks  FROM                            
AP.AP_OTHER_PERIOD_TYPES                                                        
;                                                                               
INSERT INTO temp_size_table  SELECT                                             
&temp_var.AP_PAYMENT_DISTRIBUTIONS&temp_var                                     
, COUNT( DISTINCT( SUBSTR( ROWID,1,8))) blocks  FROM                            
AP.AP_PAYMENT_DISTRIBUTIONS                                                     
;                                                                               
INSERT INTO temp_size_table  SELECT                                             
&temp_var.AP_PAYMENT_KEY_IND&temp_var                                           
, COUNT( DISTINCT( SUBSTR( ROWID,1,8))) blocks  FROM                            
AP.AP_PAYMENT_KEY_IND                                                           
;                                                                               
INSERT INTO temp_size_table  SELECT                                             
&temp_var.AP_PAYMENT_PROGRAMS&temp_var                                          
, COUNT( DISTINCT( SUBSTR( ROWID,1,8))) blocks  FROM                            
AP.AP_PAYMENT_PROGRAMS                                                          
;                                                                               
INSERT INTO temp_size_table  SELECT                                             
&temp_var.AP_PAYMENT_SCHEDULES&temp_var                                         
, COUNT( DISTINCT( SUBSTR( ROWID,1,8))) blocks  FROM                            
AP.AP_PAYMENT_SCHEDULES                                                         
;                                                                               
INSERT INTO temp_size_table  SELECT                                             
&temp_var.AP_PURGE_INVOICE_LIST&temp_var                                        
, COUNT( DISTINCT( SUBSTR( ROWID,1,8))) blocks  FROM                            
AP.AP_PURGE_INVOICE_LIST                                                        
;                                                                               
INSERT INTO temp_size_table  SELECT                                             
&temp_var.AP_RECON_CHECK_RESULTS&temp_var                                       
, COUNT( DISTINCT( SUBSTR( ROWID,1,8))) blocks  FROM                            
AP.AP_RECON_CHECK_RESULTS                                                       
;                                                                               
INSERT INTO temp_size_table  SELECT                                             
&temp_var.AP_RECON_DETAILS&temp_var                                             
, COUNT( DISTINCT( SUBSTR( ROWID,1,8))) blocks  FROM                            
AP.AP_RECON_DETAILS                                                             
;                                                                               
INSERT INTO temp_size_table  SELECT                                             
&temp_var.AP_RECON_ERROR_CHK_GROUPS&temp_var                                    
, COUNT( DISTINCT( SUBSTR( ROWID,1,8))) blocks  FROM                            
AP.AP_RECON_ERROR_CHK_GROUPS                                                    
;                                                                               
INSERT INTO temp_size_table  SELECT                                             
&temp_var.AP_RECON_ERROR_CHK_GROUP_LINES&temp_var                               
, COUNT( DISTINCT( SUBSTR( ROWID,1,8))) blocks  FROM                            
AP.AP_RECON_ERROR_CHK_GROUP_LINES                                               
;                                                                               
INSERT INTO temp_size_table  SELECT                                             
&temp_var.AP_RECON_LOCKS&temp_var                                               
, COUNT( DISTINCT( SUBSTR( ROWID,1,8))) blocks  FROM                            
AP.AP_RECON_LOCKS                                                               
;                                                                               
INSERT INTO temp_size_table  SELECT                                             
&temp_var.AP_RECON_RECORD_CODES&temp_var                                        
, COUNT( DISTINCT( SUBSTR( ROWID,1,8))) blocks  FROM                            
AP.AP_RECON_RECORD_CODES                                                        
;                                                                               
INSERT INTO temp_size_table  SELECT                                             
&temp_var.AP_RECON_RECORD_SPECS&temp_var                                        
, COUNT( DISTINCT( SUBSTR( ROWID,1,8))) blocks  FROM                            
AP.AP_RECON_RECORD_SPECS                                                        
;                                                                               
INSERT INTO temp_size_table  SELECT                                             
&temp_var.AP_RECON_SUMMARIES&temp_var                                           
, COUNT( DISTINCT( SUBSTR( ROWID,1,8))) blocks  FROM                            
AP.AP_RECON_SUMMARIES                                                           
;                                                                               
INSERT INTO temp_size_table  SELECT                                             
&temp_var.AP_RECON_TRANSACTION_CODES&temp_var                                   
, COUNT( DISTINCT( SUBSTR( ROWID,1,8))) blocks  FROM                            
AP.AP_RECON_TRANSACTION_CODES                                                   
;                                                                               
INSERT INTO temp_size_table  SELECT                                             
&temp_var.AP_RECURRING_PAYMENTS&temp_var                                        
, COUNT( DISTINCT( SUBSTR( ROWID,1,8))) blocks  FROM                            
AP.AP_RECURRING_PAYMENTS                                                        
;                                                                               
INSERT INTO temp_size_table  SELECT                                             
&temp_var.AP_REPORTING_ENTITIES&temp_var                                        
, COUNT( DISTINCT( SUBSTR( ROWID,1,8))) blocks  FROM                            
AP.AP_REPORTING_ENTITIES                                                        
;                                                                               
INSERT INTO temp_size_table  SELECT                                             
&temp_var.AP_REPORTING_ENTITY_LINES&temp_var                                    
, COUNT( DISTINCT( SUBSTR( ROWID,1,8))) blocks  FROM                            
AP.AP_REPORTING_ENTITY_LINES                                                    
;                                                                               
INSERT INTO temp_size_table  SELECT                                             
&temp_var.AP_SELECTED_INVOICES&temp_var                                         
, COUNT( DISTINCT( SUBSTR( ROWID,1,8))) blocks  FROM                            
AP.AP_SELECTED_INVOICES                                                         
;                                                                               
INSERT INTO temp_size_table  SELECT                                             
&temp_var.AP_SELECTED_INVOICE_CHECKS&temp_var                                   
, COUNT( DISTINCT( SUBSTR( ROWID,1,8))) blocks  FROM                            
AP.AP_SELECTED_INVOICE_CHECKS                                                   
;                                                                               
INSERT INTO temp_size_table  SELECT                                             
&temp_var.AP_SPACER&temp_var                                                    
, COUNT( DISTINCT( SUBSTR( ROWID,1,8))) blocks  FROM                            
AP.AP_SPACER                                                                    
;                                                                               
INSERT INTO temp_size_table  SELECT                                             
&temp_var.AP_SYSTEM_PARAMETERS&temp_var                                         
, COUNT( DISTINCT( SUBSTR( ROWID,1,8))) blocks  FROM                            
AP.AP_SYSTEM_PARAMETERS                                                         
;                                                                               
INSERT INTO temp_size_table  SELECT                                             
&temp_var.AP_TAX_CODES&temp_var                                                 
, COUNT( DISTINCT( SUBSTR( ROWID,1,8))) blocks  FROM                            
AP.AP_TAX_CODES                                                                 
;                                                                               
INSERT INTO temp_size_table  SELECT                                             
&temp_var.AP_TEMP_GATHER_INVOICES&temp_var                                      
, COUNT( DISTINCT( SUBSTR( ROWID,1,8))) blocks  FROM                            
AP.AP_TEMP_GATHER_INVOICES                                                      
;                                                                               
INSERT INTO temp_size_table  SELECT                                             
&temp_var.AP_TEMP_GATHER_PAYMENTS&temp_var                                      
, COUNT( DISTINCT( SUBSTR( ROWID,1,8))) blocks  FROM                            
AP.AP_TEMP_GATHER_PAYMENTS                                                      
;                                                                               
INSERT INTO temp_size_table  SELECT                                             
&temp_var.AP_TEMP_TRIAL_BALANCE&temp_var                                        
, COUNT( DISTINCT( SUBSTR( ROWID,1,8))) blocks  FROM                            
AP.AP_TEMP_TRIAL_BALANCE                                                        
;                                                                               
INSERT INTO temp_size_table  SELECT                                             
&temp_var.AP_TERMS&temp_var                                                     
, COUNT( DISTINCT( SUBSTR( ROWID,1,8))) blocks  FROM                            
AP.AP_TERMS                                                                     
;                                                                               
INSERT INTO temp_size_table  SELECT                                             
&temp_var.AP_TERMS_LINES&temp_var                                               
, COUNT( DISTINCT( SUBSTR( ROWID,1,8))) blocks  FROM                            
AP.AP_TERMS_LINES                                                               
;                                                                               
INSERT INTO temp_size_table  SELECT                                             
&temp_var.AP_TOLERANCES&temp_var                                                
, COUNT( DISTINCT( SUBSTR( ROWID,1,8))) blocks  FROM                            
AP.AP_TOLERANCES                                                                
;                                                                               
INSERT INTO temp_size_table  SELECT                                             
&temp_var.AP_TRANSFER_ENCUMBRANCE&temp_var                                      
, COUNT( DISTINCT( SUBSTR( ROWID,1,8))) blocks  FROM                            
AP.AP_TRANSFER_ENCUMBRANCE                                                      
;                                                                               
INSERT INTO temp_size_table  SELECT                                             
&temp_var.AP_TRIAL_BALANCE&temp_var                                             
, COUNT( DISTINCT( SUBSTR( ROWID,1,8))) blocks  FROM                            
AP.AP_TRIAL_BALANCE                                                             
;                                                                               
INSERT INTO temp_size_table  SELECT                                             
&temp_var.AP_VENDOR_AUDIT_TMP&temp_var                                          
, COUNT( DISTINCT( SUBSTR( ROWID,1,8))) blocks  FROM                            
AP.AP_VENDOR_AUDIT_TMP                                                          
;                                                                               
INSERT INTO temp_size_table  SELECT                                             
&temp_var.AP_VENDOR_KEY_IND&temp_var                                            
, COUNT( DISTINCT( SUBSTR( ROWID,1,8))) blocks  FROM                            
AP.AP_VENDOR_KEY_IND                                                            
;                                                                               
INSERT INTO temp_size_table  SELECT                                             
&temp_var.FINANCIALS_PURGES&temp_var                                            
, COUNT( DISTINCT( SUBSTR( ROWID,1,8))) blocks  FROM                            
AP.FINANCIALS_PURGES                                                            
;                                                                               
INSERT INTO temp_size_table  SELECT                                             
&temp_var.FINANCIALS_SYSTEM_PARAMETERS&temp_var                                 
, COUNT( DISTINCT( SUBSTR( ROWID,1,8))) blocks  FROM                            
AP.FINANCIALS_SYSTEM_PARAMETERS                                                 
;                                                                               
