R12 iProcurement base descriptor update for inventory item from items master
We need to find out in which table of iprocurement in R12 the base descriptor fields like manufacturer, manufacturer part number and alias are saved because we need a way (a database trigger) to update only the iprocurement value. We have created also a custom descriptor (Item Type) that we want to popluate from the tem type in inventory master. But the data model of iProcurement is so complex that we don't find the right table to populate so the value appears in iprocurement.
Regards,
Jean