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!

How to get the -ACCOUNTING_FLEXFIELD- Name in a Multi Ledger Instance

Discussion in 'Oracle Apps Technical' started by firefoze, Feb 11, 2013.

  1. firefoze

    firefoze Active Member

    Messages:
    2
    Likes Received:
    1
    Trophy Points:
    55
    Hi,
    How to get the <ACCOUNTING_FLEXFIELD> Name in a Multi Ledger Instance from logged-in Responsibility? Is there any profile option available?
    ----
    SELECT id_flex_num
    INTO l_structure_num
    FROM apps.fnd_id_flex_structures
    WHERE ID_FLEX_CODE = 'GL#'
    AND ID_FLEX_STRUCTURE_CODE=<ACCOUNTING_FLEXFIELD>;
    ---

    Tx
     
  2. ac.arijit

    ac.arijit Forum Advisor

    Messages:
    217
    Likes Received:
    22
    Trophy Points:
    280
    Location:
    Kolkata, India
    Hi,

    Uh .. um !! the message is not quite clear. What exactly r u asking over here?
    1. Flexfield Title.
    2. Flexfield Structure Code
    3. Flexfield Structure Name
    4. Flexfield Structure Number

    Plz see the below script, this may be helpful for u or else plz elaborate the query a li'l more clearly.
    Code (SQL):

    SELECT  fif.id_flex_name
           ,fif.id_flex_code
           ,fifs.id_flex_num
           ,fifs.id_flex_structure_code
           ,fifst.id_flex_structure_name
    FROM    applsys.fnd_id_flexs                fif
           ,applsys.fnd_id_flex_structures      fifs
           ,applsys.fnd_id_flex_structures_tl   fifst
    WHERE   fif.id_flex_code    =   'GL#'    
    AND     fifs.id_flex_code   =   fif.id_flex_code
    AND     fifst.id_flex_num   =   fifs.id_flex_num
    AND     fifst.id_flex_code  =   fifs.id_flex_code;