2 Replies Latest reply on May 25, 2009 6:05 AM by Tao2

    about master item & org item

    Tao2
      what's master item and organizaiton item?
      they are stroed in the same table 'mtl_system_items_b' ,how to tell them?
      thanks.
        • 1. Re: about master item & org item
          Sandeep Gandhi, Consultant
          In Oracle, you define an inventory organization for each plant/warehouse you are setting up. These are called child orgs.
          Each of these inventory orgs refer to one and only one parent org. It is called a master org.
          One master org can have one or more children orgs. Typically, all transactions take place only in child orgs. No transactions happen in a master.
          When you define an item, you have to define it in master org first and then assign to one or more child orgs.

          The organizations are stored in a table called mtl_parameters.
          Only for a master org record in the table, the master_organization_id is equal to organization_id. That is how you know which org is a child and who its master is.

          Hope this answers your question.

          Sandeep Gandhi
          Independent Consultant
          513-325-9026
          • 2. Re: about master item & org item
            Tao2
            thanks!
            Sandeep Gandhi
            your answer really helps!