Welcome to Oracle Communities
Register and Participate in Oracle's online communities. Learn from thousand of experts, get answers to your questions and share knowledge with peers.
The View MTL_ITEM_FLEXFIELDS is built on MTL_SYSTEM_ITEMS_B_KFV view and KFV on MTL_SYSTEM_ITEMS_B and i did not understand the difference between them.
can any one tell me what's the difference between them exactly and how they are used when we work with Inventory?
MTL_ITEM_FLEXFIELDS is used to simplify queries in forms. Oracle do not recommend you use it to query data.