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

    Join Conditions




      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

          Hi Hari,



          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 !