MSC_SYSTEM_ITEMS vs. EGP_SYSTEM_ITEMS_B
I have a need to cross reference MSC_SYSTEM_ITEMS and EGP_SYSTEM_ITEMS_B to abstract away query complexity for certain users. This is a Data Warehousing scenario. How can I map MSC_SYSTEM_ITEMS records to their corresponding item record in EGP_SYSTEM_ITEMS_B. Am I missing something obvious?
Is there a cross-reference table that allows us to harmonize these two tables, so users don't have to leverage two item masters when interacting with Oracle Fusion holistically?
0