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 Receivable Activities 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-->Receivable Activities

    --Receivable Activities
    ---------------------------------
    Code (SQL):
    SELECT hou.name operating_unit
          ,arta.name
          ,arta.description
          ,al.meaning TYPE
          ,arta.STATUS active
          ,al1.meaning gl_account_source
          ,al2.meaning tax_rate_code_source
          ,gcck.concatenated_segments activity_gl_account
          ,arta.default_acctg_distribution_set distribution_set
      FROM ar_receivables_trx_all arta
          ,hr_operating_units hou
          ,ar_lookups al
          ,ar_lookups al1
          ,ar_lookups al2
          ,gl_code_combinations_kfv gcck
     WHERE 1=1
       AND arta.org_id=hou.organization_id
       AND al.lookup_code(+)=arta.TYPE
       AND al.lookup_type(+)='RECEIVABLES_TRX'
       AND hou.organization_id=nvl(:P_ORG_ID,hou.organization_id)
       AND arta.name=nvl(:P_NAME,arta.name)
       AND al1.lookup_code(+)=arta.gl_account_source
       AND al1.lookup_type(+)='GL_ACCOUNT_SOURCE'
       AND al2.lookup_code(+)=arta.tax_code_source
       AND al2.lookup_type(+)='TAX_CODE_SOURCE'
       AND gcck.code_combination_id(+)=arta.code_combination_id