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 get GL Account and Account Segment Description

Discussion in 'Oracle Apps Technical' started by nilesh.dudhane, Jun 29, 2015.

  1. nilesh.dudhane

    nilesh.dudhane Active Member

    Messages:
    42
    Likes Received:
    2
    Trophy Points:
    135
    Location:
    India
    1.Query to get Account Code Combination Description

    Code (SQL):

    SELECT gl_flexfields_pkg.get_concat_description
                                              (chart_of_accounts_id,
                                               code_combination_id
                                              )
                FROM gl_code_combinations
     
    2. Query to get Account Segment Description

    Code (SQL):

    SELECT gl_flexfields_pkg.get_description_sql
                                         (chart_of_accounts_id,--- chart of account id
                                          1,----- Position of segment
                                          segment1 ---- Segment value
                                         )
    FROM gl_code_combinations