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

Hi,

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

Legend

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