APPS.GML_OPM_ROI_GRP dependencies on MTL_SYSTEM_ITEMS_B

Line 339: from mtl_system_items_b msi,ic_item_mst iim

335: select item_um2,item_id into l_item_um2,l_opm_item_id from ic_item_mst
336: where item_no = x_opm_record.item_num ;
337: ELSE
338: select iim.item_no , iim.item_um2 , iim.item_id into x_opm_record.item_num,l_item_um2 , l_opm_item_id
339: from mtl_system_items_b msi,ic_item_mst iim
340: where msi.inventory_item_id = x_opm_record.item_id
341: and msi.organization_id = x_opm_record.to_organization_id
342: and msi.segment1 = iim.item_no ;
343: END IF;

Line 644: FROM mtl_system_items_b

640:
641: ELSE -- LOT IS NEW
642: -- validate expiration date.
643: SELECT shelf_life_code INTO l_shelf_life_code
644: FROM mtl_system_items_b
645: WHERE inventory_item_id = p_inventory_item_id
646: AND organization_id = p_organization_id ;
647:
648: l_progress := '050' ;