This discussion is archived
1 Reply Latest reply: Sep 21, 2013 11:39 AM by 1007980 RSS

What is the Join between po_lines_all and mtl_system_items_b

1007980 Newbie
Currently Being Moderated


What is the Join between Po_lines_all and mtl_system_items_b



I wrote

po_lines_all.item_id = mtl_system_items_b.inventory_item_id

AND po_lines_all.organization_id = po_line_locations_all.ship_to_organization_id




But i didn't get all the records. I lost some records. Please tell me here which Join is suitable.................





Thanks & Regards,

Hari Babu


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