mapping of manufacturer, manufacturer item and supplier ( under agreement) to the query

Hello,

Please advise on this subject

mapping of columns to this query:

Manufacturer	Manufacturer Item	Supplier ( Under Agreement)

SELECT distinct
WE.WIP_ENTITY_ID,
--WR.WORK_REQUEST_NUMBER WR_NO,
WE.WIP_ENTITY_NAME WO_NO,
replace(replace(WE.DESCRIPTION,chr(10),' '),chr(13),'')WO_DESCR,
WE.CREATION_DATE WO_DATE,
ML.MEANING WO_STATUS,
WDJ.ASSET_NUMBER,
MSIB.SEGMENT1 ASSET_GROUP,
MSIB.DESCRIPTION GROUP_DESCRIPTION,
WRO.OPERATION_SEQ_NUM,
WRO.DEPARTMENT_CODE,
WRO.CONCATENATED_SEGMENTS ITEM,
WRO.ITEM_DESCRIPTION
,WRO.REQUIRED_QUANTITY,nvl(WRO.QUANTITY_ISSUED,0) QTY_issued,
WRO.item_primary_uom_code UOM,
--wro.SUGGESTED_VENDOR_NAME,