APPS.INV_UTILITIES dependencies on MTL_SYSTEM_ITEMS

Line 209: FROM mtl_system_items

205: END IF;
206:
207: SELECT serial_number_control_code
208: INTO serial_control_code
209: FROM mtl_system_items
210: WHERE inventory_item_id = move_ord_rec.inventory_item_id
211: AND organization_id = p_org_id;
212:
213: IF serial_control_code <> 1 THEN

Line 396: FROM MTL_SYSTEM_ITEMS

392: RETURN 'N';
393: ELSE
394: SELECT STOCK_ENABLED_FLAG,INVENTORY_ASSET_FLAG
395: INTO v_stock_enabled_flag,v_inv_asset_flag
396: FROM MTL_SYSTEM_ITEMS
397: WHERE INVENTORY_ITEM_ID = p_inventory_item_id
398: AND ORGANIZATION_ID = p_ship_to_org_id;
399:
400: IF (NVL(v_stock_enabled_flag, 'N') = 'Y' and NVL(v_inv_asset_flag,'N') = 'Y')