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

Join Conditions

1007980 Newbie
Currently Being Moderated

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

    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

Legend

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