0 Replies Latest reply: Feb 8, 2013 4:43 AM by appsfh RSS

    How to get the <ACCOUNTING_FLEXFIELD> Name  in a Multi Ledger Instance?

    appsfh
      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