select PO.DocNO,PL.DocLineNo,ppt.Name,cim.code,pl.ItemInfo_ItemName,PL.ReqQtyRU,pl.SupplierConfirmQtyTU,pl.TotalRtnFillQtyTU,pl.OutBoxNum,pl.InBoxNum,but.Name,bc.Department,
pps.DeliveryDate,cim.ItemNature,bo.Code,ppm.PurchaseOrder from PM_PurchaseOrder PO
LEFT JOIN PM_POLine PL
ON PO.ID = PL.PurchaseOrder
left join PM_PODocType_Trl ppt
on po.DocumentType = ppt.ID
left join CBO_ItemMaster cim
on cim.ID = pl.ItemInfo_ItemID
left join Base_UOM_Trl but
on but.ID = pl.PriceUOM
left join PM_POShipLine pps
on pps.POLine = pl.ID
left join Base_Contact bc
on bc.ID = po.PurOper
left join base_Organization bo
on bo.ID = po.JDOrg
left join PM_POMemo ppm
on ppm.PurchaseOrder = po.id
select cct.Name,ee.CustomerDocNo,ee.DocNo,cim.Code from EPT_ETSO ee
left join CBO_Customer_Trl cct
on ee.Customer = cct.ID
left join EPT_ETSOLine eet
on eet.ETSO=ee.ID
left join CBO_ItemMaster cim
on eet.Item = cim.ID