Inventory

Get Involved. Join the Conversation.

Topic

    Arijit Pramanik
    Need the table name for linking business unit and default...
    Topic posted September 5, 2019 by Arijit PramanikRed Ribbon: 250+ Points, tagged Inventory Cloud 
    27 Views, 3 Comments
    Title:
    Need the table name for linking business unit and default data set
    Summary:
    Need the table name for linking business unit and default data set
    Content:

    Need the table name for linking business unit and default data set

    Comment

     

    • Lynn Warneka

      Hi -  Can you please give us more details here on what you are looking for and the business u-se case?  For example - what is the default data set'?    In Inventory Management Cloud, we offer security by Inventory Organization and that determines the data that can be accessed.     Thanks  

    • Pradeep Kumar

      Please check this table

       

      FND_SETID_ASSIGNMENTS

    • Pradeep Kumar

      Hi,

      Please check the below query

      SELECT fsa.reference_group_name,
               fs.set_id,
               fs.set_code,
               fs.set_name,
               fs.description,
               bu.bu_name
          FROM fnd_setid_assignments   fsa,
               fun_all_business_units_v bu,
               fnd_setid_sets_vl       fs
         WHERE     1 = 1
               AND fsa.determinant_type = 'BU'
               AND fsa.determinant_value = bu.bu_id
               AND fsa.set_id = fs.set_id
               AND fsa.reference_group_name LIKE 'PER%'
      ORDER BY reference_group_name,
               set_code,
               set_name,
               bu_name

      Regards

      Pradeep