eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.EGO_ITEM_OPEN_INTERFACE_PVT dependencies on MTL_ITEM_REVISIONS_INTERFACE

Line 203: /* bug 12603272 if no row in mtl_system_items_interface marks as error status, check mtl_item_revisions_interface */

199: EXCEPTION WHEN NO_DATA_FOUND THEN
200: l_pro_flag_3 := 0;
201: END;
202:
203: /* bug 12603272 if no row in mtl_system_items_interface marks as error status, check mtl_item_revisions_interface */
204: IF l_inv_debug_level IN(101, 102) THEN
205: INVPUTLI.info('l_pro_flag_3 from table mtl_system_items_interface ' || l_pro_flag_3 );
206: END IF;
207:

Line 210: FROM mtl_item_revisions_interface

206: END IF;
207:
208: if l_pro_flag_3 = 0 then
209: SELECT count(*) INTO l_pro_flag_3
210: FROM mtl_item_revisions_interface
211: WHERE process_flag = 3
212: AND request_id = l_request_id
213: AND rownum = 1;
214: IF l_inv_debug_level IN(101, 102) THEN

Line 215: INVPUTLI.info('l_pro_flag_3 from table mtl_item_revisions_interface ' || l_pro_flag_3 );

211: WHERE process_flag = 3
212: AND request_id = l_request_id
213: AND rownum = 1;
214: IF l_inv_debug_level IN(101, 102) THEN
215: INVPUTLI.info('l_pro_flag_3 from table mtl_item_revisions_interface ' || l_pro_flag_3 );
216: END IF;
217: end if ;
218:
219: IF l_pro_flag_3 > 0 THEN

Line 265: FROM mtl_item_revisions_interface intf

261: SELECT intf.inventory_item_id
262: ,intf.organization_id
263: ,intf.revision_id
264: ,intf.revision
265: FROM mtl_item_revisions_interface intf
266: WHERE intf.set_process_id = p_xset_id
267: AND intf.transaction_type = 'CREATE'
268: AND intf.request_id = p_request_id
269: AND intf.process_flag = 7