APPS.GMI_MSCA_PUB dependencies on IC_ITEM_CNV

Line 310: , ic_item_cnv i

306: print_debug('in uom_lov item_no='||p_item_no||'...');
307: OPEN x_uom_cursor FOR
308: SELECT u.uom_code
309: FROM sy_uoms_mst u
310: , ic_item_cnv i
311: WHERE i.um_type = u.um_type
312: AND u.uom_code like p_uom
313: AND i.item_id IN (SELECT item_id FROM ic_item_mst WHERE item_no = p_item_no)
314: AND i.delete_mark = 0