1 Reply Latest reply: Aug 23, 2013 3:39 AM by user12863742 RSS

    Join Conditions

    1007980

      Hi,

       

      I am trying too much, but i didn't find some of Join Conditions between

      mtl_lot_numbers mln

            ,mtl_system_items_b msi

            , mtl_onhand_quantities_detail moqd

            , mtl_item_locations mil

            , mtl_material_transactions mmt

       

      please help me if you know,

       

       

       

       

       

      --
      Thanks & Regards,

      Hari Babu

        • 1. Re: Join Conditions
          user12863742

          Hi Hari,

           

          Join

          mtl_lot_numbers mln

          mtl_system_items_b msi

          mtl_onhand_quantities_detail moqd  ,

          mtl_item_locations mil

          mtl_material_transactions mmt

          tables with INVENTORY_ITEM_ID and ORGANIZATION_ID columns

           

          Additionally, add a join of,

          mil.INVENTORY_LOCATION_ID= mmt.LOCATOR_ID for joining mtl_item_locations and mtl_material_transactions.

           

          you might need to change a little in join conditions depending on your requirements else that too may not required.

          good luck !

           

          -SaurabhDJ