This discussion is archived
1 Reply Latest reply: Aug 23, 2013 1:39 AM by user12863742 RSS

Join Conditions

1007980 Newbie
Currently Being Moderated



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 Newbie
    Currently Being Moderated

    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 !




  • Correct Answers - 10 points
  • Helpful Answers - 5 points