In depth details of supplier with status of supplier & status of items.   SELECT DISTINCT msi.segment1 "ITEM CODE", pla.item_id, msi.description "ITEM DESCRIPTION", msi.inventory_item_status_code "ITEM STATUS", mp.organization_code, msi.item_type, PV.SEGMENT1 VENDOR_NUMBER, PV.VENDOR_NAME,...