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

    link between mtl_system_items and rcv_shipment_lines




      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?