Answer
Look at Conditional LOV Filter functionality — it's the mechanism built for showing a List of Values conditionally based on another field's state (like an active/inactive status column on the referenced table), and is the documented path for this kind of filtering without a full customization.