2 Replies Latest reply on Mar 16, 2008 10:42 AM by 628722

    PO Query

    584849
      Hi,

      I need to get the Item number from mtl_system_items table for every item_id on the lines of a praticular Blanket PO. For some reason, this seems simple enough, but I am not getting it right.

      Any help would be appreciated.

      Thanks,
      Ja
        • 1. Re: PO Query
          608922
          Ok Try this:

          Join between po_lines_all and mtl_system_items using the item_id and org_id to get the item number from mtl_system_items
          • 2. Re: PO Query
            628722
            select msi.concatenated_segments item_number,
            msi.inventory_item_id item_id
            from mtl_system_items_kfv msi,
            mtl_system_items_b msb,
            po_lines_all pol
            where msi.inventory_item_id = pol.item_id
            and msi.inventory_item_id = msb.inventory_item_id
            and msb.organization_id =
            (select inventory_organization_id from financial_system_params_all where org_id = pol.org_id)
            and po_line_id = :1.



            Thanks