SELECT WHERE POL.VENDOR_PRODUCT_NUM IS NOT NULL AND POL.PO_HEADER_ID = POH.PO_HEADER_ID AND POV.VENDOR_ID = POH.VENDOR_ID AND PVS.VENDOR_ID = POV.VENDOR_ID) GROUP BY SUPPLIER_ITEM_PK , ALL_FK , SUPPLIER_SITE_ITEM_DP , SUPPLIER_ITEM_DP , NAME , SUPPLIER_SITE_CODE , SUPPLIER_NAME , INSTANCE , USER_ATTRIBUTE1 , USER_ATTRIBUTE2 , USER_ATTRIBUTE3 , USER_ATTRIBUTE4 , USER_ATTRIBUTE5