8 Replies Latest reply: Jun 13, 2014 1:38 AM by 0cbe981a-b52d-4834-ab61-c032984eca2e RSS

    link between mtl_system_items and rcv_shipment_lines

    1498181

      Hi,

       

      I am writing a query to show PO receiving for Standard and Blanket PO's including Service(no item code) and goods PO's. Tables included are

       

      rcv_shipment_headers rsh

      rcv_shipment_lines rsl

      rcv_transactions rt

      po_headers_all pha

      po_lines_all pla

      mtl_system_items_b msi

       

      when i join

      rsl.inventory_item_id = msi.inventory_item_id(+)------------to include service items

       

      i must joing organization_id as well. there are to_organization_id and from_organization_id columns in rsl. how will i join organization with msi.organization_id?