1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Query To Display Receipt Sources In R12

Discussion in 'Oracle Apps Technical' started by jagadekara, Sep 13, 2014.

  1. jagadekara

    jagadekara Forum Guru

    Messages:
    1,126
    Likes Received:
    145
    Trophy Points:
    1,805
    Location:
    Pulivendula
    Navigation
    ------------
    Receivables Resp--> Oracle Receivables-->setup-->Receipts--> Receipt Sources
    --Receipt Sources
    ------------------------------------------

    Code (SQL):
    SELECT hou.name operating_unit 
          ,absa.name   
          ,absa.description
          ,al.meaning receipt_source_type  
          ,arc.name receipt_class  
          ,arm.name payment_method 
          ,cba.bank_account_name bank_account  
          ,al1.meaning batch_numbering 
          ,absa.last_batch_num last_number 
          ,absa.start_date_active effective_start_date 
          ,absa.end_date_active effective_end_date 
      FROM ar_batch_sources_all absa   
          ,hr_operating_units hou  
          ,ar_lookups al   
          ,ar_receipt_classes arc  
          ,ar_receipt_methods arm  
          ,ar_lookups al1  
          ,ce_bank_accounts cba
     WHERE 1=1 
       AND absa.org_id=hou.organization_id 
       AND hou.organization_id=nvl(:P_ORG_ID,hou.organization_id)  
       AND al.lookup_code(+)=absa.TYPE 
       AND al.lookup_type(+)='BATCH_TYPE'  
       AND arc.receipt_class_id(+)=absa.default_receipt_class_id   
       AND arm.receipt_method_id(+)=absa.default_receipt_method_id 
       AND al1.lookup_code(+)=absa.auto_batch_numbering
       AND al1.lookup_type(+)='BATCH_NUMBERING'
       AND cba.bank_account_id(+)=absa.remit_bank_acct_use_id   ;