We are probably one of the only CEM's that use Oracle Applications in a one-to-one MPN-IPN (Oracle Item Part Number) relationship. We do not currently store multiple Manufacturers under a single Item. Rather, we use the Customer Item Cross Reference to rank the customer's AML, with each IPN tied to a single MPN.
We are looking at moving into a one-to-many "world" in Oracle but are not sure how we can handle different pricing, lead-time, preference, status (prototype, production, obsolete, do not use), etc. for each Manufacturer's Part Number under a single Item. How are other CM's handling this???