SELECT mr.inventory_item_id, mr.wip_entity_id, mr.organization_id, mr.operation_seq_num, i.segment1 concatenated_segments, i.description item_description, i.primary_uom_code item_primary_uom_code,
mr.supply_subinventory, mr.supply_locator_id, mr.wip_supply_type, ml.meaning wip_supply_meaning,
CASE mr.quantity_issued
WHEN 0 THEN NULL
ELSE mr.quantity_issued
END quantity_issued,
CASE mr.required_quantity - mr.quantity_issued
WHEN 0 THEN NULL
ELSE
CASE SIGN(mr.required_quantity)
WHEN -1 * SIGN(mr.quantity_issued) THEN mr.required_quantity - mr.quantity_issued <<--- HERE!
ELSE
CASE SIGN(ABS(mr.required_quantity) - ABS(mr.quantity_issued))
WHEN -1 THEN NULL
ELSE mr.required_quantity - mr.quantity_issued
END
END
END quantity_open,
mr.quantity_per_assembly, mr.required_quantity
FROM apps.wip_requirement_operations mr
LEFT JOIN apps.mtl_system_items_b i ON i.inventory_item_id = mr.inventory_item_id AND i.organization_id = mr.organization_id
LEFT JOIN apps.mfg_lookups ml ON ml.lookup_code = mr.wip_supply_type WHERE ml.lookup_type = 'WIP_SUPPLY'