SELECT
	BUILTIN.DF( transactionLine.item ) AS item,
	InboundShipment.shipmentNumber,
	BUILTIN.DF( InboundShipmentItem.purchaseOrderTransaction ) AS PurchaseOrder,
	InboundShipmentItem.quantityExpected,
	InboundShipmentItem.quantityReceived,
	InboundShipmentItem.quantityRemaining,
	BUILTIN.DF( InboundShipmentItem.receivingLocation ) AS Location,
	BUILTIN.DF( InboundShipmentItem.unit ) AS PurchaseUnit,
	CUSTOMRECORD_WMSSE_SKU_ALIAS.custrecord_wmsse_alias_desc as mastercase,
	BUILTIN.DF( CUSTOMRECORD_WMSSE_SKU_ALIAS.custrecord_wms_alias_unit ) AS Mastercasemeasure,
         InboundShipmentItem.custrecord_mm_box_no AS Cartonnumbers,
	CASE WHEN CUSTOMRECORD_WMSSE_SKU_ALIAS.custrecord_wmsse_alias_desc LIKE '%BX%' THEN regexp_replace(BUILTIN.DF( CUSTOMRECORD_WMSSE_SKU_ALIAS.custrecord_wms_alias_unit ), '[^0-9.]') END 	AS piecesperinner,
	CASE WHEN CUSTOMRECORD_WMSSE_SKU_ALIAS.custrecord_wmsse_alias_desc LIKE '%MC%' THEN regexp_replace(BUILTIN.DF( CUSTOMRECORD_WMSSE_SKU_ALIAS.custrecord_wms_alias_unit ), '[^0-9.]') END AS MasterQuantity,
	 CASE WHEN CUSTOMRECORD_WMSSE_SKU_ALIAS.custrecord_wmsse_alias_desc LIKE '%MC%' THEN InboundShipmentItem.quantityExpected/regexp_replace(BUILTIN.DF( CUSTOMRECORD_WMSSE_SKU_ALIAS.custrecord_wms_alias_unit ), '[^0-9.]') END AS TotalMasters,
	CUSTOMRECORD_WMSSE_SKU_ALIAS.name AS masterbarcode,
FROM
	InboundShipmentItem
LEFT OUTER JOIN transactionLine ON InboundShipmentItem.shipmentitemtransaction = transactionLine.uniquekey
LEFT OUTER JOIN CUSTOMRECORD_WMSSE_SKU_ALIAS ON transactionLine.item = CUSTOMRECORD_WMSSE_SKU_ALIAS.custrecord_wmsse_alias_item
RIGHT OUTER JOIN InboundShipment ON InboundShipmentItem.inboundshipment = InboundShipment.id
WHERE
( InboundShipmentItem.inboundShipment = '165' )

I am trying to query to get the inbound shipments and then see the break down of unit of measures. I cant seem to get it all onto 1 line though. Any suggestions.