need to add item number with item class and item category in bip

Question

need to add item number with item class and item category in bip,

How can I join EGP_SYSTEM_ITEMS_B table with EGP_ITEM_CLASSES table and EGP_ITEM_CATEGORIES_TABLE ?

There are no matching columns

John Hung-Oracle · Answer

Hi, To better serve you, I have moved your post to the Reporting and Analytics for SCM forum to get the appropriate experts eyes on it. I will close this post. Thank you.

Moved to:

https://community.oracle.com/customerconnect/discussion/781928/need-to-add-item-number-with-item-class-and-item-category-in-bip