3 Replies Latest reply: Nov 8, 2012 4:14 AM by Gurujothi RSS

    Difference between tables

    Gurujothi
      Hello Everyone,

      Can anyone explain what is the difference between the following tables and usage,

      mtl_item_locations vs mtl_secondary_locators

      Thank you.

      Regards,

      Guru
        • 1. Re: Difference between tables
          Hussein Sawwan-Oracle
          Gurujothi wrote:
          Hello Everyone,

          Can anyone explain what is the difference between the following tables and usage,

          mtl_item_locations vs mtl_secondary_locators

          Thank you.

          Regards,

          Guru
          TABLE: INV.MTL_ITEM_LOCATIONS
          http://etrm.oracle.com/pls/et1211d9/etrm_pnav.show_object?c_name=MTL_ITEM_LOCATIONS&c_owner=INV&c_type=TABLE

          TABLE: INV.MTL_SECONDARY_LOCATORS
          http://etrm.oracle.com/pls/et1211d9/etrm_pnav.show_object?c_name=MTL_SECONDARY_LOCATORS&c_owner=INV&c_type=TABLE

          Thanks,
          Hussein
          • 2. Re: Difference between tables
            HrishikeshJ
            Hi,

            mtl_item_locations = stores definition of Locators.
            mtl_secondary_locators = stores items that are restricted to a particular locator.

            Thanks,
            Hrishi
            • 3. Re: Difference between tables
              Gurujothi
              Hi HrishikeshJ,

              Thank you for your reply,In the above
              [url http://etrm.oracle.com/pls/et1211d9/etrm_pnav.show_object?c_name=MTL_ITEM_LOCATIONS&c_owner=INV&c_type=TABLE]Link
              suggested by Hussein Sawwan,
              its mentioned that, if MTL_ITEM_LOCATIONS table's column INVENTORY_ITEM_ID is not null, the only item that can be in locator
              and you mentioned that,
              > >

              mtl_secondary_locators = stores items that are restricted to a particular locator.


              here in my case as mentioned above for my inventory_item_id 14567 and org_id 333 some locators are restricted because some records
              are there in mtl_secondary_locators for inventory_item_id 14567 and org_id 333 ,
              and in MTL_ITEM_LOCATIONS table totally 4 records( locators) are there for org_id 333 and all 4 records
              INVENTORY_ITEM_ID is not null,this means that only the mentioned INVENTORY_ITEM_ID can be stored in that locators and there is no locator mentioned for inventory_item_id 14567 and org_id 333.

              can you tell me where can I check the assigned locator for inventory_item_id 14567 and org_id 333.

              Thank you.

              Regards,
              Guru