Using a calced value for later calculations all in the same SQL
My simplifed example is:
select (NVL(CTLA.QUANTITY_INVOICED,CTLA.QUANTITY_CREDITED) * (select 1/conversion_rate
from mtl_uom_class_conversions
where from_uom_code = CTLA.UOM_CODE
and to_uom_code = 'LT'
and inventory_item_id = MSI.INVENTORY_ITEM_ID) ) CONVERSION_QTY
,CONVERSION_QTY * cic.item_cost CONV_ITEM_COST
,CONVERSION_QTY * cic.material_cost CONV_MAT_COST