Same part# but different colors

Summary

How can you have Oracle distinguish same part# but having different colors

Content

Often times we have parts that are painted differently based on specific customer requirements. Say part# ABC is painted red for customer C1 and green for customer C2.We now want to ensure that part#ABC with red color not be used for meeting C2's demand and  part#ABC with green color not be used to meet C1's demand.

Has anyone had this problem and solution for this all the way from inventory to manufacturing and planning? Is project and task the only way to handle this ? Project based mfg has a limitation that is it not supported yet by