本月发票代码,OracleEBS代码库,德仔网

代码语言
代码分类
【OracleEBS】本月发票
作者:Dezai.CN / 发布于2013/1/7/ 622
一个AP的发票和付款的
----应付模块对帐语句                                                                                     
----将指定日期范围内的所有的应付发票和付款分录全部按供应商地点取出                                       
----可按科目或其他方式对帐                                                                                      
----本月发票                                                                                             
select pv.vendor_name,                                                                                   
       pv.segment1,                                                                                      
       pvs.vendor_site_code,                                                                             
       ai.invoice_num,                                                                                   
       ai.gl_date,                                                                                       
       ai.invoice_currency_code,                                                                         
       ai.invoice_type_lookup_code,                                                                      
       aae.event_type_code,                                                                              
       aae.source_table,                                                                                 
       aal.ae_line_type_code,                                                                            
       gcc.concatenated_segments,   
       gcc.segment2,                                                                     
       gcc.segment3,                                                                                     
       aal.entered_dr,                                                                                   
       aal.entered_cr,                                                                                   
       aal.accounted_dr,                                                                                 
       aal.accounted_cr,
       abs(nvl(aal.accounted_dr,0)- nvl(aal.accounted_cr,0)) 
from ap_invoices_all ai,                                                                                 
     ap_accounting_events_all aae,                                                                       
     ap_ae_headers_all aah,                                                                              
     ap_ae_lines_all aal,                                                                                
     po_vendors pv,                                                                                      
     po_vendor_sites_all pvs,                                                                            
     gl_code_combinations_kfv gcc   
where ai.INVOICE_ID = aae.SOURCE_ID                                                                      
and   aae.SOURCE_TABLE = 'AP_INVOICES'      --AP_CHECKS                                                  
and   aae.accounting_event_id = aah.accounting_event_id                                                  
and   aah.ae_header_id = aal.ae_header_id                                                                
and   ai.vendor_id = pv.vendor_id                                                                        
and   ai.vendor_site_id = pvs.vendor_site_id                                                             
and   aal.code_combination_id = gcc.code_combination_id                                                  
and   ai.gl_date >= to_date('2007-08-01','yyyy-mm-dd')   
and   ai.org_id = 102                                                                           
union all                                                                                                
----本月付款                                                                                      
select pv.vendor_name,                                                                                   
       pv.segment1,                                                                                      
       pvs.vendor_site_code,                                                                             
       to_char(ac.check_number),                                                                         
       ac.check_date,                                                                                    
       ac.currency_code,                                                                                 
       ac.bank_account_name,                                               --ai.invoice_type_lookup_code,
       aae.event_type_code,                                                                              
       aae.source_table,                                                                                 
       aal.ae_line_type_code,                                                                            
       gcc.concatenated_segments,           
       gcc.segment2,                                                             
       gcc.segment3,                                                                                     
       aal.entered_dr,                                                                                   
       aal.entered_cr,                                                                                   
       aal.accounted_dr,                                                                                 
       aal.accounted_cr,
       abs(nvl(aal.accounted_dr,0)- nvl(aal.accounted_cr,0))                   
from ap_checks_all ac,                                                                                   
     ap_accounting_events_all aae,                                                                       
     ap_ae_headers_all aah,                                                                              
     ap_ae_lines_all aal,                                                                                
     po_vendors pv,                                                                                      
     po_vendor_sites_all pvs,                                                                            
     gl_code_combinations_kfv gcc                   
where ac.check_id = aae.SOURCE_ID                                                                        
and   aae.SOURCE_TABLE = 'AP_CHECKS'      --AP_CHECKS                                                    
and   aae.accounting_event_id = aah.accounting_event_id                                                  
and   aah.ae_header_id = aal.ae_header_id                                                                
and   ac.vendor_id = pv.vendor_id                                                                        
and   ac.vendor_site_id = pvs.vendor_site_id                                                             
and   aal.code_combination_id = gcc.code_combination_id                                                  
and   ac.check_date >= to_date('2007-08-01','yyyy-mm-dd')     
and   ac.org_id = 102
评论列表
本站所提供的代码，版权归原作者所有，若有侵犯作者版权，请与我们联系，我们将立即删除或修改。谢谢!
本站所有代码发布及提供者。
试试其它关键字
　本月发票　
同语言下
可能有用的
Dezai.CN贡献的其它代码(4037)